Database Management System (DBMS) Questions.

Use these parameters to answer the questions:

block size = 500 bytes block pointer size = 5 bytes key = 5 bytes blocks in the sorted data file = 25,000

a) What is the size of an index record? b) What is the blocking factor for the index? c) What is the size of the index (number of blocks)? d) How many data blocks are retrieved for an exact match query after using the index (don't count the index, just count the data blocks retrieved)? e) What is the maximum number of index blocks accessed for an exact match query? (do not include data blocks)