Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider a disk with a block size B = 512 bytes, a block pointer P = 6 bytes, and a record pointer PR-7 bytes. Suppose,
Consider a disk with a block size B = 512 bytes, a block pointer P = 6 bytes, and a record pointer PR-7 bytes. Suppose, file hasr = 30000 EMPLOYEE records of fixed length. Each record has following attributes: Name (30 bytes); Ssn (9 bytes); Department_code (9 bytes); Address (40 bytes); Phone (10 bytes); Birth_date (8 bytes); Sex (1 byte); Job_code (4 bytes); Salary (4 bytes); Additional byte is used as a deletion marker. Suppose, file is ordered by key attribute Ssn and primary index is constructed on this key attribute. Calculate: Index blocking factor bfri. Number of first-level index entries and number of first-level index blocks. Number of levels needed if multilevel indexes were used. Total number of blocks required by multilevel index. Number of block accesses needed to search for & retrieve record from file using primary index
Step 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