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:
hello below is missing piece of the complete question
minimum size = 0.3 cm
answer : 0.247 N/mm2
Explanation:
Given data :
section span : 10.9 and 13.4 cm
minimum load applied evenly to the top of span : 13 N
maximum load for each member ; 4.5 N
lets take each member to be 4.2 cm
Determine the max value of P before truss fails
Taking average value of section span ≈ 12 cm
Given minimum load distributed evenly on top of section span = 13 N
we will calculate the value of by applying this formula
= = 1.56 * 10^-5
next we will consider section ; 4.2 cm * 0.3 cm
hence Z (section modulus ) = BD^2 / 6
= ( 0.042 * 0.003^2 ) / 6 = 6.3*10^-8
Finally the max value of P( stress ) before the truss fails
= M/Z = ( 1.56 * 10^-5 ) / ( 6.3*10^-8 )
= 0.247 N/mm2
Answer:
ordinary bulb total cost is $39.54
fluorescent bulb total cost is $13.05
amount save = 39.54 - 13.05 = $26.49
resistance = 626.1 ohm
Explanation:
in the 1st part
bulb on time = 3 year = 4380 hours
life of bulb = 750 h
so number of bulb required =
number of bulb required = 6
cost of 6 bulb is = 6 × 0.75 = $4.5
so
cost of operation is = 100 × 4380 ×
cost of operation = $35.04
so total cost will be = $4.5 + $35.04 = $39.54
and
when compare with florescent bulb
time = 3 year = 4380 h
life of bulb = 10000 h
so number of bulb required =
number of bulb required = 0.43 = 1
cost of 6 bulb is = 1 × 5 = $5
so
cost of operation is = 23 × 4380 ×
cost of operation = $8.05
so total cost will be = $5 + $8.05 = $13.05
in part 2nd
total amount save while compare bulb is
amount save = 39.54 - 13.05 = $26.49
and in part 3rd
resistance of bulb is
resistance =
resistance =
resistance = 626.1 ohm