Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? / Sets of examples to find the keys of a tables / Process of Key finding in a database – Examples / Normalization to BCNF.
- No partial key dependencies. So, R is in 2NF.
- No transitive dependencies. So, R is in 3NF.
- Every determinant (AB, BC, AC) is a candidate key. Hence, R is in BCNF as well.