Normalisation from 1nf to 2nf

Question

I have converted the following 1NF table to 2NF as follows. Still having doubt if I have done it right and also unable to determine the transitive dependency.

I believe - cdName is transitively dependent on cdId via date.

Thanks for any advice.

Answer 1

You are correct - cdName should be in the table keyed by 'cdId'. You should also have a table keyed by recId with the recName attribute.

(Your "band" table has duplicate entires, but that's a data issue, not a design issue.)