Consider the relation R(A, B, C, D, E) with set of functional dependencies F = {A → B, C → D}. Let us assume that R is in 1NF. Which of the following is the correct BCNF decomposition of R?
A. R1 (A, C, D, E) and R2 (A, B)
B. R1 (A, B, C, E) and R2 (C, D)
C. R1 (A, B), R3 (C, D), and R3 (A, C, E)
D. All of the above.
Answer:C
Consider the relation R(A, B, C, D, E) with set of functional dependencies F = {A → B, C → D}. Let us assume that R is in 1NF. Which of the following is the correct BCNF decomposition of R?
A. R1 (A, C, D, E) and R2 (A, B) B. R1 (A, B, C, E) and R2 (C, D) C. R1 (A, B), R3 (C, D), and R3 (A, C, E) D. All of the above.