The student data file(fixed length record) contains the foll…
The student data file(fixed length record) contains the following attributes: Id : Varchar(10) (10 bytes) Name : Varchar(17) (17 bytes) Phone : Varchar(10) (10 bytes) GPA : Double (3 bytes) -all GPAs are null values. And index file(fixed length record) contains the following attributes: Id : Varchar(8) (8 bytes) Pointer: Double (2 bytes) There are 40,000 records in this data file. We want to store the data and index files in a hard drive with the block(page) size = 2KB ~ 2,000 B. The number of blocks or pages that need for storing the data file in a hard drive = _______ . (The answer must be integer) The number of blocks or pages that need for storing the index file in a hard drive = _______ . (The answer must be integer) Given RAID level 10 for storing data and index files using 8 hard drives, how many blocks for each drive = _______ . (The answer must be integer) and a data storage space = _______ % usage. (The answer must be integer)