c,d,f,g

66 Chepter 3 The Datdose Hanyment Spiten Conugh 2. Answer the following questions based on the following i. Retricve all of the reconds of the file physically Super Baseball League data. sequentially. ii. Retrieve all of the records of the file logically sequentially based on the Player Name field. Retrieve all of the records of the file logically iii. Retrieve all of the records of the file logically iv. Retrieve all of the records of the file logically sequentially based on the Team Number field. v. Perform a direct retrieval of the records with a Player Number field value of 3834. vi. Perform a direct retrieval of the records with a Team Number field 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 fle and three times in the Player file. Does this constitute data redundancy? Explain. d. Merge the Team and Player files based on the common Team Number field (in a manner similar to Figare 3.8 for the Genenal Hardware database). Is the merged file an improvement over the two separate tables in terms of: i. Data redundancy? Explain. ii. Data integration? Explain. c. Explain why the Team Number field is in the Player c. Explai file. f. 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 2288 plays? a. Regarding the Super Baseball League. Player file iii. The number shown below. 2288 plays? i. Describe the file's record type. h. Describe the procedure for finding the name city in which player number 3002 is based. iii. Describe the set or range of values that the city in which player number 3002 is based. Player Number field can take. i. What is the mechanism for recording the one-to- b. Assume that the reconds of the Player file are Super Bascball League database, above? physically stored in the order shown