Question: please solve with explaining. You have been tasked with modeling the book industry. Draw an ER diagram to model the following: books have a title,
please solve with explaining.

You have been tasked with modeling the book industry. Draw an ER diagram to model the following: books have a title, ISBN number (which is unique for each book), and subject. Books usually cite other books (i.e., references). In addition, each book must have at least one author, who has a Social Security number (unique for each individual), name, and a phone number. We would like to keep track of bookstores, who sell books, and have a store id, address, and name. Your solution should show the entities and their attributes, keys and foreign keys, and cardinality. You will need also to identify weak entities (if any) using the appropriate mechanism depending on which notation you select
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
