The requirements for completing the ERD problems are: 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 discussed in class (gradings for this part are based on whether you have used all the applicable conversion rules, and used them correctly)

Problem 1 (3 points): Please use the description below to prepare ERD. Note that the above purple colored requirements 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.

Problem 2 (3 points)

Draw an E-R diagram for the following situation: Shi- nyShoesForAll (5513A) is a small shoe repair shop located in a suburban town in the Boston area. SSFA repairs shoes. bags, wallets, luggage, and other similar items. Its customers are individuals and small businesses. The store wants to track the categories to which a customer belongs. SSFA also needs each customer's name and phone number. A job at SSFA is initiated when a customer brings an item or a set of items to be repaired to the shop. At that time. an SSFA employee evaluates the condition of the items to be repaired and gives a separate esti- mate of the repair cost for each item. The employee also estimates the completion date for the entire job. Each of the items to be repaired will be classified into one of many item types {such as shoes, luggage, etc}; it should be possible and easy to create new item types even before any item is assigned to a type and to remember previous item types when no item in the database is currently of that type. At the time when a repair job is completed, the system should allow the completion date to be recorded as well as the date when the order is picked up. If a customer has comments regarding the job, it should be possible to capture them in the system