You can have a look at
this[
^] database model as a starter.
This one is also flawed if you want to be picky.
It doesn't take into account that an artist and a band with its members aren't the same thing. It also doesn't take into account that sometimes an artist changes his/hers artist name, but you would still like to have the albums listed together.
But it's a starter.