Airlines

idnamecountry
1United AirlinesUSA
2Delta AirlinesUSA
3American AirlinesUSA
4Southwest AirlinesUSA
5Air CanadaCanada

Airports

idairportNamecitycountry
1John F. Kennedy International AirportNew YorkUSA
2Hartsfield-Jackson Atlanta International AirportAtlantaUSA
3Los Angeles International AirportLos AngelesUSA
4Toronto Pearson International AirportTorontoCanada
5Vancouver International AirportVancouverCanada

Flights

idflightNumberdepartureTimearrivalTimeairlineIdoriginAirportIddestinationAirportId
(→ Airlines.id)(→ Airports.id)(→ Airports.id)
1UA1232022-07-10 08:00:002022-07-10 10:00:00112
2DL4562022-07-10 10:00:002022-07-10 12:00:00213
3AA7892022-07-10 14:00:002022-07-10 16:00:00314
4SW1012022-07-10 16:00:002022-07-10 18:00:00415
5AC2462022-07-10 18:00:002022-07-10 20:00:00516

Gates

idgateNumberterminalairportId
(→ Airports.id)
1111
2211
3311
4411
5511

Services

idserviceName
1Baggage_Claim
2Food_Court
3Duty_Free
4Car_Rental
5Lost_and_Found

Gates_Services

gateIdserviceId
(→ Gates.id)(→ Services.id)
11
21
31
41
51
53