Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ER diagram Entities: Book Attributes: ISBN ( Primary Key ) , Name, Copies Sold, Publication Year 2 . Customer Attributes: Customer ID (

Draw an ER diagram
Entities:
Book
Attributes: ISBN (Primary Key),
Name, Copies Sold, Publication Year
2. Customer
Attributes: Customer ID
(Primary Key), Full Name, Phone
Number
Sale
Attributes: Sale Date
Relationships:
Customer (Participation: Total,
Cardinality: 1)
Book (Participation: Partial,
Cardinality: 1 or many)
4. Publisher
Attributes: Publisher ID
(Primary Key), Name
Relationships:
Book (Participation: Partial,
Cardinality: 0 or many)
5. Location
Attributes: Location ID
(Primary Key), Location Name
Associations:
Customer-Buys-Book
Relationship: Customer (1)-
Sale >- Book (1 or many)
2. Book-Published-By-Publisher
Relationship: Book (1)-
Publisher (0 or 1)
3. Publisher-Has-Location
Relationship: Publisher (1)-
Location >- Location (0 or many)
image text in transcribed

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

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions

Question

dy dx Find the derivative of the function y=(4x+3)5(2x+1)2.

Answered: 1 week ago

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago