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 |