Q1- Select * from instructor where id = 83821 Index file = 2 blocks, instructor relation = 12 blocks (one record in one block) Question 4-1: How many seek and block transfer are needed to process the query a.using index? b.without index. Index 10101 12121 15151 22222 32343 33456 45565 58583 76543 76766 83821 98345 10101 Srinivasan Comp. Sci. 12121 Wu Finance 15151 Mozart Music 22222 Einstein Physics 32343 El Said History 33456 Gold Physics 45565 Katz Comp. Sci. 58583 Califieri History 76543 Singh Finance 76766 Crick Biology 83821 Brandt Comp. Sci. 98345 Kim Elec. Eng 65000 90000 40000 95000 60000 87000 75000 62000 80000 72000 92000 80000 124 Q1- Select * from instructor where id = 83821 Index file = 2 blocks, instructor relation = 12 blocks (one record in one block) Question 4-1: How many seek and block transfer are needed to process the query a.using index? b.without index. Index 10101 12121 15151 22222 32343 33456 45565 58583 76543 76766 83821 98345 10101 Srinivasan Comp. Sci. 12121 Wu Finance 15151 Mozart Music 22222 Einstein Physics 32343 El Said History 33456 Gold Physics 45565 Katz Comp. Sci. 58583 Califieri History 76543 Singh Finance 76766 Crick Biology 83821 Brandt Comp. Sci. 98345 Kim Elec. Eng 65000 90000 40000 95000 60000 87000 75000 62000 80000 72000 92000 80000 124