Quiz on Enhanced Entity Relationship (EER) Model

What does the EER model include in addition to the ER model?

• Only category or union type

• Only specialization and generalization

• Subclass, superclass, specialization, generalization, and inheritance

• Only subclass and superclass

What is specialization in the context of the EER model?

• The process of merging subclasses into a superclass

• The process of defining relationships between entities

• The process of defining a set of subclasses based on distinguishing characteristics

• The process of creating a union type

Which of the following is an example of a subclass of the EMPLOYEE entity type?

• PERSON

• EMPLOYEE

• WORKER

• MANAGER

What does the disjointness constraint specify?

• Subclasses must be disjoint sets

• Subclasses can share attributes

• Subclasses must be overlapping

• Subclasses can have multiple parents

What is a total specialization constraint?

• Every entity in the superclass must belong to at least one subclass

• Some entities in the superclass may not belong to any subclass

• All subclasses must be disjoint

• Subclasses can overlap

In the context of EER, what is generalization?

• The process of defining relationships between different superclasses

• The process of creating subclasses from a superclass

• The process of merging multiple entities into one

• The process of defining a superclass from subclasses

What is a predicate-defined subclass?

• A subclass defined by user input

• A subclass defined by a condition on an attribute of the superclass

• A subclass that has no conditions for membership

• A subclass that can have multiple parents

Which of the following is NOT a type of specialization constraint?

• Disjoint, complete

• Disjoint, total

• Overlapping, partial

• Overlapping, total

What does the UML notation for specialization/generalization use to represent relationships?

• Circles and squares

• Vertical and horizontal lines with triangles

• Only horizontal lines

• Only vertical lines

In the EER model, what is a category?

• A type of superclass

• A union type that includes entities from multiple superclasses

• A subclass with no attributes

• A type of relationship