Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Find pilots by eid who are certified to fly all aircraft the airline owns with the exception of those on the specialized list, i.e.

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1) Find pilots by eid who are certified to fly all aircraft the airline owns with the exception of those on the "specialized" list, i.e. SAAB 340, Tupolev 154, the Airbus A320, Airbus A319, and the Schwitzer 2-33. (This means that they definitely can fly all the aircraft with the exception those in the "specialized" list, but does not rule out that they may also be able to fly aircraft on the "specialized" list as well). You are permitted, in cases where a query is a subquery, to refer to that query as Qx. The source query has to be clearly labeled as Qx. Do NOT use knowledge of the contents of the tables in your answers. a) Find the distinct aircraft aids of aircraft that the airline owns with the exceiption of those on the specialized list. (This query should result in 11 rows indicating that there are 11 aircraft out of the total of 16 aircraft that are not on the specialized list). b) Find the distinct eids of all pilots. (This query should result in 12 pilot eids)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions