| airportID | name | city | country |
|---|---|---|---|
| 1 | JFK International | New York | USA |
| 2 | Heathrow | London | UK |
| 3 | Charles de Gaulle | Paris | France |
| airlineID | name | headquarters |
|---|---|---|
| 1 | United Airlines | Chicago |
| 2 | British Airways | London |
| 3 | Air France | Paris |
| flightID | originAirport | destinationAirport | departureTime | arrivalTime | airlineID |
|---|---|---|---|---|---|
| (→ Airports.airportID) | (→ Airports.airportID) | (→ Airlines.airlineID) | |||
| 1 | 1 | 2 | 2023-01-01 08:00:00 | 2023-01-01 10:00:00 | 1 |
| 2 | 1 | 3 | 2023-01-01 12:00:00 | 2023-01-01 14:00:00 | 2 |
| 3 | 2 | 1 | 2023-01-01 16:00:00 | 2023-01-01 18:00:00 | 1 |
| 4 | 2 | 3 | 2023-01-01 20:00:00 | 2023-01-01 22:00:00 | 2 |
| 5 | 3 | 1 | 2023-01-02 07:00:00 | 2023-01-02 09:00:00 | 1 |
| 6 | 3 | 2 | 2023-01-02 11:00:00 | 2023-01-02 13:00:00 | 2 |
| passengerID | firstName | lastName | frequentFlyerNumber | vipStatus |
|---|---|---|---|---|
| 1 | John | Doe | 12345 | 1 |
| 2 | Jane | Smith | 67890 | 0 |
| 3 | Alice | Johnson | 34567 | 1 |
| 4 | Bob | Williams | 23456 | 0 |
| 5 | Eve | Martin | 87654 | 1 |
| amenityID | description | availableInFrequentFlyerLounge | availableInVIPLounge |
|---|---|---|---|
| 1 | Complimentary Wi-Fi | 1 | 1 |
| 2 | Power outlets at every seat | 1 | 1 |
| loungeID | airportID | amenityID |
|---|---|---|
| (→ Airports.airportID) | (→ Amenities.amenityID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| loungeID | airportID | amenityID |
|---|---|---|
| (→ Airports.airportID) | (→ Amenities.amenityID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |