Engineering, 22.02.2020 02:24 leo4687

Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport 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.
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

Answers: 1

Show answers

Another question on Engineering

Engineering, 04.07.2019 19:10

The sum of the normal stresses does not change as the stress state rotates through an angle. a)-trune b)- false

Answers: 2

Answer

Engineering, 04.07.2019 19:10

Ahelical coil spring has a mean diameter of 50 mm, a wire diameter of 5.5 mm and is wound with a pitch of 10 mm. the spring steel has an ultimate strength of 1250 mpa. find the force needed to compress the spring solid and the wire stress in this condition. state whether the spring will return to its initial length.

Answers: 1

Answer

Engineering, 06.07.2019 04:20

At what temperature does the mole fraction of no reach 0.010 for the equilibrium products resulting from the combustion of gasoline and air at 1.0 and 5000 kpa?

Answers: 1

Answer

Engineering, 06.07.2019 04:30

At steady state, air enters an insulated duct of varying cross-sectional area (similar to a nozzle or diffuser) at 200 kpa, 52°c with a mass flow rate of 0.5 kg/s. at the duct exit, the pressure of the air is 100 kpa, the velocity is 255 m/s, and the cross-sectional area is 2 x 10-3 m^2. assuming an ideal gas model, determine: a)-find the specific volume of the air at the exit, in m3/kg. b)- the temperature of the air at the exit, in k. c)-the velocity of the air at the inlet, in m/s. d)-the inlet cross-sectional area, in m^2.

Answers: 1

Answer

You know the right answer?

Consider the following relational database that Best Airlines uses to keep track of its mechanics, t...

Questions