Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
Large ERDs quickly become difficult to read. To improve comprehension, modelers use “entity clusters,” which aggregate related entities and their relationships into a single visual unit on a diagram. This question checks the correct definition of an entity cluster.
Given Data / Assumptions:
Concept / Approach:
An entity cluster is precisely a set of one or more entity types and their relationships grouped for readability. It does not change keys, cardinalities, or normalization; it merely replaces a group of boxes and lines with a single cluster icon on that view. Analysts can drill into the cluster to see the underlying detailed entities when needed.
Step-by-Step Solution:
Verification / Alternative check:
Compare the diagram before and after clustering; the number of shapes is reduced, but the underlying repository still lists all original entities and relationships unchanged.
Why Other Options Are Wrong:
Common Pitfalls:
Misusing clusters as a replacement for proper normalization, or hiding critical relationships that stakeholders need to review. Ensure clusters are used to enhance, not obscure, understanding.
Final Answer:
Correct
Discussion & Comments