## Development_Projects

ID | ProjectName | Increased_Capacity | StartDate | EndDate | Cost
--- | --- | --- | --- | --- | ---
1 | Airport Expansion | 1000 Passengers per Day | 2023-01-01 | 2023-12-31 | 1000000.0
2 | Airport Expansion | 500 Passengers per Day | 2024-01-01 | 2024-12-31 | 800000.0
3 | Renovation | 1000 Passengers per Day | 2023-07-01 | 2023-12-31 | 600000.0
4 | Renovation | 500 Passengers per Day | 2024-01-01 | 2024-12-31 | 500000.0
5 | Terminal Upgrade | 200 Passengers per Day | 2023-09-01 | 2023-12-31 | 400000.0

## Aircraft

ID | Model | Capacity | Manufacturer | Year
--- | --- | --- | --- | ---
1 | Boeing 737 MAX | 230 | Boeing | 2022
2 | Airbus A320neo | 180 | Airbus | 2021
3 | Embraer E195-E2 | 120 | Embraer | 2019
4 | Bombardier CRJ900 | 90 | Bombardier | 2018
5 | De Havilland Canada DHC-8 Q400 | 78 | De Havilland Canada | 2017

## Flight

ID | DepartureTime | ArrivalTime | Origin | Destination | AircraftID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Aircraft.ID)
1 | 07:00 AM | 08:30 AM | New York | Los Angeles | 1
2 | 09:00 AM | 10:30 AM | Chicago | Miami | 2
3 | 11:00 AM | 12:30 PM | San Francisco | Honolulu | 3
4 | 01:00 PM | 03:30 PM | Dallas | Atlanta | 4
5 | 03:00 PM | 05:30 PM | Philadelphia | Orlando | 5

## Staff

ID | Name | Position | Salary | HireDate
--- | --- | --- | --- | ---
1 | John Doe | Pilot | 75000.0 | 2021-01-01
2 | Jane Smith | Flight Attendant | 50000.0 | 2020-07-01
3 | Tom Johnson | Mechanic | 55000.0 | 2019-01-01
4 | Emily Brown | Air Traffic Controller | 60000.0 | 2018-01-01
5 | William Davis | Security Officer | 40000.0 | 2017-01-01