Flights

FlightIDDepartureTimeArrivalTimeOriginDestinationAircraftTypeSeatsAvailable
12023-07-01 10:002023-07-01 14:00LASFBoeing 737100
22023-07-01 11:002023-07-01 15:00SFLAAirbus A32090
32023-07-02 08:002023-07-02 12:00NYMIEmbraer E175100

Airlines

AirlineIDNameHeadquarters
1United AirlinesChicago
2Delta AirlinesAtlanta
3Southwest AirlinesDallas

Pilots

PilotIDFirstNameLastNameLicenseNumberDateOfBirth
1JohnDoeABCD12341980-06-01
2JaneSmithEFGH56781990-05-01
3AliceWonderlandXYZL98761985-08-01

AssignPilotToFlight

FlightIDPilotID
(→ Flights.FlightID)(→ Pilots.PilotID)
11
22
33

Hotels

HotelIDNameLocationPriceAccomodationType
1Airport HotelInside the airport premises150Hotel
2Sleep PodOutside the airport near terminal150Pod
3Another Airport HotelInside the airport premises200Hotel
4Another Sleep PodOutside the airport near terminal200Pod
5Grand PlazaClose to the city center250Resort
6Economy InnFar from the city center50Motel