Database

Relational Calculus To express the existential quantifier 3, you can use EXIST To express the universal quantifier V. you can use ALL To express the Not Equal comparison operator #, you can use != Consider the following instance of the Airport Database: country FRA UAE Airport airportid name city CDG Charles de Gaulle Paris DXB Dubai International Dubai JFK John F Kennedy International New York LGA LaGuardia New York MIA Miami International Miami SFO San Francisco International San Francisco state NULL NULL NY NY FL CA USA USA USA USA Carrier carrieri AF DL EK US name Air France Delta Air Lines Emirates Airline 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 Flight carrierid flightNo date time DL 426 10/16/2017 7:00 AM DL 426 10/17/2017 7:00 AM DL 479 10/16/2017 7:25 PM EK 721 10/17/2017 11:25 AM US 783 10/17/2017 3:20 AM DL 1472 10/17/2017 7:30 AM AF 3577) 10/17/2017 5:45 PM US 3577 10/17/2017 9:40 AM AF 3634 10/16/2017 1:20 PM airportid 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 CDG 3,629 LGA SFO 2,576 CDG MIA 4,580 Formulate the following queries in the relational calculus: List all airport names. 2 points Your answer List full details of all airports located in NY state. 2 points Your answer List the name and the state of all United States airports. 2 points Your answer 2 points List the name and the fleet size of all carriers employing more than 50,000 workers. Your answer Formulate the following queries in the relational calculus: List all flights leaving from United States airports. 3 points Your answer List the carrierld and the distance of all flights landing at NY state airports. 3 points Note: The attribute that characterizes landing flights is the destination attribute. Your answer List the carriers that do not leave from JFK. 3 points Your answer List the names of carriers that have flights landing at France airports. 3 points Your