Consider the Following ANIMAL and ENCLOSURE Relations from the Central

Essay

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.
$\begin{array}{ll}&\text { Enclosure }\\&\text { Number }\quad\text { Type }\quad\quad\quad\text { Size }\\\begin{array}{lr}1\\2\\3\\4\\5\end{array}&\begin{array}{|r|l|r|}\hline 0347 & \text { Glass Cage } & 400 \\\hline 0636 & \text { Fenced Yard } & 1500 \\\hline 0912 & \text { Natural Area } & 2000 \\\hline 1483 & \text { Fenced Yard } & 1650 \\\hline 1660 & \text { Steel Cage } & 700 \\\hline\end{array}\end{array}$ Enclosure relation
$\begin{array}{ll}&\text { Animal } \quad\quad\quad\quad\quad\quad \text { Animal }\quad \quad \text { Enclosure }\\&\text { Number \quad Species\quad\quad Name\quad\quad\quad\quad Number }\\\begin{array}{ll}1\\2\\3\\4\\5\\6\\7\\8\\9\\10\end{array}&\begin{array}{|c|l|l|r|}\hline 13648 \quad& \text { Elephant } & \text { Jumbo } & 1483 \\\hline 15273 & \text { Giraffe } & \text { Stretch } & 0912 \\\hline 17543 & \text { Elephant } & \text { Shirley } & 0636 \\\hline 20165 & \text { Giraffe } & \text { Necky } & 0912 \\\hline 23743 & \text { Giraffe } & \text { High Top } & 0912 \\\hline 27579 & \text { Panda } & \text { Fluffy } & 0347 \\\hline 32565 & \text { Elephant } & \text { Large Louie } & 1483 \\\hline 33837 & \text { Elephant } & \text { Charley } & 0636 \\\hline 36340 & \text { Panda } & \text { Huggy } & 0347 \\\hline 40436 & \text { Giraffe } & \text { Sarah } & 0912 \\\hline\end{array}\end{array}$
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?