Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions