If D = {R1, R2} is a decomposition of R, and F is the set of functional…

Coal India Management Trainee CBT 2017

If D = {R1, R2} is a decomposition of R, and F is the set of functional dependencies on R, then which of the following ensures that the decomposition D is lossless (nonadditive)?

  1. A.

    ((R1 ∩ R2) → (R1 − R2)) ∈ F+

  2. B.

    ((R1 ∩ R2) → (R1 − R2)) ∉ F+

  3. C.

    ((R1 ∪ R2) → (R1 − R2)) ∈ F+

  4. D.

    ((R1 ∩ R2) → R1) ∈ F+

Attempted by 376 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…