edited by
5,722 views
29 votes
29 votes

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)$

edited by

1 Answer

Best answer
32 votes
32 votes

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).$

edited by
Answer:

Related questions

35 votes
35 votes
3 answers
1
36 votes
36 votes
2 answers
2
53 votes
53 votes
3 answers
4
Kathleen asked Sep 23, 2014
14,057 views
For the schedule given below, which of the following is correct:$$\begin{array}{ll} \text{1} & \text{Read A} & \text{} \\ \text{2} & \text{} & \text{Read B} \\ \text{3...