Consider a relational table that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?
- (A)
has a nontrivial functional dependency , where is not a superkey and is a prime attribute.
- (B)
has a nontrivial functional dependency , where is not a superkey and is a non-prime attribute and is not a proper subset of any key.
- (C)
has a nontrivial functional dependency , where is not a superkey and is a non-prime attribute and is a proper subset of some key.
- (D)
A cell in holds a set instead of an atomic value.
