I'm constructing a database for a journal. I need a table containing the
articles (or at least the titles of the articles) published issue by issue
over the years. I also need a table of the accumulating list of contributors.
Some articles have multiple authors, and some authors contribute more than
once. I need to be able to retrieve data on which articles were published in
each issue, and who the multiple authors were, and from the opposite
direction I must also be able to view what articles (sometime multiple
articles)  each author has contributed to.

I'm finding it very tricky to juggle the complicated many-to-one and
one-to-many relationships here. Some sort of junction table seems called for
but I haven't so far been very successful getting these to work.

I'm sure there must be a well established way to approach this jumble and
I'm hoping someone can give me some tips.