Answered step by step
Verified Expert Solution
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 Customer Attributes: Customer ID Primary Key Full Name, Phone Number Sale Attributes: Sale Date Relationships: Customer Participation: Total, Cardinality: Book Participation: Partial, Cardinality: or many Publisher Attributes: Publisher ID Primary Key Name Relationships: Book Participation: Partial, Cardinality: or many Location Attributes: Location ID Primary Key Location Name Associations: CustomerBuysBook Relationship: Customer Sale Book or many BookPublishedByPublisher Relationship: Book Publisher or PublisherHasLocation Relationship: Publisher Location Location or many
Draw an ER diagram
Entities:
Book
Attributes: ISBN Primary Key
Name, Copies Sold, Publication Year
Customer
Attributes: Customer ID
Primary Key Full Name, Phone
Number
Sale
Attributes: Sale Date
Relationships:
Customer Participation: Total,
Cardinality:
Book Participation: Partial,
Cardinality: or many
Publisher
Attributes: Publisher ID
Primary Key Name
Relationships:
Book Participation: Partial,
Cardinality: or many
Location
Attributes: Location ID
Primary Key Location Name
Associations:
CustomerBuysBook
Relationship: Customer
Sale Book or many
BookPublishedByPublisher
Relationship: Book
Publisher or
PublisherHasLocation
Relationship: Publisher
Location Location or many
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started