[Solved]Given R B C Fd Set F B B C Following Two Decompositions R1 B R2 B C B R1 B R2 C Decomposi Q37224885

I’m confused on this question

Given R(A, B,C) and the FD set F A-B; B-C), and the following two decompositions A. R1(A, B) and R2(B,C) B. R1 (A, B) and R2(A, C) a) Which of the decompositions (A) or (B) is better? Why? b) Does the decomposition (A) have the non-additive join property (lossless)? Why? c) Does the decomposition (B) have the non-additive join property (lossless)? Why? d) What can you say about the decomposition: R1 (A, C): R2(B, C)? Show transcribed image text Given R(A, B,C) and the FD set F A-B; B-C), and the following two decompositions A. R1(A, B) and R2(B,C) B. R1 (A, B) and R2(A, C) a) Which of the decompositions (A) or (B) is better? Why? b) Does the decomposition (A) have the non-additive join property (lossless)? Why? c) Does the decomposition (B) have the non-additive join property (lossless)? Why? d) What can you say about the decomposition: R1 (A, C): R2(B, C)?

Expert Answer

---

Answer to Given R(A, B,C) and the FD set F A-B; B-C), and the following two decompositions A. R1(A, B) and R2(B,C) B. R1 (A, B) an… . . .