## Aircraft

id | Name
--- | ---
1 | Boeing 787 Dreamliner
2 | Airbus A380

## Onboard_Services

id | Service_name | Aircraft_id
--- | --- | ---
|  | (→ Aircraft.id)
1 | Free WiFi | 1
2 | Meals | 2
3 | In-flight magazines | 2

## Inflight_Entertainments

id | Entertainment_name | Aircraft_id
--- | --- | ---
|  | (→ Aircraft.id)
1 | Movies | 1
2 | Music | 2
3 | Games | 2

## Passengers

id | First_name | Last_name | Age | Flight_number
--- | --- | --- | --- | ---
|  |  |  | (→ Flights.id)
1 | John | Doe | 35 | 101
2 | Jane | Smith | 28 | 102
3 | Alice | Johnson | 42 | 103
4 | Bob | Williams | 60 | 104
5 | Emma | Martin | 22 | 105

## Flights

id | Departure_time | Arrival_time | Origin_airport | Destination_airport | Aircraft_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Aircraft.id)
101 | 2022-11-01 10:00 | 2022-11-01 14:00 | LAX | ORD | 1
102 | 2022-11-02 09:30 | 2022-11-02 13:30 | DFW | YUL | 1
103 | 2022-11-03 10:00 | 2022-11-03 14:00 | LAX | JFK | 2
104 | 2022-11-04 09:30 | 2022-11-04 13:30 | DFW | YYZ | 2
105 | 2022-11-05 10:00 | 2022-11-05 14:00 | LAX | LHR | 2

## Baggage

id | Weight_kg | Type | Flight_number
--- | --- | --- | ---
|  |  | (→ Flights.id)
1 | 25 | Checked Luggage | 101
2 | 10 | Carry-on Luggage | 102
3 | 15 | Checked Luggage | 103
4 | 5 | Carry-on Luggage | 104
5 | 20 | Checked Luggage | 105