im 300 week 4 individual
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.