Consider relations R(A,B,C) and S(C,D,E). R has 20,000 tuples and S has 45,000 ...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider relations R(A,B,C) and S(C,D,E). R has 20,000 tuples and S has 45,000 tuples. 25 tuples of R fit on one block, and 30 tuples of S fit on one block. Assuming that the buffer pool has more than 800 frames, what is the minimum number of block transfers that will be required to compute R S.
Want instant access to all verified answers on moodlenew.iitd.ac.in?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!