Consider the join R join R.a=S.b S, given the following information about the relations to be joined. Compute the I/O costs for the following join operations

1. Consider the join R iRa- s.b S, given the following information about the relations to be joined Compute lVO costs for the following join operations (10 points) Relation R contains 4,000 tuples with blocking factor= 10 Relation S contains 2,000 tuples with blocking factor= 10 Attribute a of relation R refers to attribute b of relation S Attribute b of relation S is the primary key for S Both relations are stored as simple heap files and 52 buffer caches (pages) are available Each tuple in S matches with two tuples in R on average a) (5 pts) What is the cost of joining R and S using a block nested loop join ume S. b has the secondary index with Index level-1. What is the cost of joining R and S using Index based nested loop join