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) Change the class of student 'Smith ' to 2 (c) Insert a new course (d) Delete the record for the student whose name is 'Smith ' and student number is 17 ...

a INSERT INTO STUDENT VALUES Johnson 25 1 MA ...

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

Question:

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.