Write SQL update statements to do the following on the database schema shown in Figure 1.2. (a) Insert a new student in the database. (b)

Write SQL update statements to do the following on the database schema shown in Figure 1.2.
(a) Insert a new student <'Johnson', 25, 1, 'MATH'> in the database.
(b) Change the class of student 'Smith' to 2.
(c) Insert a new course <'Knowledge Engineering','COSC4390', 3,'COSC'>.
(d) Delete the record for the student whose name is 'Smith' and student number is 17.