Databases

Please resolve quickly, of necessary

QUESTION NO. 3: MAXDATOK Coronto (5 POINTS) Given the following database sample instance, write the following SQL queries: (CLO 3) Student Name Smith Student number Class 17 1 8 2 Major CS Brown CS Department CS Course Course_name Course number Credit_hours Intro to CS1310 computers Data Structure CS3320 4 Discrete Math MATH2410 3 Database CS3380 3 CS MATH CS Instructor KING Anderson Section Section number Course number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Semester FALL FALL SPRING FALL FALL Year 07 07 08 Knuth 08 Chang Anderson FALL 09 Stone Grade Report Student number 17 Grade Section identifier 112 119 17 8 Course number MATH2410 CS1310 MATH2410 CS1310 CS3320 CS3380 C A A 85 92 102 135 8 8 B a A Prerequisite Course_number CS3380 CS3380 CS3320 Prerequisite CS3320 MATH2410 CS1310 . Retrieve the course names of all the courses that offered by CS department (1 pts) . Retrieve the names of all courses tauglat during fall of (year) 08 along with the names of the structors (2 pts) . Retrieve the same 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)