Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

for the parent x^(2) and the, modified version -4(x-3)^(2)

Answered: 1 week ago

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago

Question

e. What do you know about your ethnic background?

Answered: 1 week ago