Due on Oct $12,202411$:$59$ PM

Activity Content

Instructions

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 $(1,2,3,4,5,6,7,8,9,10)$ is there to facilitate

answering the questions more easily, for example $1$ can represent the first record$/$row$/$entity in

this table.

Records and fields in the Animal file.

a$).(4$pts$)$ The file's record type is:

b$).(4$pts$)$ Show a record occurrence $($pick any one record$).$

Assume that the records of the Animal file are physically stored in the order shown in the

above file.

a$).(4$pts$)$ Retrieve all of the records of the file physically sequentially.

b$).(4$pts$)$ Retrieve all of the records of the file logically sequentially based on the Weight

field.

c$).(4$pts$)$ Perform a direct retrieval of the records with an Animal Number field value of

Note: For simplicity, in your answer, you may use the relative record numbers $1,2,3,$

$4,5,6,7,8,9,10$ to represent the corresponding records.

For example, to answer below question:

Perform a direct retrieval of the records with a Country of Birth field value of USA. The

result will be records: $4,5,9.$

less

Evaluation Criteria

Out of: $20$ points

Submission Details

Submission type

File submission

Files allowed per

Unlimited

submission

Allowed files

No Restrictions

Number of submissions

All submissions are kept