Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I don't need 3.2 since I already asked it, but 3.3 involves 3.2 so I included it in the screenshot. 3.2 A private book collector

I don't need 3.2 since I already asked it, but 3.3 involves 3.2 so I included it in the screenshot.

image text in transcribed

3.2 A private book collector is designing a database to keep track of her purchase and book holdings. Consider the entity set Book with attributes title, author, publisher, pukRate. numberRages, condition, cost, and datepurchases. (33 pts) a. Show how the entity set and its attributes would be represented on an E-R diagram. You can create this diagram by using a drawing tool at: www.draw.io b. Describe the domain of the cost attribute, making assumptions as needed c. Identify a superkey for the Book entity set d. Identify all candidate keys for the entity set e. Identify a primary key for the entity set and underline it on the E-R diagram 3.3(34 pts) a. Assume in the same enterprise as in Exercise 3.2, that there is an entity set called Purchase with attributes purchasedate, totalimount, and any others you wish to add to describe book purchases. A purchase may include several books. Show how this entity set and its relationship to Book would be represented on the E-R diagram. b. Stating any necessary assumptions, make a decision about the cardinality and participation constraints of the relationship, and add appropriate symbols to the E-R diagram. c. Assume there is another entity called seller to be added to the diagram. The book collector makes purchases from many sellers, but each purchases is made from one seller. Making up attributes as needed, add this entity and appropriate relationship(s) to the diagram

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

More Books

Students also viewed these Databases questions