Normal Forms
Second normal form (2NF)
The only candidate key is (artist, title).
- artist → artist_website. Proves non-2NF.
- year really is dependent on both artist and title. Album titles
are not necessarily unique.
- Don McLean, Tapestry (1970)
- Carole King, Tapestry (1971)
- label really is dependent on both artist and title.
- label_website too, since it depends on label, (FDs are transitive).
|