Systems
| SystemID | Name | Type |
| 1 | NavSys | Navigation System |
| 2 | CommsSys | Communication System |
Airports
| AirportID | Name |
| 1 | Heathrow |
| 2 | JFK |
AirportSystemAssociations
| AssociationID | AirportID | SystemID |
| (→ Airports.AirportID) | (→ Systems.SystemID) |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 1 | 2 |
| 4 | 2 | 2 |
Flights
| FlightID | DepartureTime | ArrivalTime | OriginAirportID | DestinationAirportID |
| | | (→ Airports.AirportID) | (→ Airports.AirportID) |
| 1 | 2023-01-01 08:00 | 2023-01-01 10:00 | 1 | 2 |
| 2 | 2023-01-01 10:00 | 2023-01-01 12:00 | 2 | 1 |
Pilots
| PilotID | Name | LicenseNumber |
| 1 | John Doe | ABC123 |
| 2 | Jane Smith | XYZ789 |
AssignedFlights
| AssignmentID | FlightID | PilotID | AssignedDate |
| (→ Flights.FlightID) | (→ Pilots.PilotID) | |
| 1 | 1 | 1 | 2024-03-13 11:41:33 |
| 2 | 2 | 2 | 2024-03-13 11:41:33 |