ART  MUSEUM

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 id,an artist(if known),a year(when it was created,if known) and a title.

Art_objects are categorized based on their types.There are two main types:painting and sculpture.

Painting has a paint type and style.

Sculpture has a material from which it was created,height and weight.

Different exhibitions occur each having a name,start date and end date.Exhibitons  are related to all the art objects that were on display on display during the exhibition.

Draw an EER schema diagram for this application.

ANSWER:

Step 1:

Entities:

1.art_object

2.artist

3.painting

4.sculpture

5.exhibition

 

 

Key attributes:

1)Art_object: idno

2)Painting: painttype

3)Sculpture: material

4)Artist:Aname

5)Exhibition:Ename

 

Other attributes:

1)Art_object: year,title.

2)Painting: style.

3)Sculpture: height,weight.

4)Artist: country,mainstyle

5)Exhibition: sdate,edate.

 

 RELATIONSHIPS:

 

Image

 

ER DIAGRAM:

 

Image

 

 

Advertisements