Languages

LanguageIDName
1English
2Spanish
3French
4German
5Italian

Airports

AirportIDNameCityCountry
1JFKNew YorkUSA
2LAXLos AngelesUSA
3MADMadridSpain
4CDGParisFrance
5FRAFrankfurtGermany

Staff

StaffIDFirstNameLastNamePositionAirportIDLanguageID
(→ Airports.AirportID)(→ Languages.LanguageID)
1JohnDoeGate Agent11
2JaneSmithPilot23
3EmilyBrownGate Agent32
4DavidWhitePilot41
5AliceBlackGate Agent54

Flights

FlightIDDepartureTimeArrivalTimeOriginAirportIDDestinationAirportIDAssignedStaffID
(→ Airports.AirportID)(→ Airports.AirportID)(→ Staff.StaffID)
12023-01-01 08:002023-01-01 10:00121
22023-01-01 16:002023-01-01 18:00212
32023-01-02 09:002023-01-02 11:00343
42023-01-02 17:002023-01-02 19:00434
52023-01-03 08:002023-01-03 10:00525