Let us consider a relation R with the schema R (A, B, C, D). If we expect R to be in BCNF, then which of the following sets of functional dependencies must hold in R?
A. A → C, A → D, AD → C, B → A
B. C → B, C → D, A → C, D → A
C. C → D, CD → A, BD → A, AB → C
D. A → D, C → A, AC → B, D → B
Answer:B
Let us consider a relation R with the schema R (A, B, C, D). If we expect R to be in BCNF, then which of the following sets of functional dependencies must hold in R?
A. A → C, A → D, AD → C, B → A B. C → B, C → D, A → C, D → A C. C → D, CD → A, BD → A, AB → C D. A → D, C → A, AC → B, D → B