Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ABC Gallery keeps information about artists, their names ( which are unique ) , birthplaces, age, and style of art. For each piece of artwork,

ABC Gallery keeps information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored.o Each artwork has been made by one artist. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. (i.e., GROUP:ARTWORK = M:N)o Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers and their preferences.o For each customer, galleries keep that persons unique id, name, address, total amount of dollars spent in the gallery (very important!), and the artists that the customer tends to like (i.e., CUSTOMER:ARTIST = M:N)

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_2

Step: 3

blur-text-image_3

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

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions