Specify the following queries in SQL on the database schema of Figure 1.2.
Figure 1.2:
A database that stores
student and course
information.Caption
- Retrieve the names of all senior students majoring in ‘CS’ (computer science).
- Retrieve the names of all courses taught by Professor King in 2007 and
2008.
- For each section taught by Professor King, retrieve the course number,
semester, year, and number of students who took the section.
- Retrieve the name and transcript of each senior student (Class = 4)
majoring in CS. A transcript includes course name, course number, credit
hours, semester, year, and grade for each course completed by the student.