517 views
0 votes
0 votes
Consider an EMPLOYEE file with 10000 records where each record is of size 80 bytes. The file is sorted on employee number (15 bytes
long), which is the primary key. Assuming un-spanned organization, block size of 512 bytes and block pointer size of 5 bytes, compute
the number of block accesses needed for retrieving an employee record based on employee number if (i) No index is used (ii) Multi-level
primary index is used.

Please log in or register to answer this question.

Related questions

2 votes
2 votes
2 answers
2
atulcse asked Jan 22, 2022
598 views
If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency?
6 votes
6 votes
5 answers
4