Question: Draw the ER diagram for a local bookstore database based on the following information: 1 . Each book has a title, abstract , and ISBN.
Draw the ER diagram for a local bookstore database based on the following information: Each book has a title, abstract and ISBN. The ISBN is unique to each book; Some of these books are computerscience textbooks, in which case there is an additional piece of associated information the programming language used for instruction in the book One book may cite other books, and may be cited by other books as well; Each book is published by a publisher although such publisher information may not always be available in the database; A publisher has a unique name, as well as a city and year of the establishment; Each book is written by one or more authors. An author must have written at least one textbook to be included in the database; 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 eg onetomany 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
