search
Log In
0 votes
251 views
Suppliers(sid, sname, address)

Parts(pid, pname, color)

Catalog(sid, pid, cost)

Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
in Databases 251 views
1

pls check whether my expression is correct or not

1 Answer

0 votes

Related questions

0 votes
1 answer
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?
asked May 7, 2019 in Databases aditi19 209 views
0 votes
0 answers
2
186 views
Online Site For practicing Relational Algebra https://dbis-uibk.github.io/relax/calc.htm
asked Oct 28, 2018 in Databases kumar.dilip 186 views
2 votes
1 answer
3
569 views
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum size of the join r1⋈ r2 is equal to r2⋈ r1 true or false?
asked Dec 3, 2017 in Databases learner_geek 569 views
1 vote
3 answers
4
2.1k views
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)
asked Apr 11, 2019 in Databases aditi19 2.1k views
...