SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Zealot cwebmedia's Avatar
    Join Date
    Nov 2002
    Location
    Calgary, Alberta, Canada
    Posts
    180
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question 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?

    Keep smiling ...
    It makes people wonder what you're up to ...

  2. #2
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  3. #3
    SitePoint Zealot cwebmedia's Avatar
    Join Date
    Nov 2002
    Location
    Calgary, Alberta, Canada
    Posts
    180
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

    Keep smiling ...
    It makes people wonder what you're up to ...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •