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.

 please solve with explaining. You have been tasked with modeling the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!