1. Specify the following queries in SQL on the database schema of figure 1. [ 15 marks]
   1. Retrieve the names of all senior students majoring in CS (computer science).
   2. Retrieve the names of all courses taught by Professor King in 1998 and 1999.
   3. For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section.
   4. 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.
   5. Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their courses).

Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.

STUDENT Name Student Number Class Major Smith 17 Brown 2 1 CS 8 CS COURSE CourseName Intro to Computer Science Data Structures Discrete Mathematics Database Course Number Credit Hours Department CS1310 4 CS CS3320 4 CS MATH2410 3 MATH CS3380 3 CS Year 98 SECTION SectionIdentifier CourseNumber Semester 85 MATH2410 Fall 92 CS1310 Fall 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall 135 CS3380 Fall 98 99 Instructor King Anderson Knuth Chang Anderson Stone 99 99 99 GRADE REPORT Student Number SectionIdentifier Grade 17 112 B 17 119 C 8 85 A 92 8 102 B 135 00 00 DWDOW 8 PREREQUISITE Prerequisite Number CS3320 CourseNurnber CS3380 CS3380 CS3320 MATH2410 CS1310