Flight_Attendants
id | Name | Age | Experience_Years | Training_Center |
| | | | (→ Aviation_Academies.Name) |
1 | John Doe | 30 | 8.5 | Aviation Academy |
2 | Jane Smith | 27 | 6.5 | Global Aero Institute |
Pilots
id | Name | Age | Licenses | Training_Center |
| | | | (→ Aviation_Academies.Name) |
1 | Michael Johnson | 32 | {ATPL, CPL} | Aviation Academy |
2 | Emily Brown | 31 | {ATPL, CPL} | World Flight School |
Aviation_Academies
id | Name | Location | Years_Operating |
1 | Aviation Academy | New York | 25 |
2 | Global Aero Institute | Los Angeles | 10 |
Airlines
id | Name | Headquarters | Fleet_Size |
1 | American Airlines | Fort Worth, TX | 953 |
2 | Delta Airlines | Atlanta, GA | 755 |
Aircrafts
id | Model | Manufacturer | Year_Manufactured |
1 | Boeing 737 | Boeing | 1967 |
2 | Airbus A320 | Airbus | 1988 |
Flight_Routes
id | Route_Number | Origin_Airport | Destination_Airport | Distance |
1 | AA123 | DFW | LAX | 2000.0 |
2 | DL456 | ATL | MIA | 1500.0 |