The ERD must be converted to a list of tables (schema) by using the 4 conversion rules discussed in class (gradings for this part are based on whether you have used all the applicable conversion rules, and used them correctly)

Please use the description below to prepare a schema.

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.