Languages
id | language |
1 | English |
2 | French |
3 | German |
4 | Japanese |
5 | Russian |
Pilots
id | name | licenseNumber | speaksId |
| | | (→ Languages.id) |
1 | John Doe | 1234567890 | 1 |
2 | Mary Smith | 987654321 | 2 |
3 | Alice Johnson | 5555555555 | 3 |
4 | Bob Brown | 4444444444 | 4 |
5 | Charlie Green | 3333333333 | 5 |
GateAgents
id | name | gateNumber | speaksId |
| | | (→ Languages.id) |
1 | Paul White | A1 | 1 |
2 | Tom Black | C5 | 2 |
3 | Lucy Blue | D12 | 3 |
4 | Kelly Red | E14 | 4 |
5 | Hannah Pink | F20 | 5 |
Flights
flightNumber | departureTime | arrivalTime | pilotId | gateAgentId |
| | | (→ Pilots.id) | (→ GateAgents.id) |
101 | 2022-01-01 08:00 | 2022-01-01 10:00 | 1 | 1 |
102 | 2022-01-01 09:00 | 2022-01-01 11:00 | 2 | 2 |
103 | 2022-01-01 10:00 | 2022-01-01 12:00 | 3 | 3 |
104 | 2022-01-01 11:00 | 2022-01-01 13:00 | 4 | 4 |
105 | 2022-01-01 12:00 | 2022-01-01 14:00 | 5 | 5 |
Passengers
passengerId | firstName | lastName | age |
1 | Alexander | Smith | 25 |
2 | Emma | Williams | 30 |
3 | David | Jones | 40 |
4 | Daniel | Black | 50 |
5 | Laura | White | 60 |