Chapter 4: Problem 3
Discuss the mechanism of attribute/relationship inheritance. Why is it useful?
Short Answer
Step by step solution
Key Concepts
These are the key concepts you need to understand to accurately answer the question.
Chapter 4: Problem 3
Discuss the mechanism of attribute/relationship inheritance. Why is it useful?
These are the key concepts you need to understand to accurately answer the question.
All the tools & learning materials you need for study success - in one app.
Get started for freeWhat is the difference between specialization and generalization? Why do we not display this difference in schema diagrams?
Discuss user-defined and predicate-defined subclasses, and identify the differences between the two.
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.
Discuss the main differences between the notation for EER schema diagrams and UML class diagrams by comparing how common concepts are represented in each.
What is a subclass? When is a subclass needed in data modeling?
What do you think about this solution?
We value your feedback to improve our textbook solutions.