I'm learning and practicing with the E-R model trying to design a music industry database.

With this section of the diagram I have a doubt: BLUE OR RED?

I suppose an album can be had by an artist and a band, not necessary by only one of these. How can I represent this relationship?

  • 2
    An artist and a band are essentially the same entity? They are just different types of entity. One has many members of the band, the other is a single member band “Artist”. Just my opinion though
    – Philᵀᴹ
    Apr 19, 2019 at 19:50
  • You might find of help this Q & A.
    – MDCCL
    Apr 21, 2019 at 15:34

2 Answers 2


Theoretical Ideal

Aside from a learning example, if you want to actually do this I suggest checking out MusicBrainz which is an open source project to document the worlds music collection with one schema. It's pretty complex, but it has to be to get the job done.

You can find more information in their schema document.

enter image description here


Replace ALBUM with SONG, keep ALBUM but add a "many to many" relationship between the two.

There are still a lot of complexities you are missing (eg "Artist formerly known as Prince" vs "Prince", cover songs, etc)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.