Register

DBMS Relational Algebra

1,253 views
0 0 votes
Let R1(a,b) = {(2,3),(3,2),(2,4),(2,5)},R2={(2,2),(3,3)} then find $\Pi_{AB(R1)}/\Pi_{B}(\sigma _{c>3}(R2))$

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Number of InversionsNext → · TOC :- Number of sta...
← Previous in category · Natural Join - R con...Next in category → · ER Model DBMS
Position:
Show:

Related questions

1 1 vote
2 2 answers
69
69 views
GO Classes asked 9 hours ago
69 views
GO Classes DPP | GATE CS, DA | DBMS | Relational Algebra
Consider the relations:$\mathrm{Users(username, name, email, password, address)}$and$\mathrm{FriendsWith(username, username2, sincewhen)}$.A friendship tuple indicates th...
1 1 vote
1 1 answer
32
32 views
GO Classes asked 9 hours ago
32 views
GO Classes DPP | GATE CS, DA | DBMS | Relational Algebra
Consider the relations:$\mathrm{STUDENT(name,regno,gpa,level,dept)}$$\mathrm{COURSE(cno,cname,dept)}$$\mathrm{TAKE(regno,cno)}$Using only the basic relational algebra ope...
1 1 vote
1 1 answer
32
32 views
GO Classes asked 9 hours ago
32 views
GO Classes DPP | GATE CS, DA | DBMS | Relational Algebra
Consider $R(a,b)$ and $S(c,d)$.Which relational algebra expression is equivalent to:SELECT a, d FROM R, S WHERE R.a 10 AND R.b = S.c;Use only the basic operators.$\pi_{a...
1 1 vote
1 1 answer
28
28 views
GO Classes asked 9 hours ago
28 views
GO Classes DPP | GATE CS, DA | DBMS | Relational Algebra
Let $R$ and $S$ be union-compatible relations.Which expression computes $R\cap S$ using only union and set difference?$(R\cup S)-((R-S)\cup(S-R))$ $(R\cup S)-(R-S)$ $(R-S...