database
design
entity relationship diagram
I plan to have a one to many relationship between the CD entity and the Order entity. This is because according to the given data set, one CD can have many orders.

The crows foot indicates this truth.
Click next to continue...