Flights

FlightIDDepartureTimeArrivalTimeDestinationAircraftType
108:30:0010:30:00New YorkBoeing 737
209:00:0011:00:00Los AngelesAirbus A320
310:00:0012:00:00ChicagoEmbraer E190

Passengers

PassengerIDFirstNameLastNameAge
1JohnDoe35
2JaneSmith28
3MikeJohnson45
4EmilyWilliams32
5DavidMartinez50

Bookings

BookingIDFlightIDPassengerID
(→ Flights.FlightID)(→ Passengers.PassengerID)
111
222
333
414
525

Amenities

AmenityIDName
1Airport Lounge
2Business Class Lounge
3Observation Deck
4Kids Play Area

Accessibilities

AccessibilityIDDescription
1Wheelchair Users
2Parents with Strollers
3Visually Impaired

PassengerAmenities

PassengerAmenityIDPassengerIDAmenityIDAccessibilityID
(→ Passengers.PassengerID)(→ Amenities.AmenityID)(→ Accessibilities.AccessibilityID)
1111
2212
3331
4433
5121
6242
7313
8433
9521