We want to develop a database for an online bookstore.

Entities required: Book, Author, Publisher, Customer

Attributes required:

Book: ISBN, year, title, price $($ISBN is unique for each book$)$

Author: authorID, name, address $($authorID is unique for each author$)$

Publisher: name, address, phone $($name is unique for each publisher$)$

Customer: customerID, email, name, address, phone $($customerID is unique for each

customer$)$

The following relationships must be defined

Book is related to Author

Book is related to Publisher

Book is related to Customer

Connectivities and participation are defined as follows

An author may have written many books

A book may have multiple authors

A book has only one publisher

A publisher may have published many books

A customer may or may not have purchased a book

A customer may have purchased many books

A book may or may not be purchased by a customer

A book may be purchased by many customers

Draw an E$-$R diagram for this database using craw's foot notation. For each entity, clearly indicate entity name, attributes, PK$,$ and FK if any. Add linking entities as needed. For each relationship, clearly indicate strong$/$weak relationship and connectivity