omework 02: The Relational Model The following tables form aninstance of the Airport Database held in a relational DBMS: Airport Carrier Flight (airportID, name, city, state, country) (carrierlD, name, fleetSize, employees, revenue) (carrierID, flightNo, date, time, airportID, destination, distance) Airport airportib city state country ID name Paris FRA UAE CDG Charles de Gaulle DXB Dubai International UFK John F Kennedy International New YorkNY USA LGA LaGuardia MIA Miami International SFO San Francisco International San Francisco CA USA Dubai USA New York Miami USA Each airport name is unique in its country. The state attribute only applies to the United States airports. - - Carrier carrierlD name fleetsize employees revenue 84,60215,414 80,000 39,639 84,15318,300 31467 13,050 225 855 AF Air France DL Delta Air Lines EK Emirates Airline 239 US US Airways 338 Each carrier name is unique in the whole world. Flight carriertD flightNo datetime airpor tID destination distance DL426 10/16/2017 7:00 AM JFK DL DL EK US DL 2,586 SFO SFO 426 10/17/20177:00AM JFK 2,586 479| 10/16/2017| 7:25 PM! JFK SFO 721 10/17/2017 11:25 AM CDG DXB 783 10/17/2017 3:20 AM DXB 1472| 10/17/2017| 7:30 AM| LGA 3,259 JFK MIA 6,843 1,099 SFO 2,576 3577|10/17/2017| 9:40 AM/ LGA 3634 10/16/2017 1:20 PM CDG US MIA 4,580 AF