Flight

FlightIDDepartureTimeDestination
12022-01-01 09:00:00New York
22022-01-02 10:00:00London
32022-01-03 11:00:00Tokyo
42022-01-04 12:00:00Paris
52022-01-05 13:00:00Dubai

Airline

CompanyNameHeadquartersNumberofEmployees
British AirwaysUK10000
American AirlinesUSA120000
All Nippon AirwaysJapan68000
Air FranceFrance25000
EmiratesUAE35000

Passengers

PassengerIDNameAge
1John Doe25
2Jane Smith30
3Michael Johnson40
4Linda Brown35
5David Wilson50

AirlinesAndFlights

AirlinesIDFlightsID
(→ Airline.CompanyName)(→ Flight.FlightID)
11
12
23
34
45

Airports

AirportIDCityCountry
1LondonUnited Kingdom
2New YorkUSA
3TokyoJapan
4ParisFrance
5DubaiUAE

AirportDetails

AirportIDPassenger_ThroughputNumber_Of_AircraftsLatitudeLongitude
(→ Airports.AirportID)
1100002051.5074-0.1278
2500005040.7128-74.006
3200005035.6895139.6917
4250004048.85662.3522
5100002025.204855.2708