Meteorological_Offices

idnamelocation
1Office ANew York
2Office BChicago
3Office CLos Angeles
4Office DDallas
5Office EAtlanta

Data_Sources

idsource_typedescription
1Automated_Weather_StationCollects real-time weather data.
2Radar_SystemTracks precipitation and storm systems.
3SatelliteMonitors global atmospheric conditions.
4Wind_SensorMeasures wind speed and direction.
5Temperature_SensorRecords ambient temperature.

Meteorological_Offices_Data_Sources

meteo_office_iddata_source_id
(→ Meteorological_Offices.id)(→ Data_Sources.id)
11
21
31
41
51
53

Terminals

idterminal_namecapacity
1Terminal 15000
2Terminal 24500
3Terminal 34000
4Terminal 43500
5Terminal 53000

Flights

flight_numberdeparture_timearrival_timedestination_airportairline_company
12022-12-01 10:00:002022-12-01 13:00:00JFKAmerican Airlines
22022-12-01 12:00:002022-12-01 16:00:00ORDUnited Airlines
32022-12-01 14:00:002022-12-01 18:00:00LAXDelta Airlines
42022-12-01 16:00:002022-12-01 20:00:00DFWSouthwest Airlines
52022-12-01 18:00:002022-12-01 22:00:00ATLSpirit Airlines