Solve only 4,5,6 . Please fast.
Consider the following scheme
Supplier (sid, Sname, rating)
Parts (Pid, pname, color)
Catalog (sid.
Pid, cost)
The catalog relation lists the prices charged for parts by suppliers.
Write the following queues in relational algebra. (i) Find name of suppliers who supply some red part.
(ii) Find the sids of suppliers who supply some red part or green part
(iii) find the sids of supplier who supply some red part and some green part
(iv) Find the sids of supplier who supply every part
(v) Find the sids of suppliers who supply every red part
(vi) Find the pids of parts supplied by two different supplier.
(vii) Find pair of sids such that the supplier with the first sid charges more for some part than
the supplier with the second sid.
(viii) Find the sid of supplier who supply most expensive part.