Multiple choice

Consider a schema R(A,B,C,D) and functional dependencies A$\rightarrow$ B and C$\rightarrow$ D. Then the decomposition of R into R1(AB) and R2] (CD)g is

  1. dependency preserving and lossless join

  2. lossless join but not dependency preserving

  3. dependency preserving but not lossless join

  4. not dependency preserving and not lossless join

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation