Computer Science · May / June 2019 · Paper 22 · Question 6

A database table, FLIGHT, is used to keep a record of flights from a small airfield. Planes can carry passengers, freight or both. Some flights are marked as private and only carry passengers. Flight number Plane Notes Departure time Passengers FN101 Caravan 1 Private passenger flight 08:00 Y CN101 Caravan 2 Freight only 08:30 N CN102 Piper 1 Freight only 09:00 N FN104 Piper 2 Passengers only 09:20 Y FN105 Piper 1 Freight and passengers 10:00 Y FN106 Caravan 1 Passengers only 10:30 Y CN108 Caravan 2 Freight only 08:00 N CN110 Lear Private passenger flight 08:00 Y

Read automatically from the paper; the printed page above is exact.