## 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