Airlines

idnameheadquarter_city
1DeltaAtlanta
2UnitedChicago
3SouthwestDallas
4AmericanFort Worth
5AlaskaSeattle

Flight

flight_idairline_iddeparture_timearrival_timeorigin_airportdestination_airport
(→ Airlines.id)
112023-08-01 09:00:002023-08-01 11:00:00ATLLAX
222023-08-01 10:00:002023-08-01 12:00:00ORDIAD
332023-08-01 11:00:002023-08-01 13:00:00DFWMIA
442023-08-01 12:00:002023-08-01 14:00:00SEAPHX
512023-08-01 15:00:002023-08-01 17:00:00ATLLAX

Aircrafts

aircraft_idmodelcapacitycurrent_flight_id
(→ Flight.flight_id)
1Boeing 767200None
2Airbus A320150None
3Embraer E19080None
4Bombardier CRJ70050None
5Airbus A380400None

Passengers

passenger_idfirst_namelast_namedate_of_birthpassport_numberemailphone_number
1JohnSmith1990-05-15AB1234CDjohnsmith@email.com+1234567890
2AnnaKarenina1985-06-20EF5678GHannakarenina@email.com+1234567890
3MichaelScott1970-07-10JK987LNmscott@email.com+1234567890
4EmmaSwanson1995-08-05LM890QPemmaswanson@email.com+1234567890
5DanielPlainview1960-09-15NO456RPdanielplainview@email.com+1234567890

Bookings

booking_idflight_idpassenger_idseat_number
(→ Flight.flight_id)(→ Passengers.passenger_id)
1111A
22212B
33322E
44428D
5551F

Transportations

transportation_idservice_typepick_up_locationdrop_off_locationavailable_hoursprice
1Rental CarZone DTerminal B08:00:0050
2Rental CarZone CTerminal A08:00:0050
3Airport ShuttleZone DTerminal B08:00:0020
4Airport ShuttleZone CTerminal A08:00:0020