1 Reply Latest reply on Sep 29, 2011 8:16 AM by philmodjunk

    set of many-to-many relationships btw same tables?

    KathrynOstrofsky

      Title

      set of many-to-many relationships btw same tables?

      Post

      Hello,

      I'm a student with no background in database design, trying to create my first database, and I need to keep track of several sets of many-to-many relationships between the same tables. For example, I have a People table and a Works table, but people have several different relationships to works. A song may have multiple composers and multiple lyricists, and each person may contribute to many songs.  However, I can't use a simple join table, because the same person might compose one song and write lyrics for another, and I need to keep track of what each individual's contribution was to each work.  How would I do that?   Thanks, -k