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 |