Question: Problem 2 Create an ERD of the gallery's database. Galleries keep information about artists who has at least one artwork, their names (which are unique),

Problem 2 Create an ERD of the gallery's
Problem 2 Create an ERD of the gallery's database. Galleries keep information about artists who has at least one artwork, their names (which are unique), birthplaces, age, and style of art. Each piece of artwork that can be made by one or many artists has the information about its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. All pieces of artwork are also classified into groups of various kinds (e.g., portraits, still lives, works by Picasso, or works of the 19th century); a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that a customer's unique ID, name, address, and total amount of dollars spent in the gallery. Each customer has the list of artists and groups of art that the customer may prefer, if any

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 General Management Questions!