Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

What is the vested benefit obligation?

Answered: 1 week ago

Question

obtain Poisson probabilities.

Answered: 1 week ago