Airports

idnamecitycountry
1JFK InternationalNew YorkUSA
2HeathrowLondonUK

Flight

flightNumberdepartureTimearrivalTimedestinationIdairlineId
(→ Airports.id)(→ Airlines.id)
1012022-10-29 08:00:002022-10-29 10:00:0011
1022022-10-29 16:00:002022-10-29 17:00:0022

Airlines

idnameheadquarterCitywebsite
1British AirwaysLondonwww.ba.com
2American AirlinesDallaswww.aa.com
3Delta AirlinesAtlantawww.delta.com
4United AirlinesChicagowww.united.com

Staff

staffIDfirstNamelastNameroleairportIDlanguageID
(→ Airports.id)(→ Languages.id)
1JohnSmithGate Agent11
2EmilyDoeGate Agent12
3MichaelJacksonPilot11
4PaulaAbdulPilot12

Languages

idlanguage
1Spanish
2English

GateAgents

agentIDstaffID
(→ Staff.staffID)
11
22

Pilots

pilotIDstaffID
(→ Staff.staffID)
13
24