IM300 Week 5 Optimizing the Database Hotel Database Part 4

Availability: In stock

Regular Price: $25.00

Special Price: $20.00

OR

IM300 Week 5 Hotel Database Part 4 Cover Sheet

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

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.

Regular Price: $25.00

Special Price: $20.00

Details

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.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.