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 |