## 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