only do C,D,F,G

2. Answer the following questions based on the following Supcr Baseball League data. i. Retrieve all of the records of the file physically sequentially. ii. Retrieve all of the records of the file logically sequentially hased on ihe Player Name field. iii. Retrieve all of the records of the file logically sequentially based on the Player Number freld. iv. Retricve all of the records of the file logically sequentially based on the Team Number field. v. Perform a direct reirieval of the records with a Pliyer Number field value of 3834. vi. Perform a direct retrieval of the records with a Team Number ficld value of 20 . vii. Perform a direct retrieval of the records with an Age field value of 24. c. The value 294 appears as a team number once in the Team file and three times in the Player file. Does this constitute data redundancy? Explain. d. Merge the Team and Player files based on the common leam Number field (in a manner similar (o) Figure 3.8 for the General Hardware database). Is the merged file an improvement over the two separate tables in terms of: i. Data redundancy? Explain. ii. Data integration? Explain. e. Explain why the Team Number field is in the Player file. Explain why team number 422 appears twice in the Player file. g. How many files must be accessed to find: i. The age of player number 1953? ii. The name of the team on which player number 3. Regarding the Super Baseball League Player file 2288 plays? shown below. ii. The number of the team on which player number i. Describe the file's record type. 2288 plays? ii. Show a record occurrence. h. Describe the procedure for finding the name of the iii. Describe the set or range of values that the city in which player number 3002 is based. Player Number ficld can take. 1. What is the mechanism for recording the one-to- b. Assume that the records of the Player file are many relationship between players and teams in the physically stored in the order shown. Super Baseball League database, above? Database Mgmt. Systems Section 01 Spring 2023 CO For this assignment you need to complete Minicases \#2-c, d,f, and g on p.66 of Chapter 3. Submit your completed work for this assignment to the Dropbox of D2L in a timely manner. I don't accept your works through means (e-mails, jump dives,, etc.) other than the Dropbox in D2L. No late works to be accepted. Assignment 2