Suppose that we have 200 000 records with the following fields: ID = 11B Name =...

 

Transcribed Image Text:

Suppose that we have 200 000 records with the following fields: ID = 11B Name = 30B Address = 40B Sex = 1B Age (int) = 4B Salary (float) = 4B Block size=4 KB (4096 B) a) How many records can be stored in a block? b) How many blocks are needed for 200 000 records? c) If we apply dense indexing where key field for indexing is 90B and pointer is 6B, find the number of dense index blocks and the storage needed for dense indexing. Suppose that we have 200 000 records with the following fields: ID = 11B Name = 30B Address = 40B Sex = 1B Age (int) = 4B Salary (float) = 4B Block size=4 KB (4096 B) a) How many records can be stored in a block? b) How many blocks are needed for 200 000 records? c) If we apply dense indexing where key field for indexing is 90B and pointer is 6B, find the number of dense index blocks and the storage needed for dense indexing.

Answer rating: 100% (QA)

To solve this problem we first need to calculate the space each record occupies and then use that in... View the full answer