Question: Let's think about the size and storage for 2 Files of a database that markets homes for rent. (Like VRBO or Air B&B). It may

 Let's think about the size and storage for 2 Files of

Let's think about the size and storage for 2 Files of a database that markets homes for rent. (Like VRBO or Air B\&B). It may help you to imagine filling in the information in each schema construct shown to understand the data that would be stored. DENIT^I 1. Using the schema constructs shown above, determine the size of a record in each file. 2. For each Entity, tell if the records will be a fixed or variable length and explain why. Consider a disk with the following characteristics (these are not parameters of any particular disk unit): block size B =512 bytes; interblock gap size G=128 bytes; number of blocks per track =20; number of tracks per surface =400. A disk pack consists of 15 double-sided disks. 3. The RENTAL file has r=20,000 RENTAL records. In addition to the size and type of a record you estimated above, there is an additional byte added to each record and used as a deletion marker. The file is stored on the disk whose parameters are given above. a. Calculate the record size R in bytes. b. Calculate the blocking factor bfr and say what the number represents. For this type of record. c. Calculate the number of file blocks b, assuming a spanned organization. d. Calculate the file size r in bytes. e. Calculate the unused space in b. f. If the RENTAL file grows each year because there are more properties to rent, how will R change

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!