IM 300 Week 4 Individual Assignment SR-bi-003 – Hotel Database, Part 4

IM 300 Week 4 Individual Assignment SR-bi-003 – Hotel Database, Part 4
 
Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Part 3, and Oracle® Database Express® Virtual Desktop
Complete the service request byimplementing referential integrity and constraints in your database:
Create an AFTER trigger on the Hotel table that deletes any records from the Rooms table that match (:old.HOTEL_ID).
Apply at least six constraints within the database.
Create a newly generated DDL script.
Create a fax cover sheet addressed to the project manager for the referential integrity and constraints work you have completed and include a newly generated DDL script to show your progress on the project.
Submit your assignment using the Assignment Files tab above.