Consider the relation schemas R(A, B) and S(A) with the following tuple sets.…
PYQ Coal India Management Trainee CBT 2017
Consider the relation schemas R(A, B) and S(A) with the following tuple sets.
Relation R(A, B):
A | B |
|---|---|
a1 | b1 |
a2 | b1 |
a3 | b1 |
a4 | b1 |
a1 | b2 |
a3 | b2 |
a2 | b3 |
a3 | b3 |
a4 | b3 |
a1 | b4 |
a2 | b4 |
a3 | b4 |
Relation S(A) = {a1, a2, a3}
What is T ← R / S, where “/” denotes the relational-algebra division operation?
- A.
T(B) = {b1, b3}
- B.
T(B) = {b1, b2, b4}
- C.
T(B) = {b1, b4}
- D.
T(B) = {b1, b3, b4}
Attempted by 544 students.
Sign up free to check your answer
Sign up freeLoading lesson…

