Database System Question An automobile part trading company would like to store the following attributes for each part...

70.2K

Verified Solution

Question

Electrical Engineering

Database System Question
An automobile part trading company would like to storethe following attributes for each
part in a database table:

PartNo: 10 bytes
Name: 30 bytes
UintMeasure: 5 bytes
UnitCost: 4 bytes
UnitPrice: 4 byes
QtyOnHand: 4 bytes
QtyOnOrder: 4bytes
PreferredSupplier: 30 bytes

Consider a disk with block size of 512 bytes and block pointer of 6bytes long. Each record has a unique value of PartNo.
There are altogether 50,000 parts in the company.

Compute the following:

i) The number of file blocks required for storing the partrecords.

ii) The percentage of disk space saving achieved by implementingPartNo as primary index from implementing it as secondaryindex.

iii) The percentage of improvement on number of block accessesrequired for searching a product record based on PartNoâ€™s valueachieved by implementing PartNo as primary index from implementingit as secondary index.

Answer & Explanation Solved by verified expert

3.6 Ratings (496 Votes)

Answer 1 Number of file blocks required for storing the part records Record length R 10 30 5 4 4 4 4 30 91bytes Here number of file blocks b assuming an unspanned organization Blocking factor bfr floor51291 5626 recordsblock No of blocks required for one file ceiling500005626 8887 2 Disk space saving achieved by implementing PartNo as primary index See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member