Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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