Airports
| id | name | city | country |
| 1 | JFK International | New York | USA |
| 2 | Heathrow | London | UK |
Flight
| flightNumber | departureTime | arrivalTime | destinationId | airlineId |
| | | (→ Airports.id) | (→ Airlines.id) |
| 101 | 2022-10-29 08:00:00 | 2022-10-29 10:00:00 | 1 | 1 |
| 102 | 2022-10-29 16:00:00 | 2022-10-29 17:00:00 | 2 | 2 |
Airlines
| id | name | headquarterCity | website |
| 1 | British Airways | London | www.ba.com |
| 2 | American Airlines | Dallas | www.aa.com |
| 3 | Delta Airlines | Atlanta | www.delta.com |
| 4 | United Airlines | Chicago | www.united.com |
Staff
| staffID | firstName | lastName | role | airportID | languageID |
| | | | (→ Airports.id) | (→ Languages.id) |
| 1 | John | Smith | Gate Agent | 1 | 1 |
| 2 | Emily | Doe | Gate Agent | 1 | 2 |
| 3 | Michael | Jackson | Pilot | 1 | 1 |
| 4 | Paula | Abdul | Pilot | 1 | 2 |
Languages
| id | language |
| 1 | Spanish |
| 2 | English |
GateAgents
| agentID | staffID |
| (→ Staff.staffID) |
| 1 | 1 |
| 2 | 2 |
Pilots
| pilotID | staffID |
| (→ Staff.staffID) |
| 1 | 3 |
| 2 | 4 |