Please answer the questions, The material is DataBase

The three pictures are the same question, but for a long time to complement some

BONUS QUESTION NO. 3: MANDATORY/DOPTIONAL (5 POINTS) Given the following database sample instance, write the following SQL queries: (CL03) + Student Name Smith Brown Student number Class 17 1 8 2 Major CS CS Department CS Course Course name Course number Credit hours Intro to CS1310 4 computers Data Structure CS3320 4 Discrete Math MATH2410 3 Database CS3380 3 CS MATH CS Section Section number Course number Semester 85 MATH2410 FALL 92 CS1310 FALL 102 CS3320 SPRING 112 MATH2410 FALL 119 CS1310 FALL 135 CS3380 FALL Year 07 07 08 08 08 08 Instructor KING Anderson Knuth Chang Anderson Stone Grade Report Student number 17 Section identifier 112 119 85 17 Course number MATH2410 CS1310 MATH2410 CS1310 CS3320 CS3380 Grade B A A B 8 8 8 8 92 102 135 A # Prerequisite Course number CS3380 CS3380 Prerequisite CS3320 MATH2410 CS1310 CS3320 AAO-P10-R01 3 2018/9/30 Page 4 of 5 Course Name Course No.) 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)