Details of this Paper

Homework 9 SQL

Description

solution


Question

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.

 

Paper#67951 | Written in 18-Jul-2015

Price : $22
SiteLock