BCNF

Learn Boyce-Codd normal form.

BCNF is a stricter form of 3NF. Every dependency must rely on a super key.

-- BCNF: her A → B bağımlılığında A süper anahtardır

BCNF is stricter than 3NF.

BCNF — details

BCNF is rarely violated. It arises with overlapping candidate keys.

In practice most designs stop at 3NF; BCNF only requires an extra split in special tables where several candidate keys overlap.

Bring a students table to BCNF: split overlapping candidate keys.

Show example solution

CREATE TABLE student_advisor (
  student_id INT,
  advisor_id INT
)

BCNF key

BCNF: every determinant is a ____ of the table

Show answer

BCNF: every determinant is a superkey of the table