Homework 03 - Relational Calculus Submission Deadline: Wednesday 02/26/2020 Consider the following database instance, state Airport airporti name city CDG Charles de Gaulle Paris DXB Dubai International Dubai FK John F Kennedy International New York LGA LaGuardia New York MIA Miami International Miami SFO San Francisco International San Francisco country FRA UAE USA USA USA NY CA USA Carrier carrierid name AF Air France DL Delta Air Lines EK Emirates Airline US US Airways fleetSize employees revenue 225 84,602 15,414 855 80,000 39,639 239 84,153 18,300 338 31,467 13,050 DL Flight carrierid flight No date time 426 10/16/2017 7:00 AM DL 426 10/17/2017 7:00 AM 479 10/16/2017 7:25 PM 721 10/17/2017 11:25 AM 783 10/17/2017 3:20 AM 1472 10/17/2017 7:30 AM 3577 10/17/2017 5:45 PM 3577 10/17/2017 9:40 AM AF 3634 10/16/2017 1:20 PM airporti destination distance JFK SFO 2,586 JFK SFO 2,586 JFK SFO 2.586 CDG DXB 3,259 DXB JFK 6,843 LGA MIA 1,099 JFK 3,629 LGA SFO 2,576 CDG MIA 4,580 CDG US Formulate the following queries in the tuple relational calculus: 1. List all airport names. 2. List full details of all airports located in NY state. 3. List the name and the state of all United States airports 4. List the name and the fleet size of all carriers employing more than 50,000 workers. 5. List all flights leaving from United States airports. 6. List the carrierID and the distance of all flights landing in NY state airports. 7. List the carriers that do not leave from JFK. 8. List the names of carriers that have flights landing in France airports