Airports

idnamelocation
1New York AirportNew York City
2Los Angeles AirportCalifornia
3London HeathrowEngland
4Tokyo HanedaJapan
5Dubai InternationalUnited Arab Emirates

Terminals

idtypeairport_id
(→ Airports.id)
1International_Terminal1
2Domestic_Terminal2
3Cargo_Terminal3
4General_Aviation_Terminal4
5Private_Passenger_Terminal5

Airports_Terminals

airport_idterminal_id
(→ Airports.id)(→ Terminals.id)
11
12
23
34
45
21
31
41
51