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 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
Get step-by-step solutions from verified subject matter experts
