Question

Create an ER diagram for the following database scenario. Include an indication of the cardinality of relationships and indicate any mandatory relationships. State any assumptions that you make!

Library Bookstore Database

• Book authors have names (real and nicknames sometimes).
• Book authors write books.
• Books have titles, the year they came out, a genre, a length, and a rating.
• A rating can be G, PG, PG-13, or R.
• Books are published by publishers.
• There are various different publishers around the world.
• Book publishers hire authors to write books and pay them a salary

Then, Convert the above ER digram to a table

Answer 1

ER diagram designed in Crow' foot model of my choice as the question did not specify which model needed

ERD converted to tables using SQL DDL statements using SQL Server of my choice as question did not specify which DBMS platform to use .Please find the screenshots of the SQL code below. For tables names , tbl_<table Name> is used for naming conventions .