Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Read the following information about the database REMEMBER: Floor for entries, Ceiling for blocks Database information: The database has 100,000 location records (AKA rows) Our
Read the following information about the database
REMEMBER: Floor for entries, Ceiling for blocks 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 12Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started