International_Flights

FlightIDDestinationDeparture_TimeBoarding_TimePassenger_Capacity
1London9:00 AM10:00 AM300
2Paris8:00 AM9:00 AM250
3Tokyo6:00 PM7:00 PM350
4Dubai10:00 AM11:00 AM320
5Singapore12:00 PM1:00 PM330

Domestic_Flights

FlightIDDestinationDeparture_TimeBoarding_TimePassenger_Capacity
1New York11:00 AM12:00 PM150
2Los Angeles2:00 PM3:00 PM200
3Chicago4:00 PM5:00 PM180
4Miami6:00 PM7:00 PM220
5San Francisco8:00 PM9:00 PM190

Airlines

AirlineIDNameHeadquarters
1United AirlinesChicago
2American AirlinesFort Worth
3Delta AirlinesAtlanta
4Southwest AirlinesDallas
5Alaska AirlinesSeattle

Pilots

PilotIDFirstNameLastNameLicenseNumberExperienceInHours
1JohnSmithABC12310000
2JaneDoeXYZ78912000
3MichaelBrownRST45611000
4EmilyWhiteTUV32113000
5DavidBlackWQA91014000

Flights

FlightIDAirlineIDFlightTypeDeparture_AirportArrival_Airport
(→ Airlines.AirlineID)(→ International_Flights.FlightType)
11InternationalJFKHeathrow
22DomesticLAXORD
33InternationalATLYVR
44DomesticMIASEA
55InternationalSFOPEK

Planes

ModelCapacityRegistrationNumber
Boeing 747350N12345
Boeing 737200N54321
Airbus A380400N65432
Airbus A320180N76543
Bombardier CRJ100N87654

AssignedPlanes

FlightIDPlaneModelAssignmentDate
(→ Flights.FlightID)(→ Planes.Model)
1Boeing 7472021-10-01 10:00:00
2Boeing 7372021-10-02 10:00:00
3Airbus A3802021-10-03 10:00:00
4Airbus A3202021-10-04 10:00:00
5Bombardier CRJ2021-10-05 10:00:00