P$.$S$.$ It is a database question for indexing, block factor index etc. Appreciate your help to explain in details. I

have tried GPT $4$ but I am still not sure about the answers. Please kindly explain it$!$ Many thanks. $$

Q$1.$Consider a disk with a block size of $1024$ bytes. A file has $50,000$ BOOK records of fixed length. Each

record has the following fields: BookID $(5$ bytes$),$ Title $(40$ bytes$),$ Author $(3$ bytes$),$ Genre $(8$ bytes$).$

Suppose the data file is clustered by the non$-$key field Genre with a separate block cluster for each group of

records and we want to construct a single layer clustering index on Genre.

Assume the $2000$ unique Genre values are evenly distributed on the records and a block pointer is $6$ bytes long.

The size of the next$-$block pointer is negligible and does not affect the blocking factor.

Calculate the average number of block accesses needed to search for and retrieve a record from the data file,

given its Genre value, by implementing the above$-$mentioned index as a single$-$level index.