6.12 Specify the following queries in SQL on the database schema of Figure 1.2 (a) Retrieve the names of all senior students majoring in CS (computer science). (b) Retrieve the names of all courses taught by professor Knuth in 2007 and 2008. (c) For each section taught by professor Knuth, 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-4) majoring in CS. A transcript includes course name course number, credit hours, semester, year, and grade for each course completed by the student. Name Student_number Class 17 Major CS Brown COURSE Course_name Intro to Computer Scene CS1310 Data Structures CS3320 MATH2410 CS CS MATH Section identfier Course number Semester Yar Instructor 85 92 102 112 MATH2410 07 King CS1310 Spring08 MATH2410 CS1310 135 08 Stone GRADE REPORT 112 119 85 92 102 135 17 17 PREREQUISITE Course_number Figure 1.2 A database that stores student and course CS3320 MATH2410 CS1310 CS3320