Pick_Up_Locations

IDLocationName
1Zone A
2Zone B
3Zone C
4Zone D
5Zone E

Airlines

AirlineIDNameCode
1AmericanAA
2UnitedUA
3DeltaDL
4SouthwestWN
5AlaskaAS

Flights

FlightNumberDepartureTimeDestinationOriginAirlineID
(→ Airlines.AirlineID)
1012023-04-01 10:00:00New YorkLos Angeles1
1022023-04-01 11:00:00San FranciscoChicago2
1032023-04-01 12:00:00DallasAtlanta3
1042023-04-01 13:00:00SeattleHonolulu4
1052023-04-01 14:00:00MiamiBoston5

Passengers

PassengerIDFirstNameLastNamePhoneNumberEmailPickedUpFrom
(→ Pick_Up_Locations.ID)
1JohnDoe+1234567890john.doe@example.comNone
2JaneSmith+0987654321jane.smith@example.comNone
3MichaelJohnson+1112223333michael.johnson@example.comNone
4EmilyWilliams+2223334444emily.williams@example.comNone
5DavidBrown+3334445555david.brown@example.comNone

Rentals

RentalIDPickUpDateDropOffDateCarModelCustomerIDPickUpLocationID
(→ Passengers.PassengerID)(→ Pick_Up_Locations.ID)
12023-04-01 09:00:002023-04-01 18:00:00Toyota Camry11
22023-04-02 09:00:002023-04-02 18:00:00Ford Explorer22
32023-04-03 09:00:002023-04-03 18:00:00Chevrolet Malibu33
42023-04-04 09:00:002023-04-04 18:00:00Nissan Altima44
52023-04-05 09:00:002023-04-05 18:00:00Honda Accord55

Shuttles

ShuttleIDScheduleTerminalCapacityPickUpLocationID
(→ Pick_Up_Locations.ID)
12023-04-01 07:00:001101
22023-04-02 07:00:002122
32023-04-03 07:00:00383
42023-04-04 07:00:004104
52023-04-05 07:00:005125