I have three tables. One collects info about authors. Another collects info about the publications said authors write (one author can write many publications). The third table links the two tables together like so:
author_id | pub_id
Do I need to have an additional field in this table that is this link table's primary key with auto-incrementing? So that it looks like so:
link_id | author_id | pub_id
Or can I simply have a two-column table that collects author and pub info? Appreciate any help offered!
