## 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