Question: SQL Database Queries Typed only please SQL ete Given the following schema: CITY (Name. Nation, Population) AIRPORT (Code, City_FK, Nation_FK, NumTracks) FLIGHT (ElightlD, DayOfWeek, DepartureAirport

SQL Database Queries
Typed only please
 SQL Database Queries Typed only please SQL ete Given the following

SQL ete Given the following schema: CITY (Name. Nation, Population) AIRPORT (Code, City_FK, Nation_FK, NumTracks) FLIGHT (ElightlD, DayOfWeek, DepartureAirport FK, DepartureTime, ArrivalAirport_FK, ArrivalTime, Plane FK) PLANE (12. Type, NumPassenger, CargoSize) Where the following foreign keys are defined: City_FK, Nation EK in table AIRPORT- Name, Nation in table CITY DepartureAirportFK in table FLIGHT ? Code in table AIRPORT ArrivalAirport FK in table FLIGHT -Code in table AIRPORT Plane_FK in table FLIGHT -ID in table PLANE . Formulate SQL queries to find: Cities having at least one airport for which the number of track is not known, showing the 2. Types of the airplanes that are not used on any route, showing the airplane type and cargo size 3, Planes used on less more than 3 routes, showing the plane type and the number of routes in. 1. name, nation, and population of such cities which it is used Airports offering domestic routes, showing the city where the-airport is and the domestic destinations 4. Airports for which all arrivals are international (that is, no domestic flight arrival), showing the city where the airport is and all origin cities 5. Airports serving both domestic and international flights, showing the city where the airport is and all destination cities 6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!