Populate the tables with values given below. Data is case-sensitive PASSENGER TA
ID: 3717852 • Letter: P
Question
Populate the tables with values given below. Data is case-sensitive PASSENGER TABLE PASSENGERID PASSENGERNAME PASSENGERDOB PASSENGERPHONE PASSENGERNATIONALITY P1 P2 P3 PETER DUTTON TAMER ARMANI MR. BEAN NARDIN YOUSSIF NICOLE KIDMAN MO SALAH VLADIMIR PUTIN 11-APR-1980 (02) 7894 5612 15-MAY-1995 (07) 2233 5698 (05) 9856 2232 11-AUG-198503) 7458 3333 (02) 2121 4545 AUSTRALIAN 11-AUG-1985 ENGLISH P5 20-SEP-2011 11-SPE-1999(01) 4450 AUSTRALIAN EGYPTIAN P7 1949 09) 9999 8888 RCRAFTID AIRCRAFTMAKE AIRCRAFTMODEL ACITY 120 180 US BUS TABL LIGHTNO EPARTURECITY YDNEY ARIS ALCITY DEPARTUREDATE EW DELHI 2-FEB-18 02 03 FEB-18 EB-18 18 ELBOUNE SYDNEY SYDNEY ARIS APR-18Explanation / Answer
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P1','PETER DUTTON','11-APR-1980','(02) 7984 5612','AUSTRAILIAN');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P2','TAMER ARMANI','15-MAY-1995','(07) 2233 5698','TURKISH');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P3','MR. BEAN','11-AUG-1985','(05) 9856 2232','ENGLISH');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P4','NARDIN YOUSSIF','11-AUG-1985','(03) 7458 3333','AUSTRAILIAN');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P5','NICOLE KIDMAN','20-SEP-2011','(02) 2121 4545','AUSTRAILIAN');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P6','MO SALAH','11-SEP-1999','(01) 4450 9092','EGYPTIAN');
Insert into Passenger(PassengerId,PassengerName,PassengerDOB,PassengerPhone,PassengerNationality) values ('P7','VLADIMIR PUTIN','03-JAN-1948','(09) 9999 8888','RUSSIAN');
Insert into Aircraft(AircraftId,AircraftMake,AircraftModel,Capacity) values ('C1','BOEING',707,120);
Insert into Aircraft(AircraftId,AircraftMake,AircraftModel,Capacity) values ('C2','BOEING',777,180);
Insert into Aircraft(AircraftId,AircraftMake,AircraftModel,Capacity) values ('C3','AIRBUS',310,80);
Insert into Aircraft(AircraftId,AircraftMake,AircraftModel,Capacity) values ('C4','AIRBUS',380,50);
Insert into Flight ( FlightNo,DepartureCity,ArrivalCity,DepartureDate) values ( 'F01','SYDNEY','NEW DELHI','2-FEB-18');
Insert into Flight ( FlightNo,DepartureCity,ArrivalCity,DepartureDate) values ( 'F02','PARIS','LONDON','5-FEB-18');
Insert into Flight ( FlightNo,DepartureCity,ArrivalCity,DepartureDate) values ( 'F03','LONDON','CAIRO','20-FEB-18');
Insert into Flight ( FlightNo,DepartureCity,ArrivalCity,DepartureDate) values ( 'F04','MELBORNE','SYDNEY','20-MAR-18');
Insert into Flight ( FlightNo,DepartureCity,ArrivalCity,DepartureDate) values ( 'F05','SYDNEY','PARIS','2-APR-18');
Do ask if any doubt.