SQL

4. You are a new student in the Computer Science department, and you are taking CS-315 in the Spring semester of 2018 in section 1. You do not have an assigned grade yet (assign null as the grade value), as you have just started the course. Give the Sol statements necessary to add yourself to the student and takes relations. 5. It's the end of the semester, so update your CS-315 course with the grade your teacher gave You. (use a valid grade that represents what you believe you got) 6. Display the student ID, student name, course idd, and course title for any remaining student courses (takes) in the 2018 year with no grades. 7. Write sQL statement that will remove records from takes for any records found in \#6 8. Show the total salary by department for any department that has exceeded its department budget (use a having clause) Figure 2.9 Schema diagram for the univehsity database