1, Prepare an ERD by using draw.io. Hand-drawn diagrams will not be accepted as a valid submission.

2, The ERD must have all the maximum and minimum cardinalities identified. State any assumptions if necessary.

3, The ERD must be converted to a list of tables (schema) by using the 4 conversion rules

Please use the description below to prepare an ER diagram. Note that the above purple coloredrequirements apply.

You are newly hired by a bookstore. You are now asked to design a database to make the inventory of books organized. Your first job is the prepare a ER Diagram. The following is the info you need.

A book is identified by its ISBN number, and it has a title, a price, and a data of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.

A book is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books; in addition, occasionally data are needed regarding prospective authors who have not yet published any books.

In the context specified above, better information is needed regarding the relationship between a book and its authors. Specifically, it is importantly to record the percentage of the royalties that belongs to a specific author.

A book can be part of a series, which is also identified as a book and has its own ISBN number. One book can belong to several sets, and a set consists of at least one but potentially many books.