Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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),

image text in transcribed
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

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

An Environmental Audit Primer Student Guide

Authors: Velsoft Training Materials, Inc.

1st Edition

1774550393, 978-1774550397

More Books

Students also viewed these Accounting questions