Question: Database information: The database has 100,000 location records (AKA rows) Our O/S uses physical block sizes of 4096 bytes A location has the following fields

Database information: The database has 100,000 location records (AKA rows) Our O/S uses physical block sizes of 4096 bytes A location has the following fields and FIXED sizes in bytes . id (primary key): 4 bytes address: 256 bytes city: 50 bytes . county: 50 bytes state: 2 bytes zip: 5 bytes owner_info: 512 bytes Index 11 is based on id. Each index entry in 11 contains the id and a 4-byte pointer to the next block in the index (or a record's data block) Index 12 is based on state, address, and id. Each index entry in 12 contains state, address, id and a 4-byte pointer to the next block in the index (or a record's data block) Questions: A. How large is each record in bytes? B. How many records are in each data block? C. How many total data blocks are there? D. How large is an index entry in Index 11? E. How many index entries per index block in Index 11? F. How many index entries are in the leaf level of Index 11? G. How many index blocks are in the leaf level of Index 11? H. How many levels are in Index 11? 1. How large is an index entry in Index 12? J. How many index entries per index block in Index 12? K. How many index entries are in the leaf level of Index 12
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
