ISBN Example ERD Problem Entity Relationship Diagramming is a "top down" user process. Take the following user provided information and draw the appropriate ERD. Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conicts. Label an identier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identier and another attribute that makes sense. Please use a drawing tool of some type to show the ERD diagram (Word, PowerPoint, and Visio all work well). I want you to get in the habit of drawing these with a computer instead of by hand, as this will be important as we get to more difcult examples. You may use either the ER-Model or Crow's foot model, though answers will be provided in the Crow's foot by the instructor. Make sure you show entities, relationships, cardinality, and optionality. ISBN Example Information needs to be stored about books. Each book is uniquely identied by its ISBN. Other information about a book includes its title and publication date. In addition, to book information, there is also information stored about the book's publisher. This includes a unique publisher identier, publisher name, and publisher address. A book can only be published by a single publisher. Information on the authors of a book is also stored. This information includes the author's social security number, name, and address. Any single book can be written by either a single author or several authors. When the book is printed, it is sent to a printer. Information about the printer includes a unique printer identier, printer name, and address. A contract is written that indicates the number 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