Assume a relation R(A, B, C, D, E) with the set of functional dependencies F = { A → B, BC → D } and the candidate key (ACE). The relation is not in BCNF. Which of the following is the dependency preserving decomposition for R into BCNF relations?
A. R1(B, C, D), R2(A, B), R3(A, C, E)
B. R1(A, B), R2(A, C, D), R3(A, C, E)
C. R1(A, B), R2(A, C, D, E)
D. All of the above
Answer:A
Assume a relation R(A, B, C, D, E) with the set of functional dependencies F = { A → B, BC → D } and the candidate key (ACE). The relation is not in BCNF. Which of the following is the dependency preserving decomposition for R into BCNF relations?
A. R1(B, C, D), R2(A, B), R3(A, C, E) B. R1(A, B), R2(A, C, D), R3(A, C, E) C. R1(A, B), R2(A, C, D, E) D. All of the above