please read these four question in the image you can use the

please read these four question in the image you can use the reference book to help you understand the assignment

Question : write the SQL commands in the four Question in the image

Reference book:

Fundamentals of Database Management Systems 2nd Edition

by Mark L. Gillenson (Author)

Solution

1. Find the largest of all the airports

select AIRNAME,CITY from AIRPORT where SIZE equals (select max(SIZE) from AIRPORT);

2. List the names of the mechanics who work in Michigan

select MECHNAME from MECHANIC where AIRNAME in (select AIRNAME from AIRPORT where STATE=\"MICHIGAN\");

3. How many foreign keys does each relation have?

    I\'m unable to find this question in the book. Please be clear next time. Please try to provide the question or else give the exact details of the question like Chapter number and exercise question number and the edition of the book you referred.

4. Identify the foreign keys in each relation.

   The data provided by you is not sufficient to answer the question. If you are seeking to know the foreign keys in each table of the exercise, then the following answer may help you.

In MECHANIC table, \"AIRNAME\" is the foreign key.
In QUALIFICATION Table, \"MECHNUM\" and \"SKILLNUM\" are foreign keys.