Question 157

Decomposing R into R1 and R2 is lossless if:

  1. AR1 ∩ R2 → R1 or R1 ∩ R2 → R2
  2. BR1 and R2 have no common attribute
  3. CR1 ∩ R2 is empty
  4. DR1 ∪ R2 ≠ R
Show answerHide answer

Correct answer: (A) R1 ∩ R2 → R1 or R1 ∩ R2 → R2

Explanation

The common attributes must be a key of at least one part.

From DSSSB TGT Computer Science Full Mock Test 5

This is question 157 of DSSSB TGT Computer Science Full Mock Test 5. 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.