Aircrafts

IDModelCapacityYear
1737 MAX2162021
2A3808532019
3Boeing 7774402018
4Embraer E1951202020
5Airbus A320neo1802018

Flights

FlightIDDepartureTimeArrivalTimeOriginAirportDestinationAirportAircraftId
(→ Aircrafts.ID)
12023-04-10 08:00:002023-04-10 10:00:00LAXJFK1
22023-04-11 11:00:002023-04-11 13:00:00ORDMCO2
32023-04-12 09:00:002023-04-12 11:00:00SEAPHX3
42023-04-13 14:00:002023-04-13 16:00:00DFWMIA4
52023-04-14 17:00:002023-04-14 19:00:00IAHLAS5

Passengers

PassengerIdFirstNameLastNameDateOfBirthContactNumber
1JohnDoe1990-01-01+123456789
2JaneSmith1995-02-02+987654321
3EmmaJones2000-03-03+112345678
4WilliamBlack2005-04-04+987654320
5OliviaWhite2010-05-05+112345679

Bookings

BookingIdFlightIdPassengerIdBoardingTypeAirline
(→ Flights.FlightId)(→ Passengers.PassengerId)
111Priority BoardingAlaskan Airlines
212General BoardingUnited Airlines
323Family BoardingAlaskan Airlines
424General BoardingDelta Airlines
535Priority BoardingSouthwest Airlines
636Family BoardingAmerican Airlines
747General BoardingJetBlue Airlines
848Priority BoardingSpirit Airlines
959Family BoardingFrontier Airlines
10510General BoardingVirgin America