Database, Database systems, SQL

(Physical Data Organization )

Assume a sorted file with 40,000 records and a block size of 512 bytes. Each record has a fixed-length size of 200 bytes. An index entry needs 9 bytes for the index field and 6 bytes for the pointer. the search relates to a non-primary key attribute? It is sufficient if you answer the question theoretically. 2)How many number of accesses are necessary if there is a secondary index and the search relates to a non-primary key attribute? It is sufficient if you answer the question theoretically.