Question: Suppose that a relation factory ( ID , name, street, postcode ) contains 8 0 0 tuples. Each tuple is comprised of a header (
Suppose that a relation factoryID name, street, postcode contains tuples. Each tuple is comprised of a header bytes and four attributes: ID bytes name bytes street bytes and postcode bytes The size of each disc block is bytes and the size of the header of each disc block size bytes.
i How many blocks would be required to store the whole of this relation?
marks
ii How many blocks would be required to store a projection that does not include the attribute street?
marks
iii Explain why such a projection could be used to optimise a query whose results do not include data for the attribute street.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
