Airports
| id | name | location |
| 1 | New York JFK | New York City, USA |
| 2 | Los Angeles LAX | Los Angeles, USA |
| 3 | London Heathrow | London, UK |
| 4 | Paris CDG | Paris, France |
| 5 | Tokyo Narita | Tokyo, Japan |
Terminals
| id | airport_id | terminal_name | capacity |
| (→ Airports.id) | | |
| 1 | 1 | Terminal 1 | 20 |
| 2 | 1 | Terminal 2 | 30 |
| 3 | 2 | Terminal 4 | 40 |
| 4 | 3 | Terminal 2 | 50 |
| 5 | 4 | Terminal A | 60 |
Flights
| id | flight_number | departure_airport | arrival_airport |
| | (→ Airports.name) | (→ Airports.name) |
| 1 | AA123 | New York JFK | London Heathrow |
| 2 | DL456 | Los Angeles LAX | Paris CDG |
| 3 | BA789 | London Heathrow | New York JFK |
| 4 | AF101 | Paris CDG | Tokyo Narita |
| 5 | LH234 | Frankfurt FRA | New York JFK |
Buildings
| id | Building_Design | airport_terminal |
| | (→ Terminals.terminal_name) |
| 1 | Studio A | Terminal 1 |
| 2 | Studio B | Terminal 2 |
| 3 | Studio C | Terminal 4 |
| 4 | Studio D | Terminal A |
| 5 | Studio E | Terminal 2 |