1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
olya-2409 [2.1K]
3 years ago
14

Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airpo

rt locations. Mechanic number (MECHNUM), airport name (AIRNAME), and skill number are all unique fields. SIZE is an airport’s size in acres. SKILLCAT is a skill category, such as an engine skill, wing skill, tire skill, etc. YEARQUAL is the year that a mechanic first qualified in a particular skill; PROFRATE is the mechanic’s proficiency rating in a particular skill.
Write SQL SELECT commands to answer the following queries.

a. List the names and ages of all the mechanics.

b. List the airports in California that are at least
20 acres in size and have been open since 1935.
Order the results from smallest to largest airport.

c. List the airports in California that are at least 20
acres in size or have been open since 1935.

d. FindtheaveragesizeoftheairportsinCalifornia
that have been open since 1935.

e.e. How many airports have been open in California since 1935?
f. How many airports have been open in each state since 1935?
g. How many airports have been open in each state since 1935? Include in your answer only those states that have at least five such airports.
h. List the names of the mechanics who work in California.
i. Fan blade replacement is the name of a skill. List the names of the mechanics who have a proficiency rating of 4 in fan blade replacement.
j. Fan blade replacement is the name of a skill. List the names of the mechanics who work in California who have a proficiency rating of 4 in fan blade replacement.
k. List the total, combined salaries of all of the mechanics who work in each city in California.
l. Find the largest of all of the airports.

m. Find the largest airport in California

MECHANIC Table MECHNUM MECHNAME AGE SALARY Ab SALARY AIRPORT Table AIRNAME CITY STATE SIZE YEAROPENED

images
Engineering
1 answer:
Musya8 [376]3 years ago
6 0

Answer:

Explanation:

A)

SELECT MECHNAME,AGE FROM MECHANIC;

B)

SELECT AIRNAME,SIZE FROM AIRPORT WHERE SIZE>=20 AND STATE='CALIFORNIA' AND YEAROPENED >=1935 ORDER BY SIZE ASC;

C)

SELECT AIRNAME,SIZE FROM AIRPORT WHERE (SIZE>=20 OR YEAROPENED >=1935) AND STATE='CALIFORNIA';

D)

SELECT AVG(SIZE) FROM AIRPORT WHERE STATE='CALIFORNIA' AND YEAROPENED >=1935;

E)

SELECT COUNT(AIRNAME) FROM AIRPORT WHERE STATE='CALIFORNIA' AND YEAROPENED >=1935;

F)

SELECT COUNT(AIRNAME),STATE FROM AIRPORT WHERE YEAROPENED>=1935 GROUP BY STATE;

G)

SELECT COUNT(AIRNAME),STATE FROM AIRPORT WHERE YEAR OPENED>=1935 GROUP BY STATE HAVING COUNT(*)>=5;

H)

SELECT MECHNAME FROM MECHANIC A JOIN AIRPORT B

ON A.AIRNAME=B.AIRNAME AND B.STATE='CALIFORNIA';

I)  

SELECT MECHNAME FROM MECHANIC A

JOIN QUALIFICATION B

ON A.MECHNUM=B.MECHNUM

AND B.PROFRATE=4

JOIN SKILL C

ON B.SKILLNUM=C.SKILLNUM

AND SKILLNAME='FAN BLADE RELACEMENT';

J)  SELECT MECHNAME FROM MECHANIC A

JOIN QUALIFICATION B

ON A.MECHNUM=B.MECHNUM

AND B.PROFRATE=4

JOIN SKILL C

ON B.SKILLNUM=C.SKILLNUM

AND SKILL NAME='FAN BLADE REPLACEMENT'

JOIN AIRPORT D

ON A.AIRNAME=D.AIRNAME

AND STATE='CALIFORNIA';

K)   SELECT SUM(SALARY),CITY FROM MECHANIC A

JOIN AIRPORT B

ON A.AIRNAME=B.AIRNAME

AND STATE='CALIFORNIA'

GROUP BY CITY;

L)   SELECT MAX(SIZE) FROM AIRPORT ;

M)  SELECT MAX(SIZE) FROM AIRPORT WHERE STATE='CALIFORNIA';

You might be interested in
In the combination of resistors above, consider the 1.50 µΩ and 0.75 µΩ. How can you classify the connection between these two r
Airida [17]

Answer: they are connected in series.

Explanation:

3 0
3 years ago
Summarize key
BlackZzzverrR [31]

Answer:

what are is ethiopia cultural ?

7 0
2 years ago
A hypothetical A-B alloy of composition 57 wt% B-43 wt% A at some temperature is found to consist of mass fractions of 0.5 for b
Dennis_Churaev [7]

Answer:

composition of alpha phase is 27% B

Explanation:

given data

mass fractions  = 0.5 for both

composition = 57 wt% B-43 wt% A

composition = 87 wt% B-13 wt% A

solution

as by total composition Co = 57 and by beta phase composition  Cβ = 87  

we use here lever rule that is

Wα = Wβ   ...............1

Wα = Wβ = 0.5

now we take here left side of equation

we will get

\frac{C_\beta - Co}{C_\beta - Ca}   = 0.5

\frac{87 - 57}{87 - Ca} = 0.5  

solve it we get

Ca = 27

so composition of alpha phase is 27% B

8 0
3 years ago
Which of the following is NOT part of a car's drive train?
FromTheMoon [43]

Answer:

B. rotor

Explanation:

The correct answer Is rotor because the others are part of a cars drivetrain

3 0
3 years ago
Read 2 more answers
Construction support involves mostly what kind of work?
Paraphin [41]

Answer:

Outdoors

Explanation:

Construction workers perform outdoors.

6 0
2 years ago
Other questions:
  • In many problems where the potential energy is considered between two objects, the potential energy is defined as zero when the
    8·1 answer
  • Harmony in music is characterized by _____.
    14·2 answers
  • Can a real refrigerator have higher COP than the COP of the Carnot refrigerator?
    7·2 answers
  • If changing employment what do you need to do? Email your new employer information to the Deptartment of International Graduate
    5·1 answer
  • Different Gauss quadrature formulae predict different values for the same integral a. True b. False
    11·1 answer
  • How many trains have been invented all around the world?
    14·1 answer
  • La Patrulla Fronteriza de los Estados Unidos analiza la compra de un helicóptero nuevo para la vigilancia aérea de la frontera d
    14·1 answer
  • Select the correct answer. Jude is a mechanical engineer. He works in the automobile industry. He is creating a prototype of an
    13·1 answer
  • प्रहार का समरूपी भिन्नार्थक शब्द अर्थ के साथ ​
    10·1 answer
  • Airbags may deploy in the<br> of the passenger or<br> driver, or from the<br> of the vehicle.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!