The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+13 votes
909 views

The relational algebra expression equivalent to the following tuple calculus expression:

$\left\{t \mid t \in r \land \left(t[A] = 10 \land t[B]=20\right)\right\}$ is

  1. $\sigma_{(A=10 \lor B=20)} (r)$

  2. $\sigma_{(A=10)} (r) \cup \sigma_{(B=20)} (r)$

  3. $\sigma_{(A=10)} (r) \cap \sigma_{(B=20)} (r)$

  4. $\sigma_{(A=10)} (r) - \sigma_{(B=20)} (r)$

asked in Databases by Veteran (69k points)
edited by | 909 views

1 Answer

+15 votes
Best answer
Answer: C

Tuple t should have two attributes A and B such that t.A = 10 and t.B = 20.

So, (Tuples having A = 10) $\cap$ (Tuples having B = 20) = (Tuples having A = 10 and B = 20).
answered by Veteran (36.4k points)
selected by


Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

33,687 questions
40,230 answers
114,268 comments
38,793 users