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.
