IM300 Week 5 Optimizing the Database Hotel Database Part 4

$ 25

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.

37 in stock

SKU: IM300WEEK5IA Categories: ,

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.

Only logged in customers who have purchased this product may leave a review.