Consider a schema R(A, B, C, D) and functional dependencies A - B and C - D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

Question

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

Admin · Accepted Answer

not dependency preserving and not lossless join

Admin · Answer

dependency preserving and lossless join

Admin · Answer

lossless join but not dependency preserving

Admin · Answer

dependency preserving but not lossless join

Q. Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is