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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!