Question: Draw the ER diagram for a local bookstore database based on the following information: 1. Each book has a title, abstract, and ISBN. The ISBN

 Draw the ER diagram for a local bookstore database based on

Draw the ER diagram for a local bookstore database based on the following information: 1. Each book has a title, abstract, and ISBN. The ISBN is unique to each book; 2. Some of these books are computer-science textbooks, in which case there is an additional piece of associated information the programming language used for instruction in the book 3. One book may cite other books, and may be cited by other books as well; 4. Each book is published by a publisher although such publisher information may not always be available in the database; 5. A publisher has a unique name, as well as a city and year of the establishment; 6. Each book is written by one or more authors. An author must have written at least one textbook to be included in the database; 7. An author has a name, an address and an SSN. The SSN is unique to each author. Remember to indicate the key for each entity, as well as the multiplicity of each relationship (e.g. one-to-many) and the referential integrity constraints, using the appropriate notation

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!