Consider the Following ANIMAL and ENCLOSURE Relations from the Central

question 33

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?

---

Definitions:

Blanche of Castile

Blanche of Castile was a queen consort and regent of France, known for her role in maintaining the throne for her son, Louis IX, during his minority and later crusades.

Jeanne Pucelle

Likely a misspelling or misinterpretation of Jeanne d'Arc (Joan of Arc), who was a French heroine and saint, known for her role during the Lancastrian phase of the Hundred Years' War.

Risk Averse

A description of an investor's or an individual's preference for avoiding loss rather than making a gain.

Portfolio

An assortment of financial assets including stocks, bonds, commodities, cash, and equivalents, as well as mutual funds and exchange-traded funds (ETFs).