DB Design Advice Needed

[cwebmedia]

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?

[sylow]

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

[cwebmedia]

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.