id | Name | Experience | Salary | Training_Center |
---|---|---|---|---|
1 | John Doe | 8 | 60000 per year | ATC Academy |
2 | Jane Smith | 12 | 70000 per year | Aviation Institute |
id | Name | Experience | Salary | Role |
---|---|---|---|---|
1 | Mike Johnson | 5 | 60000 per year | Baggage Handler |
2 | Emma Brown | 3 | 55000 per year | Gate Agent |
id | Date | Time | Destination | Pilot_id |
---|---|---|---|---|
(→ Pilots.id) | ||||
1 | 2022-01-01 | 10:00:00 | New York | 1 |
2 | 2022-01-02 | 15:00:00 | Los Angeles | 2 |
id | Name | License_Number | Total_Flights |
---|---|---|---|
1 | Tom Williams | ABCD1234 | 300 |
2 | Linda Davis | EFGH5678 | 500 |
id | Length | Width | Location |
---|---|---|---|
1 | 9000.0 | 150.0 | Chicago O'Hare International Airport |
2 | 8000.0 | 140.0 | Dallas/Fort Worth International Airport |
id | Model | Registration_number | Capacity | Current_Location |
---|---|---|---|---|
(→ Runway.id) | ||||
1 | Boeing 737 | N12345 | 200 | 1 |
2 | Airbus A320 | N67890 | 220 | 2 |