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 |