## Meteorological_Offices

id | name | location
--- | --- | ---
1 | Office A | New York
2 | Office B | Chicago
3 | Office C | Los Angeles
4 | Office D | Dallas
5 | Office E | Atlanta

## Data_Sources

id | source_type | description
--- | --- | ---
1 | Automated_Weather_Station | Collects real-time weather data.
2 | Radar_System | Tracks precipitation and storm systems.
3 | Satellite | Monitors global atmospheric conditions.
4 | Wind_Sensor | Measures wind speed and direction.
5 | Temperature_Sensor | Records ambient temperature.

## Meteorological_Offices_Data_Sources

meteo_office_id | data_source_id
--- | ---
(→ Meteorological_Offices.id) | (→ Data_Sources.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 3

## Terminals

id | terminal_name | capacity
--- | --- | ---
1 | Terminal 1 | 5000
2 | Terminal 2 | 4500
3 | Terminal 3 | 4000
4 | Terminal 4 | 3500
5 | Terminal 5 | 3000

## Flights

flight_number | departure_time | arrival_time | destination_airport | airline_company
--- | --- | --- | --- | ---
1 | 2022-12-01 10:00:00 | 2022-12-01 13:00:00 | JFK | American Airlines
2 | 2022-12-01 12:00:00 | 2022-12-01 16:00:00 | ORD | United Airlines
3 | 2022-12-01 14:00:00 | 2022-12-01 18:00:00 | LAX | Delta Airlines
4 | 2022-12-01 16:00:00 | 2022-12-01 20:00:00 | DFW | Southwest Airlines
5 | 2022-12-01 18:00:00 | 2022-12-01 22:00:00 | ATL | Spirit Airlines