Problems
the Following Animal File from the Central Zoo Will

question 68

Essay

Problems
The following Animal File from the Central Zoo will be used in several of the following questions. The left-hand column of relative record numbers is there to facilitate answering the questions.
$\begin{array}{lr}&\text { Animal } \quad\quad\quad\quad\quad\quad\quad\quad \text { Animal } \quad\quad\quad\quad\quad \text { Country of } \quad\quad\quad\quad\\&\text { Number } \quad\quad \text { Species }\quad\quad\quad \text { Name }\quad\quad \text { Gender } \quad\text { Birth }\quad\quad\text { Weight }\\\begin{array}{lr}1\\2\\3\\4\\5\\6\\7\\8\\9\\10\end{array}&\begin{array}{|r|l|l|l|l|r|}\hline 13648 & \text { Elephant } & \text { Jumbo } & \text { M }\quad\quad & \text { Uganda } & 6,000 \\\hline 14990 & \text { Kangaroo } & \text { Fred } & \text { M } & \text { Australia } & 200 \\\hline 17543 & \text { Elephant } & \text { Shirley } & \text { F } & \text { Nigeria } & 5,500 \\\hline 20165 & \text { Giraffe } & \text { Necky } & \text { F } & \text { USA } & 500 \\\hline 23743 & \text { Giraffe } & \text { High Top } & \text { F } & \text { USA } & 600 \\\hline 27579 & \text { Panda } & \text { Fluffy } & \text { M } & \text { China } & 250 \\\hline 32565 & \text { Elephant } & \text { Large Louie } & \text { M } & \text { India } & 7,000 \\\hline 34871 & \text { Grizzly Bear } & \text { Doris } & \text { F } & \text { Canada } & 1,500 \\\hline 35993 & \text { Lion } & \text { King } & \text { M } & \text { USA } & 580 \\\hline 38578 & \text { Tiger } & \text { Stripes } & \text { F } & \text { India } & 470\\\hline\end{array}\end{array}$ Animal file
-Records and fields in the Animal file.
a. Describe the file's record type.
b. Show a record occurrence.
c. Describe the set or range of values that the Animal Number field can take.
d. Describe the set or range of values that the Gender field can take.

---

Definitions:

Foreign Imports

Products or services imported from other countries for the purpose of being sold.

Trade Deficit

A scenario in which a country spends more on importing goods than it makes from exporting them, creating a trade imbalance.

Trade Deficit

A situation in which a country's imports exceed its exports, reflecting a net outflow of domestic currency to foreign markets.

Merchandise Trade Deficit

The economic condition occurring when a country imports more physical goods than it exports, resulting in a negative trade balance.