## Air_traffic_controller

id | Name | Experience | Salary | Training_Center
--- | --- | --- | --- | ---
1 | John Doe | 8 | 60000 per year | ATC Academy
2 | Jane Smith | 12 | 70000 per year | Aviation Institute

## Ground_staff

id | Name | Experience | Salary | Role
--- | --- | --- | --- | ---
1 | Mike Johnson | 5 | 60000 per year | Baggage Handler
2 | Emma Brown | 3 | 55000 per year | Gate Agent

## Flight

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

## Pilots

id | Name | License_Number | Total_Flights
--- | --- | --- | ---
1 | Tom Williams | ABCD1234 | 300
2 | Linda Davis | EFGH5678 | 500

## Runway

id | Length | Width | Location
--- | --- | --- | ---
1 | 9000.0 | 150.0 | Chicago O'Hare International Airport
2 | 8000.0 | 140.0 | Dallas/Fort Worth International Airport

## Planes

id | Model | Registration_number | Capacity | Current_Location
--- | --- | --- | --- | ---
|  |  |  | (→ Runway.id)
1 | Boeing 737 | N12345 | 200 | 1
2 | Airbus A320 | N67890 | 220 | 2