The Central Zoo ENCLOSURE ANIMAL ZOOKEEPER CARES FOR
C

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.