Available_locations
| id | location |
| 1 | Entrance A |
| 2 | Departure Hall |
| 3 | Gate C |
| 4 | Baggage Claim |
| 5 | Exit D |
Airlines
| id | airlineName |
| 1 | United Airlines |
| 2 | Delta Air Lines |
| 3 | Southwest Airlines |
| 4 | American Airlines |
| 5 | JetBlue Airways |
Flights
| flightID | originLocation | destinationLocation | airlineId |
| (→ Available_locations.id) | (→ Available_locations.id) | (→ Airlines.id) |
| 1 | 1 | 2 | 1 |
| 2 | 3 | 4 | 2 |
| 3 | 1 | 5 | 3 |
| 4 | 2 | 3 | 4 |
| 5 | 4 | 1 | 5 |
Luggage_trolleys
| trolleyID | availableLocation |
| (→ Available_locations.id) |
| 1 | 1 |
| 2 | 2 |
Porters
| porterID | serviceType | availableLocation |
| | (→ Available_locations.id) |
| 1 | Assistance | 1 |
| 2 | Golf Cart Service | 2 |
Bookings
| bookingID | customerName | flightId | luggageTrolleyId | porterId |
| | (→ Flights.flightID) | (→ Luggage_trolleys.trolleyID) | (→ Porters.porterID) |
| 1 | John Doe | 1 | 1 | 1 |
| 2 | Jane Smith | 2 | None | None |
| 3 | Michael Johnson | 3 | 2 | 2 |
| 4 | Emily Davis | 4 | None | None |
| 5 | David Brown | 5 | 1 | 1 |