Homework 9 SQL

Inside hw9.zip , you will find hw9.sql. Modify it so that the following changes are made
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.