The Central Zoo ENCLOSURE ANIMAL ZOOKEEPER CARES FOR
C

question 32

Essay

The Central Zoo.
a. You have just been given the responsibility for data management at the Central Zoo. The Central Zoo maintains a modest information systems environment with a server and a LAN that connects all of the zoo's departments. You have been asked to design and manage the typical data administration and database administration functions at the Central Zoo. Do so, describing the tasks necessary to maintain the zoo's data.
b. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for the following Central Zoo database. Your TABLES table should have Table Name, Table Length, and Disk Number columns. Your ATTRIBUTES tables should have Attribute Name, Attribute Type, and Attribute Length columns. Use your judgement in developing the values for these columns.
$$\begin{array} { | l | l | l | l | l | } \hline\text { Enclosure } &&&&\text { Date }\\ { \text { Nurmber } } & \text { Type } & \text { Location } & \text { Size } & \text { Built } \\\hline\end{array}$$ ENCLOSURE
$$\begin{array} { | l | l | l | l | l | l | l | } \hline\text { Animal } & &\text { Animal }&&\text { Country }&& \text { Enclosure }\\ \text { Number } & \text { Species } & \text { Name } & \text { Gender }&\text { of Birth } & \text { Weight } & \text {Number }\\\hline\end{array}$$ ANIMAL
$\begin{array}{|l|l|l|l|l|}\hline \text { Employee } & \text { Employee } & & \text { Year } & \text { Supervisor } \\\text { Number } & \text { Name } & \text { Title } & \text { Hired } & \text { Number }\\\hline\end{array}$ ZOOKEEPER
$\begin{array}{|l|l|l|l|l|}\hline \text { Animal } & \text { Employee } & \text { Service } \\\text { Number } & \text { Number } & \text { Type } & \text { Date } & \text { Time }\\\hline\end{array}$ CARES FOR
c. Create a RELATIONSHIPS table for this tables and attributes data.

---

Definitions:

Demographic Data

Statistical information of a population, including age, race, income, education, and employment, which is used for analysis and policy-making.

Physical Assessment

A comprehensive examination of a patient's body by a healthcare provider to detect any signs of diseases or abnormalities.

Rotator Cuff

A group of muscles and tendons surrounding the shoulder joint, providing stability and allowing for a range of shoulder movements.

Terminally Ill

A term used to describe a patient who has a disease that is incurable and is expected to lead to the patient's death in the near future.