Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

Exercise 8

-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.