BCNF
Learn BCNF (Normalization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Boyce-Codd Normal Form is a stricter 3NF: for every functional dependency X -> Y, X must be a superkey (a key or a superset of one). In enrol3, teacher -> subject holds but teacher alone is not a key, so the table violates BCNF.