Consider the Following Animal and Enclosure Files from the Central

question 57

Essay

Consider the following Animal and Enclosure files from the Central Zoo. 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\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\end{array}\end{array}$ Enclosure file
$\begin{array}{ll}&\text { Animal } \quad\quad\quad\quad\quad\quad \quad \text { Animal } \quad \text { Enclosure }\\&\text { Number\quad Species\quad\quad\quad Name\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 file
a. 0912 appears as an enclosure number in record 3 of the Enclosure file and in records 2, 4, 5, and 10 of the Animal file. Does this constitute redundant data? Explain.
b. Why does the Enclosure Number field appear in both files?
c. What would you have to do to find the type of enclosure in which animal number 33837 is kept?
d. Merge the two files into one based on which records of one file are related to which records of the other file.
e. How does merging the two files into one affect data integration?
f. How does merging the two files into one affect data redundancy?