E-R Diagram

Although you always wanted to be an artist, you ended up being an expert on databases because you love to cook data and you somehow confused database with data baste. Your old love is still there, however, so you set up a database company, ArtBase, that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain.

Galleries keep information about artists, including their ID (which are unique), names, birthplaces, age, and style of art. Galleries also keep information about artworks. For each piece of artwork, their ID (which are unique), the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Finally, galleries keep information about customers. For each customer, galleries keep that person's unique ID, name, address, and total amount of dollars spent in the gallery (very important!).

Each artist may paint many artworks. An artwork is always painted by one artist. A customer may purchase several artworks and an artwork is sold to one customer. Draw the ER diagram for the database. Please clearly state your assumption if you don't have sufficient information.