Design a database to keep track of information for an art museum. Assume that the following requirements were collected.
? The museum has a collection of ART_OBJECTS. Each art object has a unique IDNo, and Artist, if known, a Year (When created, if known) a Title and a Description. The art objects are categorized in several ways, as discussed below.
? ART_OBJECTS are categorized based on types. There are three main types, Painting, Sculpture and Statue, plus an Other category for those that don't fit into one of the categories above.
? A PAINTING has a PaintType (oil, watercolour, etc) a material on which it is drawn (paper, canvas, wood) and Style (modern, abstract, etc)
? A SCULPTURE or a STATUE has a Material from which it was created (wood, stone, etc), Height, Weight and Style.
? An art object in the OTHER category has a Type(print, photo, etc) and Style.
? ART_OBJECTS are also categorized as PERMANENT_COLLECTION, which are owned by the museum (these have information on the DateAcquired, whether it is on display or stored and Cost) or BORROWED which has information on the Collection (where it was borrowed from), Date Borrowed, and Date Returned.
? ART_OBJECTS also have information describing their country/culture using information on country/culture of Origin (Italian, Egyptian, American, Indian, etc) and Period (Renaissance, Modern, Ancient)
? The museum keeps track of Artist's information, if known: Name, DateBorn, DateDied, CountryOfOrigin, Period, MainStyle and Description. The name is assumed unique.
? Different EXHIBITIONS occur, each having a Name, StartDate and EndDate. EXHIBITIONS are related to all the art objects that were on display during the exhibition.
? Information is kept on other COLLECTIONS with which the museum interacts, including Name (unique), Type (museum, personnel, etc), Description, Address, Phone and ContactPerson.
Draw an EER schema for this application. Record any assumptions you make.