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?

  1. A.

    T(B) = {b1, b3}

  2. B.

    T(B) = {b1, b2, b4}

  3. C.

    T(B) = {b1, b4}

  4. D.

    T(B) = {b1, b3, b4}

Attempted by 544 students.

Sign up free to check your answer

Sign up free

Explore the full course: Coal India Management Trainee

Loading lesson…