Luggage_Trolleys

IDAvailable_LocationNumber_Of_TrolleysLast_MaintenanceCurrent_Condition
1Entrance B102023-04-01Excellent
2Departures C52023-03-26Good

Porters

IDNameAvailable_LocationAvailabilityContact_Number
1John SmithEntrance B1+1234567890
2Jane DoeArrivals A0+9876543210

Passengers

IDFirst_NameLast_NameFlight_ID
(→ Flights.ID)
1AliceSmith1
2BobJohnson2

Checked_Baggage

IDPassenger_IDFlight_IDWeight
(→ Passengers.ID)(→ Flights.ID)
11120
22225

CarRental

IDRenter_IDVehicle_TypePickup_DateDropoff_Date
(→ Passengers.ID)
11Compact2023-04-05 08:00:002023-04-10 18:00:00
22SUV2023-04-06 09:00:002023-04-11 17:00:00