Question: Draw an E - R diagram for the scenario below. City Art Gallery deals in contemporary and classic art pieces, including paintings, sculptures, and installations.

Draw an E-R diagram for the scenario below.
City Art Gallery deals in contemporary and classic art pieces, including paintings, sculptures, and installations. Each art piece is uniquely identified by an art number and includes a detailed description, listed price, artist name, and provenance. The gallery collaborates with numerous patrons, who may be artists selling their work through the gallery, collectors buying artwork, or individuals who both buy and sell. Each patron is identified by a patron number and has associated details like name and address. When City Art Gallery sells an artwork to a patron, they want to record the commission amount, actual selling price, sales tax applicable, and the date of sale. When an artwork is purchased from a patron, the gallery records the purchase price, the date of acquisition, and the condition of the artwork upon arrival.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!