sql

ssignments_ Intro to DBMS CS D Microsoft PowerPoint-L07-SQL/X D Microsoft PowerPort-L07-SQL Microsoft Po erport ufti/Downloads/LO7-Exercises 01_partB.pdf Provide working SQL DML statements for the following database schema and queries EXERCISE 5 CITY(Name, Nation, Population) AIRPORT (Code, City_FK, Nation FK, NumTracks) FLIGHT (FlightID, DayOfWeek, DepartureAirport _FK, DepartureTime, Arrivalirport FK, ArrivalTime, Plane _FK) 1. 2. 3. 4. PLANE (ID,Type, NumPassengers, CargoSize) Cities with airport having multiple tracks Nations where flight UA472 departs and arrive Type of plane used for flights from Denver Plane type and num. of passengers used in flights departing from Chicago If plane description is not available, just show the type Cities with international flights departures 1. 5. 10 5-Exercise-o zip ^ CSC315-Exe rcis accdb ^ 07-Exercises-01-....pdf