A ____ occurs when you have one entity in two 1:M relationships to other entities,thus producing an association among the other entities that is not expressed in the model.
A) surrogate primary keys
B) time-variant data
C) design trap
D) fan trap

Question

Quizplus · Accepted Answer

This scenario is known as a fan trap, where the common entity acts as a hub connecting two or more 1:M relationships, causing an association among the other entities that is not explicitly represented in the model. This can lead to data inconsistencies and ambiguity. Surrogate primary keys and time-variant data are not relevant to this situation, and a design trap tends to refer to a wider range of modeling issues.

A ____ Occurs When You Have One Entity in Two