Problems
the Following Animal File from the Central Zoo Will

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.