Relational Database Design and Modeling for Software Engineers
Vote

0% completed

​

Higher Normal Forms (4NF, 5NF)

Third normal form and BCNF are both about functional dependencies. One set of columns fixes the value of another. Almost every redundancy you meet in real work is one of those two problems.

A small number are not. This lesson covers the two rarer shapes. Knowing them lets you name the problem, instead of normalizing by instinct.

Both forms in this lesson assume the table is already in BCNF. Neither replaces the work of the last three lessons.

Fourth normal form: two independent lists in one row

A college records, for each student, the sports they play and the clubs they join

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content