Problems
the Following Animal File from the Central Zoo Will

question 36

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
-Assume that the records of the Animal file are physically stored in the order shown.
a. Retrieve all of the records of the file physically sequentially.
b. Retrieve all of the records of the file logically sequentially based on the Animal Name field.
c. Retrieve all of the records of the file logically sequentially based on the Animal Number field.
d. Retrieve all of the records of the file logically sequentially based on the Weight field.
e. Perform a direct retrieval of the records with an Animal Number field value of 34871.
f. Perform a direct retrieval of the records with a Country of Birth field value of USA.

---

Definitions:

Promisor

A person or entity who makes a promise or commits to performing a specified action in a contract.

Face Amount

The nominal or dollar value stated on a financial instrument or security, such as a bond.

Maturity Date

The specific date on which the principal amount of a financial instrument, such as a bond or loan, becomes due and payable.

Term

A fixed or limited period for which something, such as an investment, insurance policy, or lease, lasts or is intended to last.