Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a private book collector is designing a database to keep track of her purchases and book holdings. Consider the entity set Book with attributes title,
a private book collector is designing a database to keep track of her purchases and book holdings. Consider the entity set Book with attributes title, author, publisher, pubDate, numberPages, condition, cost, and datePurchased. There is an entity set called Purchase with attributes purchaseDate, totalAmount. Create an ER diagram or UML to show how this entity set Purchase and its relationship to Book would be represented. Indicate primary keys. Stating any necessary assumptions, make a decision about the cardinality and participation constraints of the relationship, and add appropriate symbols to the ER diagramUML
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