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.

Managing Enterprise Resource Planning (ERP) Databases Would Be Most Directly

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge