905 views
1 votes
1 votes
Consider a disk with block size B=512 bytes. A block pointer is P=6 bytes
long,and a record pointer is P R =7 bytes long. A file has r=30,000
EMPLOYEE records of fixed-length. Each record size is fixed 50 bytes. Find out the no. Of block b requires .assuming an unspanned organization.

1 Answer

Best answer
1 votes
1 votes
Number of records in 1 block=$\frac{512}{50}=10$

Number of blocks required for the whole file$\frac{30000}{10}=3000$

Size of pointers=6+7=13B

No of access required=$\left \lfloor \frac{512}{13} \right \rfloor=39$

Number of blocks required=$\left \lceil \frac{3000}{39} \right \rceil=77$
edited by

Related questions

0 votes
0 votes
0 answers
1
0 votes
0 votes
1 answer
2
vishnu777 asked Nov 8, 2022
391 views
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
2 votes
2 votes
1 answer
4