In a library system , the relationship between Book and Author is M:N. Which of the following is true for the relational schema?

Question

In a  library system , the relationship between  Book  and  Author  is M:N. Which of the following is true for the relational schema?

Accepted Answer

Create a BookAuthor table with FKs to both

Answer

Author table must contain book IDs

Answer

Store author names in a multivalued attribute in Book

Answer

Book table must contain author IDs

Crowdly