Entity-Relationship Diagram for a scenario involving Books, Authors and Countries Certainly a noobish question, but I'll ask it anyway. Perhaps someone else will be thankful. ^^

I am getting warmed up with MySQL and I try to understand the concepts of creating well structured databases. Currently I am reading about Entity-Relationship Diagrams (ERD) and I asked myself:

If I have three tables which are linked by a forth one, for example: A book written by one ore more authors, and each authors and was published in one ore more countries.

authors          books            countries
id | name        id | book        id | publishedInCountry
 1 | ...          1 | ...          1 | ...
 1 | ...          2 | ...          2 | ...
 1 | ...          2 | ...          3 | ...
 4 | ...          1 | ...          3 | ...


linkTable
idOfAuthor | idOfBook   | idOfCountry
 1         | 1          | 1
...


How would an ERD look like for these ones?

Additional information

I thought of:

[authors] -- &lt; is author of > -- [books] -- &lt; was published in > [countries]

But how do I fit in the linkTable?
as far as I can see,

you need two separate link tables as these are unrelated, one for linking many books to many authors, and one for linking many countries to many books.


linkTable Author-Book
idOfAuthor | idOfBook  
 1         | 1          

linkTable2 Book-Country
 idOfBook   | idOfCountry
 1          | 1