## 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