|< < 28 > >|

Normal Forms

Third Normal Form (3NF)

What about LessBadAlbum?

The only candidate key is (artist, title).

Relevant functional dependencies

• artist, title → label, because (artist, title) is the key.

• label → label_website.

• label_website is a non-prime column that is transitively dependent on (artist, title).

So LessBadAlbum is not 3NF.

But Artist, Album, Label are all 3NF.

|< < 28 > >|