Available_locations

idlocation
1Entrance A
2Departure Hall
3Gate C
4Baggage Claim
5Exit D

Airlines

idairlineName
1United Airlines
2Delta Air Lines
3Southwest Airlines
4American Airlines
5JetBlue Airways

Flights

flightIDoriginLocationdestinationLocationairlineId
(→ Available_locations.id)(→ Available_locations.id)(→ Airlines.id)
1121
2342
3153
4234
5415

Luggage_trolleys

trolleyIDavailableLocation
(→ Available_locations.id)
11
22

Porters

porterIDserviceTypeavailableLocation
(→ Available_locations.id)
1Assistance1
2Golf Cart Service2

Bookings

bookingIDcustomerNameflightIdluggageTrolleyIdporterId
(→ Flights.flightID)(→ Luggage_trolleys.trolleyID)(→ Porters.porterID)
1John Doe111
2Jane Smith2NoneNone
3Michael Johnson322
4Emily Davis4NoneNone
5David Brown511