set of many-to-many relationships btw same tables?
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