Part $3$: B$+-$Tree Index Calculation

Question $18(2$ points$)$ Saved

A disk has block size of $1024$ bytes. A file has $30,000$ EMPLOYEE records of fixed

length. Each record has the following fields: NAME $(30$ bytes$),$ SSN $(9$ bytes$),$

DEPARTMENTCODE $(9$ bytes$),$ ADDRESS $(40$ bytes$),$ PHONE $(9$ bytes$),$ BIRTHDATE

$(8$ bytes$),$ SEX $(1$ byte$),$ JOBCODE $(4$ bytes$),$ SALARY $(4$ bytes, real number$).$

How many records can be stored in a disk block?

Question $19(2$ points$)$

A disk has block size of $1024$ bytes. A file has $30,000$ EMPLOYEE records of fixed

length. Each record has the following fields: NAME $(30$ bytes$),$ SSN $(9$ bytes$),$

DEPARTMENTCODE $(9$ bytes$),$ ADDRESS $(40$ bytes$),$ PHONE $(9$ bytes$),$ BIRTHDATE

$(8$ bytes$),$ SEX $(1$ byte$),$ JOBCODE $(4$ bytes$),$ SALARY $(4$ bytes, real number$).$

How many blocks are required to store the entire file? Solve both problems in image