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 with Explanation:
The general equation of simple harmonic motion is
where,
A is the amplitude of motion
is the angular frequency of the motion
is known as initial phase
part 1)
Now by definition of velocity we have
part 2)
Now by definition of acceleration we have
part 3)
The angular frequency is related to Time period 'T' as
where
is the angular frequency of the motion of the particle.
Part 4) The acceleration and velocities are plotted below
since the maximum value that the sin(x) and cos(x) can achieve in their respective domains equals 1 thus the maximum value of acceleration and velocity is and
respectively.
