DB Design Advice Needed
I'm about to start on a project that is bigger than anything I've ever done to this point and will be database driven Web site for a band.
On paper, this is what I've got for my database:
- memberPhoto (link)
I think that's it ... anyway, my challenge is, over the years this band has had member changes etc. I want to have it so each album listing has a listing of the members who worked on that album. I'm having problems conceptualizing how I'm going ot efficiently build that.
One track might appear in more than one album so instead of having albumId in tracks table, create a link table between albums and tracks
Ah yes ... I see. Okay ... so I sould do the same thing for a tbl_memberToAlbum as well ya?
You're right as well. Some songs do appear on more than one album. :)