Let us assume a relation R (A, B, C, D, E) that is in BCNF. If BCD is the only key for R, then which of the following functional dependencies is guaranteed to hold for R?
A. ABCE → D
B. ABCD → E
C. BCE → A
D. None of the above
Answer:D
Let us assume a relation R (A, B, C, D, E) that is in BCNF. If BCD is the only key for R, then which of the following functional dependencies is guaranteed to hold for R?
A. ABCE → D B. ABCD → E C. BCE → A D. None of the above