Answer:
Explanation: see attachment below
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.
1 answer:
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
Answer:
Mechanical Efficiency = 83.51%
Explanation:
Given Data:
Pressure difference = ΔP=1.2 Psi
Flow rate =
Power of Pump = 3 hp
Required:
Mechanical Efficiency
Solution:
We will first bring the change the units of given data into SI units.
Now we will find the change in energy.
Since it is mentioned in the statement that change in elevation (potential energy) and change in velocity (Kinetic Energy) are negligible.
Thus change in energy is
As we know that Mass = Volume x density
substituting the value
Energy = Volume * density x ΔP / density
Change in energy = Volumetric flow x ΔP
Change in energy = 0.226 x 8.274 = 1.869 KW
Now mechanical efficiency = change in energy / work done by shaft
Efficiency = 1.869 / 2.238
Efficiency = 0.8351 = 83.51%