Question 154Asked in CIL MT Systems, 26 Mar 2017 (12:30 PM)

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…

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⁺
Show answerHide answer

Correct answer: (A) ((R1 ∩ R2) → (R1 − R2)) ∈ F⁺

From CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM)

This is question 154 of CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.