A schema with problems
Insertion anomaly
How do we represent a label that has only signed any artists who have no albums?
This doesn't work:
| artist |
artist_website |
title |
year |
label |
label_website |
| Portugal, The Country | NULL | NULL | NULL | Broken Records | broken-records.com |
- The PK is (artist, title).
- PK columns cannot be NULL.
- artist is not NULL but title is.
|