A file has 7-20,00ey bytes) sa622Aybek). ADENT records of fixed length. Each record has the following fields. Name (30 (40 bytes), PHONE (10 (8 Sabyte). Majar_dept_code (4 bytes), Minar_dept code (4 bytes), Class_code (4 bytes, integer), and Degree program (3 bytes) An additional byte is used as a deletion marker. Suppose only 80% of the STUDENT records have a value for PHONE, 85% for MAJORDEPTCODE, 15% for MINORDEPTCODE, and 90% for DEGREEPROGRAM, and we use a variable-length record file. Each record has a 1-byte field type for each field occurring in the record(NAME, SSN, ADDRESS, BIRTHDATE, SEX, CLASSCODE), plus the 1-byte deletion marker and a 1-byte end-of-record marker. Suppose we use a spanned record organization, where each block has a 5-byte pointer to the next block (this space is not used for record storage). (a) Calculate the average record length Rin bytes. (5 marks) (b) Calculate the number of blocks needed for the file. (5 marks) A file has r-20,000 STUDENT records of fixed length. Each record has the following fields. Name (30 bytes), San (ykeh). Address (40 bytes), PHONE (10 bytes), Birth_date (8 bytes). SEX byte), Major_dept_code (4 bytes). Minor_dept_code (4 bytes), Class_code (4 bytes, integer), and Degree program (3 bytes). An additional Byte is used as a deletion marker. Suppose only 80% of the STUDENT records have a value for PHONE, 85% for MAJORDEPTCODE, 15% for MINORDEPTCODE, and 90% for DEGREEPROGRAM, and we use a variable-length record file. Each record has a 1-byte field type for each field occurring in the record(NAME, SSN, ADDRESS, BIRTHDATE, SEX, CLASSCODE), plus the 1-byte deletion marker and a 1-byte end-of-record marker. Suppose we use a spanned record organization, where each block has a 5-byte pointer to the next block (this space is not used for record storage). (5 marks) (a) Calculate the average record length Rin bytes. (b) Calculate the number of blocks needed for the file. (5 marks)