Design an E-R Diagram for an Art Gallery. Gallery keeps information about:

Artist their Name(unique), Phone, Address, Birth place, Age & Style of Art,

Art Work, Artist, the year it was made, Unique title, Type of art & Prices

Customer, Customer Number, Phone Art preferences

Work of Art, type, artist, date of creation if known (can be NULL), date acquired by gallery, location (Blue Room, Front Room, Basement, etc.)

Types include

Surrealism. ...

Conceptual Art. ...

Pop Art. ...

Photorealism. ...

Hyperrealism. ...

Minimalism. ...

Religious

Works of 19th century

Still Life

Pottery

Sculpture

Note* ER must be done with Microsoft Visio.

Thanks