• Consider a relational schema of a Centralized Hotel Chain System as a set of relations as follows:

 

The business rules for the above Centralized Hotel Chain System are:

[R1]   When a hotel is closed and deleted from the database, all rooms in that hotel should be deleted from the database.

[R2]   When a hotel identifier is changed and updated from the database, the information for all rooms in that hotel should be updated accordingly.

[R3]   When a room in a hotel is deleted from the database, all scheduled cleanings for the room in the hotel should be deleted from the database.

[R4]   A room in a hotel cannot be deleted from the database if there is any booking for the room in the hotel.

[R5]   When a room identifier in a hotel is changed and updated from the database, all scheduled cleanings and bookings for the room in the hotel should be updated accordingly.

[R6]   When a staff is fired or quits, all scheduled cleanings should be deleted from the database.

[R7]   When a staff identifier is changed and updated from the database, all scheduled cleanings should be updated accordingly.

[R8]   Staff information cannot be deleted or updated from the database, if the staff is a manager.

[R9]   When a guest requests to be deleted from the database, all bookings by the guest should be deleted from the database.

[R10]     Guest identification cannot be changed from the database, if there is any scheduled booking by the guest.

 

Assignments – For each foreign key in each relation, identify:

• the primary key and the base relation that is being referenced;
• the associated business rule on deletion;
• the referential integrity constraint for ON DELETE;
• the associated business rule on modification; and
• the referential integrity constraint for ON UPDATE.

 

 

ComputerScienceExpert

(11)

Status NEW Posted 03 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1493774045-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer