[Solved]-Ql Data File Given Following Data File Student Student Name 30 Bytes Ssn 9 Bytes Address 4 Q37227762

please i need your help in database. thank you
Ql: Data file Given the following data file for STUDENT STUDENT [ NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE(I0 bytes), DOB (8 bytes), SEX (I byte), MAJOR (4 bytes), MINOR (4 bytes), CLASS (4 bytes), DEGREE (3 bytes) ] Suppose that block size B-512 bytes, and the number of records r -20,000. The records are fixed length and unspanned. A. (3 points) Calculate the record size R in bytes B. (3 points) Calculate the blocking factor bfir C. (3 points) Calculate the number of file blocksb (3 points) Calculate the average number of blocks to find a record by doing a linear search on the file D. # of blocks- (3 points) Assume that the file is ordered by SSN. a record given its SSN value by doing a binary search E. Calculate the average number of blocks to find Average # of blocks- Show transcribed image text Ql: Data file Given the following data file for STUDENT STUDENT [ NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PHONE(I0 bytes), DOB (8 bytes), SEX (I byte), MAJOR (4 bytes), MINOR (4 bytes), CLASS (4 bytes), DEGREE (3 bytes) ] Suppose that block size B-512 bytes, and the number of records r -20,000. The records are fixed length and unspanned. A. (3 points) Calculate the record size R in bytes B. (3 points) Calculate the blocking factor bfir C. (3 points) Calculate the number of file blocksb (3 points) Calculate the average number of blocks to find a record by doing a linear search on the file D. # of blocks- (3 points) Assume that the file is ordered by SSN. a record given its SSN value by doing a binary search E. Calculate the average number of blocks to find Average # of blocks-

Expert Answer

---

Answer to Ql: Data file Given the following data file for STUDENT STUDENT [ NAME (30 bytes), SSN (9 bytes), ADDRESS (40 bytes), PH… . . .