If a relation with a schema R is decomposed into two relations R1 and R2 such…

PYQ UGC NET 2012Modified — slightly modified from the official paper; see the solution

If a relation with a schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R, then which one of the following is to be satisfied for a lossless join decomposition (→ indicates functional dependency)?

  1. A.

    R1 ∩ R2 → R1 or R1 ∩ R2 → R2

  2. B.

    R1 ∩ R2 → R1

  3. C.

    R1 ∩ R2 → R2

  4. D.

    R1 ∩ R2 → R1 and R1 ∩ R2 → R2

Attempted by 188 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…