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:

Absolute Advantage

A scenario in which a country can produce a particular good or service more effectively than another country with the same amount of resources.

Comparative Advantage

an economic principle that posits a country or entity can produce a particular good or service at a lower opportunity cost than its trading partners, leading to beneficial trade.

Medium Of Exchange

Anything that facilitates trade by being generally accepted by all parties in payment for goods or services.

Facilitates Trade

Actions or policies designed to make trade between countries or parties easier, typically through reducing barriers such as tariffs and quotas.