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]
2 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]2 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
Depending on the environmental demands, there are different types of organizational structures, including __________.
Andrews [41]

Answer:

  • Functional (Centralized) Organization
  • Divisional Organization
  • Team-Based Organization
  • Product-Based Organization
  • Modular Organization
  • Matrix Organization

Explanation:

Organization structure:

refers to the idea of how people are supposed to work and coordinate in an organization to maintain a healthy and effective work environment.

There are various types of organizational structures which depends on several factors. There is no single best organization structure. Each structure has its own advantages and disadvantages. In order to select a structure the organization's vision, mission, culture values, goals are to be identified first.

6 0
3 years ago
What substance does light travel through before putting water in the cup
torisob [31]
Bend surface in water! Hopefully this helps, I looked it up!

6 0
3 years ago
Which type of engineering design uses an already existing design
Snezhnost [94]

Answer:

Reverse engineering

Explanation:

Reverse Engineering is the remaking of already made products following the deconstruction and examination of the product to make known the product design, code and architecture features, gain knowledge of the composition and construction in a scientific research approach

Reverse engineering is also known as back engineering and consists of three main stages

1) Recovery implementation

2) Design recovery

3) Recovery analysis.

3 0
3 years ago
What are the three categories of tools?
noname [10]

Answer:

1.      Low power hand tools/small

2.     Light to medium industrial tools

3.     Large industrial tools

There are definitely a lot more categories than three, but this is what I have.

6 0
2 years ago
Rose is building a circuit that accepts sound input and amplifies it. Which component will perform the amplification function?
PilotLPTM [1.2K]

Answer:

FET Transistor

Explanation:

A properly biased Field Effect Transistor will take the audio input and amplify it to drive speakers

8 0
3 years ago
Other questions:
  • 1. True or False: When two batteries are wired in Series the Volts go up and the Amp Hours stay the same. 2. True or False: When
    6·1 answer
  • Which of the following statements are true concerning AC circuit that contains both resistance and inductance? A. The current an
    5·1 answer
  • Which if of the following is not a part of a program block
    9·1 answer
  • Water is pumped steadily through a 0.10-m diameter pipe from one closed pressurized tank to another tank. The pump adds 4.0 kW o
    9·1 answer
  • Training is a way for employers to provide ____ to enable employees to protect themselves and others from injuries.
    9·2 answers
  • The complexity of bfs and dfs
    11·1 answer
  • True or False; The Neutrons in an atom have a neutral charge.​
    15·2 answers
  • Most equipment is cooled by bringing cold air in the front and ducting the heat out of the back. What is the term for where the
    9·1 answer
  • Which of the following might a cement mason or concrete finisher be responsible for? (Select all that apply).
    5·1 answer
  • The operating sequence to light the main burners on an intermittent pilot system is:______.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!