Architects

idnameemail
1John Doejohn.doe@example.com
2Jane Smithjane.smith@example.com
3Michael Johnsonmichael.johnson@example.com
4Emily Davisemily.davis@example.com
5William Brownwilliam.brown@example.com

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

Buildings

idarchitecture_firmarchitectairport_terminal
(→ Terminals.terminal_name)
1Studio AJohn DoeTerminal 1
2Studio BJane SmithTerminal 2
3Studio CMichael JohnsonTerminal 4
4Studio DEmily DavisTerminal A
5Studio EWilliam BrownTerminal 2

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