## 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 | 186e16">Gate Agent | 1 | 1
2 | Jane | Smith | Pilot | 2 | 3
3 | Emily | Brown | Gate Agent | 3 | 2
4 | David | White | 186e16">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