Data base

QUESTION NO. 3: MANDATORY DOCTRINA. O BNS (6 POINTS) Given the following database sample instance, write the following SQL queries: (CLO3) Student Name Student number Class Smith 17 1 Brown B 2 Major CS IN Department CS Course Souce name Course Oumber Credit bours Intro to CS1310 4 computers Data Structure CS 3320 4 Discrete Math MATH2410 3 Database CS3380 3 CS MATH CS # Section Section.cuma! SEE..Dumber Semester 85 MATH2410 FALL 92 CS 1310 FALL 102 CS3320 SPRING 112 MATH2410 FALL 119 CS1310 FALL 135 CS 3380 FALL Year 07 07 OB OB OB OB Instructor KING Anderson Knuth Chang Anderson Stone Stade Report Student...m... 17 17 Grade B C 00 00 00 00 Ssstern...gentur 112 119 85 92 102 135 SOUSE.Oumber. MATH2410 CS 1310 MATH2410 CS 1310 CS3320 CS 3380 A B FACULTY OF ENGINEERING AND INFORMATION TECHNOLOGY DEPARTMENT OF Computer Engineering Retrieve the course names of all the courses that offered by CS department (1 pts) Retrieve the names of all courses taught during fall of (year) 08 along with the names of the instructors. (2 pts) Retrieve the name and transcript of each junior student (class 1) majoring in Computer Science (CS). A transcript includes course names, course numbers, semester, year and grade for each course completed by the student. (2 pts)