Airports

AirportIDNameLocationCapacity
1JFKNew York, USA100
2LAXLos Angeles, USA80
3CDGParis, France75
4HKGHong Kong, China60
5SYDSydney, Australia90

Airlines

AirlineIDNameHeadquartersNumberOfFleets
1United AirlinesChicago, USA300
2American AirlinesDallas, USA500
3Air FranceParis, France120
4Cathay PacificHong Kong, China100
5QantasSydney, Australia70

Pilots

PilotIDFirstNameLastNameLicenseNumberHoursExperience
1JohnSmithAB1234CD5000
2JaneDoeEF5678GH4500
3MikeBrownIJ9LMNOP6000
4AliceGreenSTUVWXYZ7000
5TomBlackAB1234CD5500

Flights

FlightIDDepartureDateArrivalTimeDestinationOriginAirlinePilotStatusDisruptions
(→ Airports.AirportID)(→ Airports.AirportID)(→ Airlines.AirlineID)(→ Pilots.PilotID)
12023-01-0112:001211DelayedWeather Condition
22023-01-0215:302322On TimeNone
32023-01-0310:003133CancelledMechanical Issue
42023-01-0411:004544On TimeNone
52023-01-0513:005455DelayedMechanical Issue