WorksheetsPractice Exam: Enhanced Entity-Relationship (EER) Model
Total questions: 51
Worksheet time: 26mins
What is the primary purpose of the Enhanced Entity-Relationship (EER) model?
To replace the traditional E-R model
To extend the E-R model with additional modeling constructs
To simplify database design by removing relationships
To enforce strict one-to-one relationships in all cases
Which of the following best describes a supertype in the EER model?
A generic entity type with common attributes shared by its subtypes
A subgrouping of entities with distinct attributes
A relationship between two entities
A constraint that ensures uniqueness in a database
In the context of supertype/subtype relationships, attribute inheritance means:
Subtypes do not inherit any attributes from the supertype
Subtypes inherit all attributes and relationships from the supertype
Only unique attributes are inherited by the subtypes
Each subtype must have completely different attributes from the supertype
What symbol represents a Total Specialization constraint in an EER diagram?
A single line
A dashed line
A double line
A diamond shape
If an instance of a supertype must be a member of at least one subtype, which rule applies?
Partial Specialization Rule
Total Specialization Rule
Disjoint Rule
Overlap Rule
Specialization is the process of:
Combining multiple entities into one supertype
Dividing an entity into multiple subtypes
Ensuring that an entity belongs to a subtype
Eliminating redundancy in a database
A supertype/subtype hierarchy is used when:
All attributes are unique to individual entities
An entity has multiple categories with shared and unique attributes
Every entity is independent and has no common attributes
All relationships must be one-to-one
The disjoint rule ensures that:
An instance of a supertype can belong to multiple subtypes
An instance of a supertype can only belong to one subtype
A supertype must always have multiple subtypes
The supertype can exist without any subtypes
A subtype discriminator is:
A unique identifier for each subtype
An attribute that determines which subtype an entity belongs to
A relationship between subtypes
A rule that forces specialization
Overlapping subtypes occur when:
An instance of a supertype can belong to multiple subtypes
An instance of a supertype must belong to only one subtype
A supertype has no attributes
Subtypes are unrelated to each other
What does a single line between a supertype and the circle in an EER diagram indicate?
Total specialization
Partial specialization
Disjoint constraints
Overlapping constraints
Which of the following is an example of generalization?
Creating an EMPLOYEE supertype from the entities MANAGER and ENGINEER
Dividing VEHICLE into subtypes CAR and TRUCK
Assigning unique attributes to each instance of an entity
Ensuring that an entity belongs to a subtype
Which of the following is not an advantage of using supertype/subtype relationships?
Reducing redundancy in data models
Allowing for more specific entity attributes
Simplifying complex database relationships
Eliminating the need for primary keys
Which of the following is an example of partial specialization?
Every instance of EMPLOYEE must be classified as either MANAGER or ENGINEER
Some instances of VEHICLE do not belong to any subtype
Every instance of VEHICLE must be either a CAR or a TRUCK
A supertype instance belongs to multiple subtypes
If a subtype has a composite subtype discriminator, it means:
The supertype has only one subtype
The discriminator has multiple attributes for different subtypes
Each subtype is independent from the supertype
Every subtype has the same attributes
Which constraint allows an entity to exist at the supertype level without being a subtype?
Total Specialization
Partial Specialization
Disjoint Rule
Attribute Inheritance
What does a double line from a supertype to a circle represent?
Total Specialization
Disjoint Rule
Overlapping Subtypes
Partial Specialization
What type of attribute is used to determine the subtype for an entity?
Foreign Key
Subtype Discriminator
Primary Key
Derived Attribute
Which scenario would require overlapping subtypes?
A database of books classified as Fiction or Non-Fiction
A student who can be both an athlete and a scholar
A vehicle that is either a car or a truck, but not both
A hospital where each patient must be an outpatient or inpatient
In an EER diagram, what does the letter "d" inside a circle indicate?
Disjoint rule
Overlap rule
Derived attribute
Double specialization
The "o" in an EER diagram signifies:
Overlapping subtypes
Disjoint subtypes
Optional attributes
Outdated entity types
What is the root in a supertype/subtype hierarchy?
The most specialized subtype
The entity with no attributes
The top-most supertype
The least important entity
What kind of relationship exists between a supertype and its subtypes?
Many-to-many
One-to-many
One-to-one
Many-to-one
In an employee database, which of the following would best represent an example of an EER model?
A single EMPLOYEE entity with all attributes
EMPLOYEE as a supertype with subtypes MANAGER and INTERN
Separate MANAGER and INTERN entities with duplicate attributes
A table without any hierarchical relationships
When should you use a supertype/subtype relationship in database modeling?
When all entities share the exact same attributes
When there are distinct categories of an entity with some shared attributes
When all attributes are unique to each entity
When multiple entities have no relationships
What type of specialization occurs when an instance of a supertype must belong to at least one subtype?
Partial specialization
Total specialization
Disjoint specialization
Composite specialization
If a supertype/subtype relationship has overlapping subtypes, how should its subtype discriminator be structured?
A single attribute with multiple values
A composite attribute with Boolean values for each subtype
A derived attribute from another entity
A primary key shared across all entities
In a supertype/subtype hierarchy, what ensures that all instances of a supertype fit into at least one subtype?
Disjoint rule
Overlap rule
Total specialization
Partial specialization
Which specialization rule allows an entity to belong to multiple subtypes?
Overlap rule
Overlapping rule
Total specialization
Partial specialization
In which scenario would a partial specialization rule be more appropriate?
Every EMPLOYEE must be classified as either a MANAGER or an ENGINEER
A VEHICLE entity where some vehicles are neither a CAR nor a TRUCK
A STUDENT entity where each student must be an UNDERGRADUATE or GRADUATE
A COMPANY entity where every company must be a startup or a corporation
How is a subtype discriminator typically represented in an EER diagram?
A dashed line connecting the supertype and subtype
A labeled attribute inside the supertype
A separate entity linking all subtypes
A unique identifier in the subtype
If a database model includes an EMPLOYEE supertype with subtypes MANAGER and ENGINEER, and each employee can only be one subtype, what constraint applies?
Overlap rule
Disjoint rule
Total specialization
Partial specialization
A hospital has a PATIENT supertype with OUTPATIENT and INPATIENT subtypes. If every patient must be one or the other, but not both, which constraints apply?
Total specialization and overlap rule
Partial specialization and disjoint rule
Total specialization and disjoint rule
Partial specialization and overlap rule
If a supertype/subtype hierarchy has multiple levels of subtypes, what is this structure called?
Disjoint model
Generalization pattern
Supertype nesting
Supertype/subtype hierarchy
A company database tracks employees, alumni, and students under a PERSON supertype. If a person can be both an ALUMNUS and a STUDENT, which rule applies?
Disjoint rule
Overlapping rule
Partial specialization
Total specialization
Which of the following best describes the purpose of generalization in an EER model?
It reduces redundancy by creating a higher-level entity that encompasses multiple lower-level entities
It breaks down a broad entity into more specific subtypes
It ensures that every instance of a supertype is assigned to a subtype
It prevents an entity from inheriting attributes from multiple sources
True or False: Generalization is the process of defining a more specific entity type from an existing supertype.
True
False
True or False: The Disjoint Rule allows an instance of a supertype to belong to multiple subtypes.
True
False
True or False: The Overlap Rule is indicated by the letter "d" in the circle connecting a supertype and its subtypes.
True
False
True or False: A subtype discriminator is used to determine which subtype an entity belongs to.
True
False
True or False: A supertype/subtype hierarchy can only have two levels.
True
False
True or False: The Partial Specialization Rule means that not all instances of a supertype must belong to a subtype.
True
False
True or False: Overlapping subtypes require the use of composite subtype discriminators.
True
False
True or False: In an EER diagram, a double line represents a partial specialization constraint.
True
False
True or False: A supertype may have multiple subtypes, but each subtype can only belong to one supertype.
True
False
True or False: The Overlap Rule allows an instance of a supertype to be a member of multiple subtypes.
True
False
Explain the difference between specialization and generalization in the EER model.
Specialization is the process of defining a set of subclasses of an entity type, while generalization is the process of defining a generalized entity type from a set of entity types.
Specialization is the process of defining a generalized entity type from a set of entity types, while generalization is the process of defining a set of subclasses of an entity type.
Specialization and generalization are the same processes in the EER model.
Specialization and generalization are unrelated concepts in the EER model.
Disjoint and overlapping constraints are types of constraints in database design. Which of the following is an example of a disjoint constraint?
A student can either be an undergraduate or a graduate, but not both.
A person can be both an employee and a manager.
A vehicle can be either a car or a truck, but not both.
A book can be both a hardcover and a paperback.
The Total Specialization Rule differs from the Partial Specialization Rule in that:
Total Specialization requires all instances of a superclass to be a member of at least one subclass, while Partial Specialization does not.
Partial Specialization requires all instances of a superclass to be a member of at least one subclass, while Total Specialization does not.
Both rules require all instances of a superclass to be a member of at least one subclass.
Neither rule requires instances of a superclass to be a member of any subclass.
A real-world scenario where a supertype/subtype relationship would be useful in database design is:
Managing different types of vehicles in a transportation database
Storing a single type of product in an inventory system
Tracking identical user profiles in a social media app
Recording uniform transactions in a banking system
In an EER diagram, a supertype/subtype relationship is typically represented by:
a rectangle with a line connecting to a circle
a triangle with lines connecting to rectangles
a diamond shape with lines connecting to circles
a circle with lines connecting to triangles
