Airports

idnamelocation
1New York JFKNew York City, USA
2Los Angeles LAXLos Angeles, USA
3London HeathrowLondon, UK
4Paris CDGParis, France
5Tokyo NaritaTokyo, Japan

Terminals

idairport_idterminal_namecapacity
(→ Airports.id)
11Terminal 120
21Terminal 230
32Terminal 440
43Terminal 250
54Terminal A60

Flights

idflight_numberdeparture_airportarrival_airport
(→ Airports.name)(→ Airports.name)
1AA123New York JFKLondon Heathrow
2DL456Los Angeles LAXParis CDG
3BA789London HeathrowNew York JFK
4AF101Paris CDGTokyo Narita
5LH234Frankfurt FRANew York JFK

Buildings

idBuilding_Designairport_terminal
(→ Terminals.terminal_name)
1Studio ATerminal 1
2Studio BTerminal 2
3Studio CTerminal 4
4Studio DTerminal A
5Studio ETerminal 2