The requirements for completing the ERD problems are: 1, Prepare an…
Question The requirements for completing the ERD problems are: 1, Prepare an… 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) Image transcription textDraw an E-R diagram for the following situation: Shi- nyShoesForAll (5513A) is a small shoe repair shop locatedin a suburban town in the Boston area. SSFA repairs shoes. bags, wallets, luggage, and other similar items. Itscustomers are individuals and small businesses. The store wants to track the categories to which… Show more… Show more MAKE SURE TO SHOW THE MAX AND MIN CARDINALITIES FOR EACH ERD AND MAKE SURE YOU PUT THE SCHEMA!!! Accounting Business Managerial Accounting ACC 4160 Share QuestionEmailCopy link Comments (0)
