Luggage_Trolleys
ID | Available_Location | Number_Of_Trolleys | Last_Maintenance | Current_Condition |
1 | Entrance B | 10 | 2023-04-01 | Excellent |
2 | Departures C | 5 | 2023-03-26 | Good |
Porters
ID | Name | Available_Location | Availability | Contact_Number |
1 | John Smith | Entrance B | 1 | +1234567890 |
2 | Jane Doe | Arrivals A | 0 | +9876543210 |
Passengers
ID | First_Name | Last_Name | Flight_ID |
| | | (→ Flights.ID) |
1 | Alice | Smith | 1 |
2 | Bob | Johnson | 2 |
Checked_Baggage
ID | Passenger_ID | Flight_ID | Weight |
| (→ Passengers.ID) | (→ Flights.ID) | |
1 | 1 | 1 | 20 |
2 | 2 | 2 | 25 |
CarRental
ID | Renter_ID | Vehicle_Type | Pickup_Date | Dropoff_Date |
| (→ Passengers.ID) | | | |
1 | 1 | Compact | 2023-04-05 08:00:00 | 2023-04-10 18:00:00 |
2 | 2 | SUV | 2023-04-06 09:00:00 | 2023-04-11 17:00:00 |