Is this table in my ERD redundant? (Image) I am developing a research article database for a project. My professor approved this design but I feel like the Author's_University table is redundant and that University_ID could just be added to the Articles_Authored table. Can anyone think of a reason to NOT change it?

Thanks for the input.
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 Author's_University to 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 PascalCase over Snake_Case. That is merely personal preference though, and might clash with the convention in MySQL.