ENHANCED ENTITY RELATIONSHIP DIAGRAM

$2.$ 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, 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 PaintType $($oil$,$ watercolour,etc.$),$ material on which it is DrawnOn $($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 Style.

$-$ An art object in the OTHER category has a Type$($print$,$ photo,etc$)$ and Style.

$-$ ART$\_$OBJECTS are also categorized as PERMANENET$\_$COLLECTION, which are owned by the museum $($these have information on the DateAcquired, whether it is OnDisplay or stored, and Cost$)$ or BORROWED, which has information on the Collection$($from which it was borrowed$),$ DateBorrowed and DateReturned.

$-$ The museum keeps track of ARTIST'S information, if known: Name, DateBorn$($if known$),$ DateDied$($if not living$),$ CountryOfOrigin, Epoch, MainStyle, and Description. The Name is assumed to be unique.

Draw an EER schema diagram for this application. Discuss any assumptions made.

$-$ Show and Specify the relationship types and constraints on each participation of an entity in a relationship type.

$-$ Show the attributes of each entity underlining the primary key in each entity.