Consider the following ANIMAL and ENCLOSURE relations from the Central Zoo relational database. The left-hand column of relative record numbers is there to facilitate answering some of the questions.
Enclosure relation
Animal relation
a. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
b. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?
c. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is restrict and an attempt is made to delete the record for animal number 40436 in the ANIMAL relation?
d. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
e. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is cascade and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?
f. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for enclosure number 0912 in the ENCLOSURE relation?
g. What would happen if the delete rule between the ENCLOSURE and ANIMAL relations is set-to-null and an attempt is made to delete the record for enclosure number 1660 in the ENCLOSURE relation?
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q19: Representing a unary many-to-many relationship in a
Q20: Representing a unary one-to-many relationship in a
Q21: Referential integrity involves two relations logically associated
Q22: Referential integrity in a relational database refers
Q23: A ternary relationship involves relations for two
Q25: Consider the following AIRPLANE and FLIGHT
Q26: The Bill of Materials problem is an
Q27: If the referential integrity delete rule between
Q28: Consider the following relational database for
Q29: A ternary relationship is the functional equivalent
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents