Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are going to set up a database company that builds a product for art galleries The core of this product is a database that

image text in transcribed

You are going to set up a database company that builds a product for art galleries The core of this product is a database that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, we need to record its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. An artist may paint many pieces of artwork and a piece of artwork is done by one artist. Pieces of artwork are also classified into groups of various kinds (for example, portraits, 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 that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person's unique name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

How are members held accountable for serving in the assigned roles?

Answered: 1 week ago