Given the tables below from some university database, write SQL statements to perform the given modifications.

Given the tables below from some university database, write SQL statements to perform the given modifications. Write the code to do this.. and copy and paste into a word doc for submission.. Preface your submissions with its question. 1. Insert a new student into the student table. 2. Change the class to student 'Smith' to 2. 3. Insert a new course into the course table. 4. Delete the record for the student whose name is 'Smith' and whose student number is 17. 5. Insert a grade of 'B' for the student whose student number is 17 in the section whose section identifier is 85. STUDENT Name Smith Student number Class Major CS 17 1 Brown 8 2 CS Credit_hours Course_number CS1310 4 COURSE Course name Intro to Computer Science Data Structures Discrete Mathematics Database 4 CS3320 MATH2410 CS3380 Department CS CS MATH CS 3 3 Year Semester Fall 07 SECTION Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 07 08 Spring Fall Fall Instructor King Anderson Knuth Chang Anderson Stone 08 119 08 CS1310 CS3380 135 Fall 08 GRADE REPORT Student_number 17 Grade Section_identifier 112 B 17 119 8 85 A 8 92 A 8 102 B 8 135 A PREREQUISITE Course_number CS3380 CS3380 Figure 1.2 A database that stores student and course information. Prerequisite_number CS3320 MATH2410 CS1310 CS3320