$(15$ points$)$ Book publisher system. Draw an ER diagram for the following case. The E$-$R diagram should include entities, attributes, identifiers, and relationships. In the diagram, place a textbox at the top$-$left corner of your diagram and type Made by FirstName LastName in the textbox $(5$ points$).$

A book is identified by its ISBN number, and it has a title, a price, and a date of publication. A book is published by a publisher, which has its own publisher ID number and a name. Each book has only one publisher, but one publisher typically publishes multiple books over time.

A book is written by one or multiple authors. Each author is identified by an author number ano$$ has a name and date of birth. Each author has either one or multiple books. A book may have several authors.

Additional information is needed regarding the relationship between a book and its authors. An author may have different royalty rates for different books that he$/$she wrote. Also keep in mind that a book may have several authors $($hence several royalty rates$).$

Answer:

$[$Paste the diagram here.$]$