ISI sample paper

Question

Comments

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 )$

---

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

---

@srestha what you are using Block nested loop or nested loop join??