Register

navathe secondary key

190 views
1 votes
1 votes
When we have 30000 records, 10 records per block so we need 3000 records, when no indexing is there searching via non -key value it takes b/2 access in worst case

Doubt: please guide, Records are not arrange physically in file,we are doing linear search to find target why we are doing (#blocks)/2    i.e 3000/2

not 30000/2 ,

please guide I don,t know where I mismatch the things.
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
Doraemon asked Apr 20, 2019
297 views
navathe-doubt
previous value of X=9 Sf : w1(X, 5); w2(X, 8); a1; cascadeless schedu;e . what problem will the schedule face??
previous value of X=9Sf : w1(X, 5); w2(X, 8); a1;cascadeless schedu;e . what problem will the schedule face??
User Avatar
0 votes
0 votes
1 answer
3
Prince Sindhiya asked Sep 12, 2018
590 views
Dbms navathe
Consider the entity type DEPENDENT, related to EMPLOYEE, which is used to keep track of the dependents of each employee via a 1:N relationship,(assume dependent is weak entity) Please explain that how we are saying that it is 1:N relationship? if possible then explain it with table.
Consider the entity type DEPENDENT, related to EMPLOYEE, which is used to keeptrack of the dependents of each employee via a 1:N relationship,(assume dependent is weak en...
User Avatar
Link Copied!