PLEASE SHOW ALL WORK FOR NUMBER 1, 2 AND 3! A database file has 6,000,000 record

Question

PLEASE SHOW ALL WORK FOR NUMBER 1, 2 AND 3!

A database file has 6,000,000 records, which occupy disk storage at a density of 12 records per block. A daily update modifies 3.5 percent of the file and we assume that the updates are distributed uniformly across the records. Weekly the system must rewrite any block, which has an update to any of the records in the block. The probability that an individual block will be rewritten p = ___ Show work: Let X denote the Binomial Distribution associated with all the blocks in the file. The parameters of this distribution, n, p, are: n =, p = Show work: The average number of blocks rewritten mu_x = Show work:

Explanation / Answer

Solution:

1) Given, total number of records = 6,000,000

    Each block has 12 records, so, total number of blocks = 6,000,000/12 = 500000

    Each update modifies 3.5% of the file, so, (3.5/100)* 6,000,000 = 210000 records

    Therefore, each update modifies, 210000/12 = 17500 blocks

   The probability that an individual block will be rewritten = 17500 / 500000 = 0.035

2) n = 500000, p= 0.035

3) The average number of blocks rewritten = 500000*0.035 = 17500

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.