1.b [2 points). Create an Entity Relation Diagram (conceptual model) The entity is a Book. The bike has the following attributes: 1. Title 2. Genre 3. Year 4. ISBN 5. Retail Price 1.c. [5 points] Create an Entity Relation Diagram. Redraw the entities author and book. Relate them with a 1 to many relationship. One author can write many books. Many books can be written by one author. 1.d [6 points). Using the conceptual model in problem 3, now draw the logical model. Remember to do the following: a) Add primary keys where needed and underline them. b) Add foreign key where needed. c) Replace any compound attribute with two or more simple attributes. d) Replace any M:M relationship with two 1:M relationships and a new entity. 2 [10 points]. Given your Logical Model in problem 3.d., implement the two tables in Access and create the relationship between the two tables that were implemented. You do not need to add records to the tables