1 votes 1 votes Databases isisamplepapers + – shivanisrivarshini asked Apr 3, 2018 shivanisrivarshini 641 views answer comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments Jason commented Apr 3, 2018 reply Follow Share Relation Algebra Expression:- $\prod _{Sname}\left ( Supplier\Join \left ( \prod _{Sid}Catalog-\prod _{Sid}\left ( \left ( \prod _{Sid}Catalog\times \prod _{Pid}Parts \right ) -\prod _{Sid, Pid}Catalog\right ) \right ) \right )$ 1 votes 1 votes srestha commented Apr 3, 2018 i edited by srestha Apr 3, 2018 reply Follow Share No of block for supplier 2000/25=80 parts 4500/30=150 catalog 9000/45=200 Now question is "supplier who supply for every part" if each supplier supply for every part ans will be 80*150=1200 but catalog table contains only 200 tuples If 1 supplier supply for every 150 parts then already 150 block access will be there So, ans 150 block access 0 votes 0 votes Jason commented Apr 3, 2018 reply Follow Share @srestha what you are using Block nested loop or nested loop join?? 0 votes 0 votes Please log in or register to add a comment.