# Raghuramkrishnan Exercise-4.3 question 11 page no-127 Relational Algebra

251 views

Parts(pid, pname, color)

Catalog(sid, pid, cost)

Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
1

pls check whether my expression is correct or not

Ans:

## Related questions

1
209 views
Given relation catalog(sid, pid, cost) Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid what is the relational algebra expression for this?
Given two relations R1 and R2, where R1 contains N1 tuples, R2 contains N2 tuples, and N2>N1> 0, give the minimum and maximum possible sizes (in tuples) for the result relation produced by each of the following relational algebra expressions. In each case, state any assumptions about ... difference) $R1 X R2$ (cartesian product) $σa=5(R1)$ (selection) $\pi a(R1)$ (projection) $R1/R2$ (division)