The relational algebra expression equivalent to the following tuple calculus expression
{ t | t ∈ r ∧ (t[A] = 10 ∧ t[B] = 20 }
is
(A) a
(B) b
(C) c
(D) d
Answer: (C)
Explanation: In Given relational algebra, Tuple t should have two attributes A=10 and B=20
In A, we select tuples having A=10 or B=20 so, it is wrong choice.
In B, we select tuples having A=10 or we can select tuples having B=20, so it is also wrong choice.
D is also wrong choice.
In C, we select tuples having A=10 and tuples having B=20, it is same as above relational algebra. Hence, option (C) is Correct.
Quiz of this Question