The purpose of the
Author's_University table seems to be to allow one author on an article to be associated with more than one university. There are a couple of potential reasons why that would be helpful:
- An author might claim multiple universities because they are a professor and/or are associated with more than one university when the article was published.
- Your application might want to track an author's alma mater(s).
I know this isn't part of your question but I would avoid putting an apostrophe in a table name. Removing the apostrophe would change
Authors_University or just
Author_University (my preference). That will most likely make the table easier to work with because punctuation isn't your friend when naming.
Also, my personal preference is
Snake_Case. That is merely personal preference though, and might clash with the convention in MySQL.