HuntExams Academy
SQLAdvanced#normalization

What is BCNF?

Boyce-Codd Normal Form is a stricter 3NF: for every functional dependency X → Y, X must be a super key. It removes anomalies that 3NF can still allow with overlapping candidate keys.

Example
teacher_subject(student, subject, teacher) with teacher → subject violates BCNF.
Split into teacher(teacher, subject) and student_teacher(student, teacher).

Related Questions

1
SQLIntermediate#normalization

What is denormalization and when do you use it?

Open
2
SQLBeginner#sets

UNION vs UNION ALL?

Open
3
SQLIntermediate#sets

What are INTERSECT and EXCEPT/MINUS?

Open