Airlines
| airline_id | name |
| 1 | Alaskan Airlines |
| 2 | Delta Airlines |
| 3 | United Airlines |
| 4 | Southwest Airlines |
| 5 | JetBlue Airlines |
Airplanes
| airplane_id | model | capacity | current_flight |
| | | (→ Flights.flight_id) |
| 1 | Boeing 737 | 180 | None |
| 2 | Airbus A320 | 160 | None |
| 3 | Bombardier Q400 | 65 | None |
| 4 | Embraer E190 | 80 | None |
| 5 | Boeing 787 | 250 | None |
Flights
| flight_id | departure_time | destination | airplane_id | airline_id |
| | | (→ Airplanes.airplane_id) | (→ Airlines.airline_id) |
| 1 | 2021-11-01 08:00:00 | Los Angeles | 1 | 1 |
| 2 | 2021-11-01 10:00:00 | New York | 2 | 2 |
| 3 | 2021-11-01 12:00:00 | Chicago | 3 | 3 |
| 4 | 2021-11-01 14:00:00 | Houston | 4 | 4 |
| 5 | 2021-11-01 16:00:00 | Dallas | 5 | 5 |
Passengers
| passenger_id | first_name | last_name | age | family_id |
| | | | (→ Families.family_id) |
| 1 | John | Smith | 35 | 1 |
| 2 | Jane | Doe | 28 | None |
| 3 | Michael | Johnson | 45 | 2 |
| 4 | Emily | Williams | 30 | 3 |
| 5 | David | Brown | 50 | 4 |
Boardings
| boarding_id | priority | family | passenger_id | flight_id |
| | | (→ Passengers.passenger_id) | (→ Flights.flight_id) |
| 1 | 1 | 1 | 1 | 1 |
| 2 | 0 | 0 | 2 | 2 |
| 3 | 0 | 1 | 3 | 3 |
| 4 | 0 | 0 | 4 | 4 |
| 5 | 0 | 0 | 5 | 5 |
Families
| family_id | head_of_family |
| (→ Passengers.passenger_id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |