Languages
| LanguageID | Name |
| 1 | English |
| 2 | Spanish |
| 3 | French |
| 4 | German |
| 5 | Italian |
Airports
| AirportID | Name | City | Country |
| 1 | JFK | New York | USA |
| 2 | LAX | Los Angeles | USA |
| 3 | MAD | Madrid | Spain |
| 4 | CDG | Paris | France |
| 5 | FRA | Frankfurt | Germany |
Staff
| StaffID | FirstName | LastName | Position | AirportID | LanguageID |
| | | | (→ Airports.AirportID) | (→ Languages.LanguageID) |
| 1 | John | Doe | Gate Agent | 1 | 1 |
| 2 | Jane | Smith | Pilot | 2 | 3 |
| 3 | Emily | Brown | Gate Agent | 3 | 2 |
| 4 | David | White | Pilot | 4 | 1 |
| 5 | Alice | Black | Gate Agent | 5 | 4 |
Flights
| FlightID | DepartureTime | ArrivalTime | OriginAirportID | DestinationAirportID | AssignedStaffID |
| | | (→ Airports.AirportID) | (→ Airports.AirportID) | (→ Staff.StaffID) |
| 1 | 2023-01-01 08:00 | 2023-01-01 10:00 | 1 | 2 | 1 |
| 2 | 2023-01-01 16:00 | 2023-01-01 18:00 | 2 | 1 | 2 |
| 3 | 2023-01-02 09:00 | 2023-01-02 11:00 | 3 | 4 | 3 |
| 4 | 2023-01-02 17:00 | 2023-01-02 19:00 | 4 | 3 | 4 |
| 5 | 2023-01-03 08:00 | 2023-01-03 10:00 | 5 | 2 | 5 |