What is the cause of these problems?
Review:
- Same values stored multiple times.
- Updating duplicated data is inconsistent or
potentially restricts throughput.
- Row combines Album and Label info, so can't represent Label
without at least one Album.
- Similarly, deleting only album of a Label deletes the Label too!
Demo
See schema_1.sql, populate_1.sql, queries_1.sql
|