ENHANCED ENTITY RELATIONSHIP DIAGRAM

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.