Register

Raghuramkrishnan Exercise-4.3 page-127

935 views
0 votes
0 votes
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?
User Avatar

1 Answer

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
2 answers
1
aditi19 asked May 8, 2019
1,254 views
Raghuramkrishnan Exercise-4.3 question 11 page no-127 Relational Algebra
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
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
User Avatar
0 votes
0 votes
0 answers
2
kumar.dilip asked Oct 27, 2018
539 views
Relational Algebra
Online Site For practicing Relational Algebra https://dbis-uibk.github.io/relax/calc.htm
Online Site For practicing Relational Algebrahttps://dbis-uibk.github.io/relax/calc.htm
User Avatar
2 votes
2 votes
1 answer
3
learner_geek asked Dec 3, 2017
1,720 views
Relational algebra
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?
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 s...
User Avatar
Link Copied!