If I have the following relation R = (A, B, C, D)And the functional dependencies:A -> B,   B -> A,  CDB -> A,   CDA -> BThe candidate keys are CDA and CDB.The third normal form says that there can not be a functional dependency between non-prime attributes. A non-prime attribute is an attribute that doesn't occur in one of the candidate keys. Then that means that this relation already is 3NF since both A and B, that depend on each other, are part of one of the candidate keys, am I right?If so, I have another question about BCNF. BCNF says that every determinant must be a candidate key. In this case, A and B are not candidate keys, so that violates BCNF, or am I missing something here?Thanks.
Normalization 3NF and BCNF
database;normalization