DB Design Advice Needed

Hello all!

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:

tbl_members:

1. memberID
2. memberName
3. memberPhoto (link)
4. memberBio

tbl_albums:

1. albumID
2. albumName
3. albumLabel
4. albumYear

tbl_tracks:

1. trackID
2. trackName
3. albumID
4. trackLyrics

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.

Any suggestions?

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

tbl_TrackToAlbum
taId
trackId
albumId

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. :)