Question $5$

Using the following description, construct an ER diagram.

Information needs to be stored about books. Its ISBN $($International Standard Book Num$-$

ber$)$ uniquely identifies each book. Other information about a book includes its title and publica$-$

tion date. In addition to book information, there is also information stored about the book's pub$-$

lisher. This includes a unique publisher identitier, publisher name, and publisher address. A sin$-$

gle publisher can only publish a book.

Information on the authors of a book is also stored. This information includes the author's

social security number, name, and address. Either a single author or several authors can write any

single book.

When the book is printed, it is sent to a printer. Information about the printer includes a

unique printer identifier, printer name, and address. A contract is written that indicates the num$-$

ber of books the printer will print and the printing deadline the printer needs to meet. At times, a

single book might be contracted to several printers if the quantity required to be printed exceeds

the printer's production capacity.