020 Homework Assignment IV ERD/RS/DD Submit Assignment essions Due Thursday by 5:59pm Points 100 Submitting a file upload Available Feb 20 at 5:59pm - Feb 27 at 5:59pm 7 days File Types pdf and sal Create: ales sh Connect S Tools Entity Attribute Relationship (EAR) Diagram Relational Scher a nslated using the Mapped or Stable method) Data Dictionary (use the student example from the website as a template) Sample Data ament Converter Please examine the following scenario- Business: Library The Library has Customers and Books. The Customers borrow and return books. The transaction has a due date. Each book has a loan period in days. For example, The Great Gatsby may have a 10 day loan period and War and Peace may only have a 5 day loan period. Your design show allow for any amount of days. Each book also has a different overdue rate per day. For example, The Great Gatsby's overdue rate may be $1.00 per day but War and Peace's rate is only 5.50. Your design should allow for any amount. Keep in mind that when a customer is processed the Librarian needs to know what books they have outstanding and what, if any, fines they owe. They will also have to check out and return books. There is no need to track any history of transactions once a book is returned. The fines are calculated when the book is returned You are to create an Entity Attribute Relationship Diagram, Relational Schema, the Database Dictionary and Sample Data to represent the conceptual model of a database that could connect the transactions in this scenario. If possible please use MS Visio to create your diagram. If you don't have access to Visio your diagram can be done in Word. wpe here to search 020 Homework Assignment IV ERD/RS/DD Submit Assignment essions Due Thursday by 5:59pm Points 100 Submitting a file upload Available Feb 20 at 5:59pm - Feb 27 at 5:59pm 7 days File Types pdf and sal Create: ales sh Connect S Tools Entity Attribute Relationship (EAR) Diagram Relational Scher a nslated using the Mapped or Stable method) Data Dictionary (use the student example from the website as a template) Sample Data ament Converter Please examine the following scenario- Business: Library The Library has Customers and Books. The Customers borrow and return books. The transaction has a due date. Each book has a loan period in days. For example, The Great Gatsby may have a 10 day loan period and War and Peace may only have a 5 day loan period. Your design show allow for any amount of days. Each book also has a different overdue rate per day. For example, The Great Gatsby's overdue rate may be $1.00 per day but War and Peace's rate is only 5.50. Your design should allow for any amount. Keep in mind that when a customer is processed the Librarian needs to know what books they have outstanding and what, if any, fines they owe. They will also have to check out and return books. There is no need to track any history of transactions once a book is returned. The fines are calculated when the book is returned You are to create an Entity Attribute Relationship Diagram, Relational Schema, the Database Dictionary and Sample Data to represent the conceptual model of a database that could connect the transactions in this scenario. If possible please use MS Visio to create your diagram. If you don't have access to Visio your diagram can be done in Word. wpe here to search