Question

ER diagram

Although you always wanted to be an artist, you ended up beingan expert on databases because you love to cook data and yousomehow confused database with databaste. Your old love is stillthere, however, so you set up a database company, ArtBase, thatbuilds a product for art galleries. The core of this product isadatabase with a schema that captures all the information thatgalleries need to maintain. Galleries keep information aboutartists, their names (which are unique),birthplaces, age, andstyle of art (e.g., painting, lithograph, sculpture, photograph),and its price must be stored. Pieces of artwork are also classifiedintogroups of various kinds, for example, portraits, still lifes,works by Picasso, or works of the 19th century; a given piece maybelong to more than one group. Eachgroup is identified by a name(like those just given) that describes the group. Finally,galleries keep information about customers. For each customer,galleries keepthat person's unique name, address, total amount ofdollars spent in the gallery (very important!), and the artists andgroups of art that the customer tends tolike.Draw the ER diagram for the database

Solutions

Expert Solution
No answers


Submit Your Answer