consider following relation;
supplier(sid,sname,rating)
parts(pid,pname,color)
catalog(sidpid,cost)
where sid,pid&sidpid is PK
what is formet for RA,SQL,TRC :
1.retrive sname supplied atlest one parts
2.retrive sname supplide some red parts
3.retrive sid supplied some red parts or some green parts
4.retrive sid supplied some red parts and some green parts
5.retirve sid supplied only red parts
6.retirve sid supplied every red parts
7.retirve sid supplied altest red parts
8.retirve sid supplied every red parts or retirve sid supplied every green parts
9 retirve sid supplied every red parts but not any green parts
10.retrive sid whose rating is greater then10
11.retrive sid whose rating is greater then 10 and supply every green parts
12. retrive sid who supplied most expensive parts
13 retrive sid who supplied second most expensive parts
14.retrive sid who supplied least expensive parts
15.retrive sid who supplied only 2 parts
16.retrive sid who supplied atmost 2 parts
17.retrive sid who supplied altest 2 parts
