Question

Specify the following queries in SQL on the database schema of Figure shown. a) Retrieve the names of all senior students majoring in 'CS' (computer science). b) Retrieve the names of all courses taught by Professor King in 1998 and 1999. c) For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section. d) Retrieve the name and transcript of each senior student (Class = 5) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. STUDENT Name StudentNumber Class Major COURSE CourseName CourseNo. CreditHours Department SECTION SectionID CourseNo. Semester Year Instructor GRADE-REPORT Student Number SectionID Grade PREREQUISITE CourseNo. PrequisiteNo.

          Specify the following queries in SQL on the database schema of Figure
shown.
a) Retrieve the names of all senior students majoring in 'CS' (computer
science).
b) Retrieve the names of all courses taught by Professor King in 1998
and 1999.
c) For each section taught by Professor King, retrieve the course
number, semester, year, and number of students who took the section.
d) Retrieve the name and transcript of each senior student (Class = 5)
majoring in CS. A transcript includes course name, course number,
credit hours, semester, year, and grade for each course completed by
the student.
STUDENT
Name StudentNumber Class Major
COURSE
CourseName CourseNo. CreditHours Department
SECTION
SectionID CourseNo. Semester Year Instructor
GRADE-REPORT
Student Number SectionID Grade
PREREQUISITE
CourseNo. PrequisiteNo.

Specify the following queries in SQL on the database schema of Figure
shown.
a) Retrieve the names of all senior students majoring in 'CS' (computer
science).
b) Retrieve the names of all courses taught by Professor King in 1998
and 1999.
c) For each section taught by Professor King, retrieve the course
number, semester, year, and number of students who took the section.
d) Retrieve the name and transcript of each senior student (Class = 5)
majoring in CS. A transcript includes course name, course number,
credit hours, semester, year, and grade for each course completed by
the student.
STUDENT
Name StudentNumber Class Major
COURSE
CourseName CourseNo. CreditHours Department
SECTION
SectionID CourseNo. Semester Year Instructor
GRADE-REPORT
Student Number SectionID Grade
PREREQUISITE
CourseNo. PrequisiteNo.

Added by Kaitlyn C.

Question

Please give Ace some feedback