- Pilot Pilotnum Pilotname Birthdate Hiredate Flight Flightnum Date Deptime Arrtime Pilotnum Planenum Passenger 1 (53.12 KiB) Viewed 45 times
PILOT(pilotnum, pilotname, birthdate, hiredate) FLIGHT(flightnum, date, deptime, arrtime, pilotnum, planenum) PASSENGER(passnum, passname, address, phone) RESERVATION(flightnum, date, passnum, fare, resvdate) AIRPLANE(planenum, model, capacity, yearbuilt, manuf) Write SQL SELECT commands to answer the following queries. (i) Find the records for the airplanes manufactured by Boeing. (1.5 marks) (ii) How many reservations are there for flight 278 on February 21, 2004? (2 marks) (iii) List the flights on March 7, 2004 that are scheduled to depart between 10 and 11AM or that are scheduled to arrive after 3PM on that date. (2.5 marks) (iv) How many of each model of Boeing aircraft does Grand Travel have? (2 marks) (v) List the names and dates of hire of the pilots, who flew Airbus A320 aircraft in March, 2004. (3.5 marks) (vi) List the names, addresses, and telephone numbers of the passengers who have reservations on Flight 562 on January 15, 2004. (2.5 marks) (vii) List the Airbus A310s that are larger (in terms of passenger capacity) than the smallest Boeing 737s. (5 marks)