Description
IM300 Week 5 Optimizing the Database 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 by implementing 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.
Reviews
There are no reviews yet.