Homework 9 (Chapter 8)
Inside hw9.zip , you will find hw9.sql. Modify it so that the following
changes are made. Email this file to me as part of a zip file when you are
The number of credits for a course is always between 0 and 6.
The current enrollment of an offering must be less than the maximum
Deleting a student will delete all enrollments for that student.
Write a trigger that will add 1 to the current enrollment of an offering
when a new enrollment record for that offering is inserted.
Write a trigger that will subtract 1 from the current enrollment of an
offering when an enrollment record for that offering is deleted.
I just want the solutions to these exercises. Of course, you
should implement them using Oracle Express.
Email your solution to firstname.lastname@example.org