Airports

airportIDnamecitycountry
1JFK InternationalNew YorkUSA
2HeathrowLondonUK
3Charles de GaulleParisFrance

Airlines

airlineIDnameheadquarters
1United AirlinesChicago
2British AirwaysLondon
3Air FranceParis

Flights

flightIDoriginAirportdestinationAirportdepartureTimearrivalTimeairlineID
(→ Airports.airportID)(→ Airports.airportID)(→ Airlines.airlineID)
1122023-01-01 08:00:002023-01-01 10:00:001
2132023-01-01 12:00:002023-01-01 14:00:002
3212023-01-01 16:00:002023-01-01 18:00:001
4232023-01-01 20:00:002023-01-01 22:00:002
5312023-01-02 07:00:002023-01-02 09:00:001
6322023-01-02 11:00:002023-01-02 13:00:002

Passengers

passengerIDfirstNamelastNamefrequentFlyerNumbervipStatus
1JohnDoe123451
2JaneSmith678900
3AliceJohnson345671
4BobWilliams234560
5EveMartin876541

Amenities

amenityIDdescriptionavailableInFrequentFlyerLoungeavailableInVIPLounge
1Complimentary Wi-Fi11
2Power outlets at every seat11

FrequentFlyerLounges

loungeIDairportIDamenityID
(→ Airports.airportID)(→ Amenities.amenityID)
111
222

VIPLounges

loungeIDairportIDamenityID
(→ Airports.airportID)(→ Amenities.amenityID)
111
222