can
TEAM Tom Number None ON Monoga 137 275 294 368 422 Eagles Cowboys Statesmen Pandas Sharks Orlando San Jose Springfield Paso Jackson Smith Jones Edwards Adams Vega 6) PLAYER Player Player Number Name Team Number Position 1200 1254 1536 1953 2753 2843 3002 3274 3388 3740 Steve Marks Roscoe Gomer Mark Norton Alan Randall John Harbor John Yancy Stuart Clark Lefty Smith Kevin Taylor Juan Vidora 24 Catch 19 Pitcher 32 First Baan 24 Patches 22 Shortstop 27 Center Felder 20 Catches 31 Third Haseman 25 Shortstop 25 Catcher 294 422 368 137 294 137 422 137 294 368 a. Regarding the Super Baseball League Player file shown below. i. Describe the file's record type. . ii. Show a record occurrence. iii. Describe the set or range of values that the Player Number field can take. b. Assume that the records of the Player file are physically stored in the order shown. Note: Don't write SQL queries for questions i to vii, instead, retrieve the corresponding records from the table i. Retrieve all of the records of the file physically sequentially. ii. Retrieve all of the records of the file logically sequentially based on the Player Name field. iii. Retrieve all of the records of the file logically sequentially based on the Player Number field. 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 file and three times in the Player file. Does this constitute data redundancy? Explain. d. Describe the procedure for finding the name of the city in which player number 3002 is based. (a) TEAM ile Number Team Nome Manager Eagles 137 275 294 368 422 Cowboys Statesmen Pandas Sharks City Orlando San Jose Springfield El Paso Jackson Smith Jones Edwards Adams Vega 6) PLAYER file Team Player Name Age Position Number Player Number 1209 1254 1536 1953 2753 2843 3002 3274 3388 3740 Steve Marks Roscoe Gomez Mark Norton Alan Randall John Harbor John Yancy Stuart Clark Lefty Smith Kevin Taylor Juan Vidora 24 19 32 24 22 27 20 31 25 25 Catcher Pitcher First Baseman Pitcher Shortstop Center Fleider Catcher Third Baseman Shortstop Catcher 294 422 368 137 294 137 422 137 294 368 a. Regarding the Super Baseball League Player file shown below. i. Describe the file's record type. ii. Show a record occurrence. iii. Describe the set or range of values that the Player Number field can take. b. Assume that the records of the Player file are physically stored in the order shown. Note: Don't write SQL queries for questions i to vii, instead, retrieve the corresponding records from the table i. Retrieve all of the records of the file physically sequentially
