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 |