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. \(A R T_{-} 0 B\) JECTS are categorized based on their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called ofHER 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_OBIECTS 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. \(A R T_{-} 0 B\) JECTS 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. ExHIBITIONS 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.Draw an EER schema diagram for this application. Discuss any assumptions you made, and that justify your EER design choices.

Step by step solution

01

Identifying the Entities

The entities are the main components in the database that have data stored about them. Identified entities from the text include: \'ART_OBJECT\', \'ARTIST\', \'EXHIBITION\', \'COLLECTION\'.

02

Identifying the Attributes

Each entity has different attributes, which represent the characteristics of the entity. For example, the ART_OBJECT entity would include attributes like IdNo, Artist, Year, Title, Description, etc. Similarly, other entities like ARTIST and EXHIBITION will have attributes like Name, DateBorn, DateDied, etc, and Name, StartDate, EndDate respectively.

03

Creating an E-R Diagram

Based on the entities and attributes, we can create an E-R Diagram. Create entities as rectangles, and connect them with lines depicting relationships. Attributes can be displayed as ovals connected to their respective entities. Distinguish between types of art objects (PAINTING, SCULPTURE, STATUE) by branching them off from the ART_OBJECT entity as subclasses.

04

Adding Relationships

The final step in creating the EER schema is to define the relationships between entities. For instance, an ART_OBJECT can be related to an EXHIBITION (as art objects are displayed in exhibitions). Similarly, an ARTIST is related to an ART_OBJECT (as artists create art objects). Depict the relationships on the E-R Diagram with relevant verbs.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!