FACULTY OF COMPUTER SCIENCE AND INFORMATION TECHNOLOGY
DEPARTMENT OF COMPUTER SCIENCE
SSK4401 DATABASE SYSTEMS
CHAPTER 2: MODELING USING THE CONCEPTS OF DATA MODEL
INDIVIDUAL ASSIGNMENT 1
Learning Outcome:
CPS7 (5%) CPS1 (5%)
Student Learning Time:
The estimated time to complete this task is 10 hours.
1. Assume that the following requirements were collected. Draw an EER diagram for an art museum.
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, watercolor, 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 PERMANENT_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.
ART_OBJECTS also have information describing their country/culture using information on country/culture of Origin (Italian, Egyptian, American, Indian, etc.) and Epoch (Renaissance, Modern, Ancient, etc.).
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.
Different EXHIBITIONS occur, each having a Name, StartDate, and EndDate. EXIBITIONS 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, personal, etc.), Description, Address, Phone, and current ContactPerson.
2. Discuss any assumptions you made with regards to the specialization/generalization concepts used in your solution. Choose one entity to explain the difference between the design of a relation using an ER against an EER diagram.