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
Mariana [72]
4 years ago
13

Write SQL queries to answer the following questions: What are the names of the course(s) that student Altvater took during the s

emester I-2018? List the names of the students who have taken at least one course that Professor Collins is qualified to teach. List the names of the students who took at least one course with ""Syst"" in its name during the semester I-2018.

Engineering
1 answer:
amm18124 years ago
6 0

Answer:

See explanations

Explanation:

Consider the following Venn diagram to retrieve the name of course that student Altvater took during semester I-2015.

• In above Venn diagram inner Ellipse represent the subquery part, this subquery part select the Student ID from STUDENT table.

• Second sub query is used to determine the SectionNo of all student whose studentID retrived in the first subquery

• Finally the main query displays the CourseName from COURSE table.

You might be interested in
If the bending moment (M) is 4,176 ft-lb and the beam is an 1 beam, calculate the bending stress (psi) developed at a point with
SpyIntel [72]

Answer:

Bending stress at point 3.96 is \sigma_b = 1.37 psi

Explanation:

Given data:

Bending Moment M is 4.176 ft-lb = 50.12 in- lb

moment of inertia I = 144 inc^4

y = 3.96 in

\sigma_b = \frac{M}{I} \times y

putting all value to get bending stress

\sigma_b = \frac{50.112}{144} \times 3.96  

\sigma_b =  1.37 psi

Bending stress at point 3.96 is \sigma_b = 1.37 psi

3 0
4 years ago
What do u call a bad bird
statuscvo [17]

Answer:

A buzzerd

Explanation:

4 0
3 years ago
What's the function of the rubber, square-cut seal positioned around the caliper piston?
lozanna [386]

Explanation:

The square cut seal is what allows the caliper piston to retract back into its housing. Just because you can manually push the piston in, doesn't mean the square cut seal is working. Rapid brake pad wear, brake drag or brake pull are key indicators that the square cut seal is comprised

5 0
3 years ago
4.In a hydroelectric power plant, 100 m3/s of water flows from an elevation of 120 m to a turbine, where electric power is gener
Dmitrij [34]

Answer:

The rate of irreversible loss will be "55.22 MW".

Explanation:

The given values are:

Elevation,

h = 120 m

Flow of water,

Q = 100 m³/s

Efficiency,

= 80%

i.e,

= 0.8

Efficiency turbine,

= 50 MW

Now,

Without any loss,

The power generated by turbine will be:

⇒ P=\delta gQh

On substituting the values, we get

⇒     =1000\times 9.8\times 100\times 120

⇒     =117.72 \ MW

Power generated in actual will be:

= \frac{50}{0.8}

= 62.5 \ MW

Hence,

Throughout the piping system,

The rate of irreversible loss is:

= Power \ generated \ by \ turbine-Power \ generated  \ in \ actual

= 117.72-62.5

= 55.22 \ MW

4 0
3 years ago
Storm sewer backup causes your basement to flood at the steady rate of 1 in. of depth per hour. The basement floor area is 2600
Wittaler [7]

Answer:

attached below

Explanation:

4 0
3 years ago
Other questions:
  • A thick steel sheet of area 150 in.2 is exposed to air near the ocean. After a one-year period it was found to experience a weig
    7·1 answer
  • The enthalpy of the water entering an actual pump is 500 kJ/kg and the enthalpy of the water leaving it is 550 kJ/kg. The pump h
    10·1 answer
  • What is the nickname for nigeria​
    12·2 answers
  • What type of comptuer was name for the cabinet where the brains
    5·1 answer
  • (The subject is Drivers Ed but they Cleary don't have it)
    14·1 answer
  • Which of the following is NOT a problem associated with surface mining?
    13·1 answer
  • Dimension these please.
    9·1 answer
  • Act as food engineers or biomedical engineers and write a short paragraph explaining why they need to know about mixtures and so
    11·1 answer
  • 25 pts!!!
    12·1 answer
  • Can you think of a product that you love even though it may not work perfectly? Why do you love it?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!