Quiz on ER and EER Model Constructs

What is the first step in the ER-to-Relational Mapping Algorithm?

• Mapping of Weak Entity Types

• Mapping of Regular Entity Types

• Mapping of Binary M:N Relationship Types

• Mapping of Multivalued attributes

Which step involves mapping Binary 1:N Relationship Types?

• Step 6

• Step 5

• Step 4

• Step 3

What is the purpose of Option 8A in mapping?

• Create a relation for each subclass only

• Create a relation for the super class and subclasses

• Create a single relation with multiple type attributes

• Create a single relation with one type attribute

Which option works only for total specializations?

• Option 8D

• Option 8C

• Option 8B

• Option 8A

What does Option 8C require for its implementation?

• Partial specialization

• Total specialization

• Overlapping specialization

• Disjoint specialization

In which scenario is a surrogate key recommended?

• When superclasses have the same key

• When superclasses have different keys

• When mapping weak entities

• When mapping multivalued attributes

What is a characteristic of a shared subclass?

• It can have different key attributes

• It must have the same key attribute across superclasses

• It is always modeled as a category

• It cannot be a subclass of multiple classes

Which option is used for overlapping subclasses?

• Option 8B

• Option 8C

• Option 8D

• Option 8A

What does the Type attribute in Option 8C indicate?

• The attributes of the superclass

• The subclass to which the row belongs

• The primary key of the superclass

• The foreign key of the subclass

What happens if an entity does not belong to any subclass in Option 8C?

• It is represented with NULL values

• It is included in the superclass relation

• It is automatically assigned to a subclass

• It is lost in the mapping