Question discussion

A relation R(A,B,C) has the multi-valued dependency A→→B. If R is decomposed into R1(A,B) and R2(A,C) to satisfy 4NF, this decomposition is:

524Medium DSSSB TGT Computer Science 0 replies
A relation R(A,B,C) has the multi-valued dependency A→→B. If R is decomposed into R1(A,B) and R2(A,C) to satisfy 4NF, this decomposition is:
  • ALossy and not dependency-preserving
  • BA lossless-join decomposition
  • CNot a valid decomposition
  • DOnly valid if A is not a candidate key
Correct answer: B

Discussion 0

Nobody has replied yet. Start the discussion!