Systems

SystemIDNameType
1NavSysNavigation System
2CommsSysCommunication System

Airports

AirportIDName
1Heathrow
2JFK

AirportSystemAssociations

AssociationIDAirportIDSystemID
(→ Airports.AirportID)(→ Systems.SystemID)
111
221
312
422

Flights

FlightIDDepartureTimeArrivalTimeOriginAirportIDDestinationAirportID
(→ Airports.AirportID)(→ Airports.AirportID)
12023-01-01 08:002023-01-01 10:0012
22023-01-01 10:002023-01-01 12:0021

Pilots

PilotIDNameLicenseNumber
1John DoeABC123
2Jane SmithXYZ789

AssignedFlights

AssignmentIDFlightIDPilotIDAssignedDate
(→ Flights.FlightID)(→ Pilots.PilotID)
1112024-03-13 11:41:33
2222024-03-13 11:41:33