1

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 at 19:50
  • You might find of help this Q & A. – MDCCL Apr 21 at 15:34
0

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)

0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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