IM 300 Week 4 Individual

Hands-On 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.