why do we make tables like 'Book_to_Author' instead of just adding authorID to the author field in the Book table?
Printable View
why do we make tables like 'Book_to_Author' instead of just adding authorID to the author field in the Book table?
You make tables like that when the join is many-to-many.
In the case of a "'Book_to_Author" table, that would be because an Author can write many books, and a single book can be written by more than one person.
Ah that's it I remember now :D Thanks a lot!