Marketing

1. Imagine you are designing a simple database for a local neighborhood library. The following business rules apply for checking out a book.

a. Each check out transaction should be attributed to a customer, who is a registered member of the library. Any new customer must be registered first.

b. A customer can check out multiple books in a single transaction

c. A library employee must check out each book

d. The due dates vary by book and transaction

e. The title and author of each borrowed book should be recorded

f. There are multiple copies of certain books, but customer can only borrow one copy of the book

g. Any other assumptions that seem appropriate

Based on these business rules, showing all resulting tables with their attributes and the relationships between these tables. Make sure your output is in a normalized form