Suppose that a disk has storage capacity of 1TB and a block size of 4096 bytes. We have a table with 100,000 records each record has a size of 2050 bytes. Answer these questions:

What is the total capacity of RAID 0 with 10 drives?

What is the total capacity of RAID 5 with 10 drives?

How many blocks are needed for spanned and unspanned records, respectively?

What is the block (space) utilization in both cases?

Assume that the disk has a read bandwidth of 1 GB/sec. Suppose that data is stored sequentially. What is the time to read all records in the unspanned configuration?

If records do not exactly fit in a block, we have two choices: (i) Waste the space at the end of each block and (ii) Start a record at the end of a block and continue on the next. Choice (i) is the unspanned option. Choice (ii) is the spanned option