1. Use Lucidchart as demonstrated in class to draw ER diagram. 2. Note that some business descriptions may not be captured in the model. 3. Draw entities with names, attributes, and primary keys using 90-degree corner rectangles. 4. Draw relationships with names, degrees, and structure constraints (i.e. cardinalities) using lines, and possible attributes in 90-degree corner rectangles. 5. Add a caption to name your final drawing, including your full name. Example: Publisher Ms. Contract would like you to design a conceptual model for her organization using the entityrelationship model. She represents authors and publishing companies and helps them draw up contracts. Each book is described by a unique ISBN, year of publication, sales price, and number of pages. Each author is described by a unique phone number and name (consists of first and last name). Because there can possibly be multiple authors for a book, this relationship is described by an attribute role; values are writer, illustrator, editor, translator, etc. Ms. Contract maintains author information even if they have not written any book as yet. Each publishing company is identified by a unique name, and one or two phone numbers. Each book must be under review by at least one publishing company, and this relationship is described by an expiration date. There are several editors who work for each publisher, but each editor only works for one publisher. Editors are not independent of publishers, therefore, each editor is identified by a combination of an editor name and the publisher name. Each editor should provide a phone number. Number of editors should be available. For each book that is finally completed by a review to be published by a publisher, there is a single author, who signs a contract for that book with a contract date. 1. Use Lucidchart as demonstrated in class to draw ER diagram. 2. Note that some business descriptions may not be captured in the model. 3. Draw entities with names, attributes, and primary keys using 90-degree corner rectangles. 4. Draw relationships with names, degrees, and structure constraints (i.e. cardinalities) using lines, and possible attributes in 90-degree corner rectangles. 5. Add a caption to name your final drawing, including your full name. Example: Publisher Ms. Contract would like you to design a conceptual model for her organization using the entityrelationship model. She represents authors and publishing companies and helps them draw up contracts. Each book is described by a unique ISBN, year of publication, sales price, and number of pages. Each author is described by a unique phone number and name (consists of first and last name). Because there can possibly be multiple authors for a book, this relationship is described by an attribute role; values are writer, illustrator, editor, translator, etc. Ms. Contract maintains author information even if they have not written any book as yet. Each publishing company is identified by a unique name, and one or two phone numbers. Each book must be under review by at least one publishing company, and this relationship is described by an expiration date. There are several editors who work for each publisher, but each editor only works for one publisher. Editors are not independent of publishers, therefore, each editor is identified by a combination of an editor name and the publisher name. Each editor should provide a phone number. Number of editors should be available. For each book that is finally completed by a review to be published by a publisher, there is a single author, who signs a contract for that book with a contract date