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

• 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 enrollment.
• 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 avitabij@strose.edu