the super baseball league. consider the super baseball league pl
the super baseball league. consider the super baseball league player file shown below. it lists all of the players in the league by their unique player identification number, their name, age, the year they joined the league, and the team on which they are currently playing.a. create a simple linear index for the player file based on:i. the team number field.ii. the player name field.iii. the player number field.iv. the combination of the team number and the player number fields.b. construct a b+-tree index of the type shown in this chapter for the player file, assuming that there are now many more records than are shown above. the file and the index have the following characteristics:• the file is stored on eight cylinders of the disk.the highest key values on the eight cylinders, in order, are:cylinder 1: 1427cylinder 2: 1965cylinder 3: 2848cylinder 4: 3721cylinder 5: 4508cylinder 6: 5396cylinder 7: 6530cylinder 8: 7442• each index record can hold four key value/pointer pairs.• there are three index records at the lowest level of the tree index.c. the same as part b above, but now there are four index records at the lowest level of the tree index.d. the same as part b above, but each index record can hold two key value/pointer pairs and there are four index records at the lowest level of the tree index.
Price Type: Negotiable
Total Proposals: 2
1 Current viewersl
45 Total views