(EER) Extended - Entity - Relationship

2) (35 points) Draw an EER diagram for the following application: to keep track of information for an art museum. Discuss any assumptions that you have made * The museum has a collection of ART_OBJECTS. Each ART OBJECT has a unique Id no, an Artist (if known), a Year (when it was 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 their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types A PAINTING has a Paint type (oil, watercolor, etc.), material on which it is Drawn on (paper, canvas, wood, etc.), and Style (modern, abstract, etc.) A SCULPTURE or a statue has a Material from which it was created (wood, stone, etc.), Height, Weight, and Stile. An art object in the OTHER category has a Type (print, photo, etc.) and Style. ART OBJECTs are categorized as either PERMANENT COLLECTION (objects that are owned by the museum) and BORROWED. Information captured about objects in the PERMANENT COLLECTION includes Date_acquired, Status (on display, on loan, or stored), and Cost. Information captured about BORROWED objects includes the Collection from which it was borrowed, Date borrowed, and Date returned. * * * * Information describing the country or culture of Origin (Italian, Egyptian, American, Indian, and so * The museum keeps track of ARTIST information, if known: Name, DateBorn (if known), Date died (if * Different EXHIBITIONS occur, each having a Name, Start date, and End date. EXHIBITIONS are . Information is kept on other COLLECTIONS with which the museum interacts, including Name forth) and Epoch (Renaissance, modern, Ancient, and so forth) is captured for each ART OBJECT not living), Country_of origin, Epoch, Main style, and Description. The Name is assumed to be unique. related to all the art objects that were on display during the exhibition. (unique), Type (museum, personal, etc.), Description, Address, Phone, and Current Contact _person