Exercise

Design an ER diagram for a website that sells book $-$use structural constraints $($min$,$ max$)$ and participation constraints $($total or partial$).$

Website has information about the books such as the name of the book, the ISBN of the book, number of copies sold, and the publication year.

The website also save the information about the customers who have bought books from the website. The information include: the full name, an ID for the customer, and the phone number

Each time a customer buys a book, the date of the sale is saved.

The website now wants to save the information about the publishers.

The publishers information are: name, unique id$,$ location $($can be more than one$).$

A publisher can publish zero or more books but each book can be published by one and only one publisher.