Describe how fan and chasm traps can occur in an ER model and how they can be resolved.
What will be an ideal response?
A fan trap occurs where a model represents a relationship between two entity types, but the
pathway between certain entity occurrences is ambiguous. Resolve the fan trap by
restructuring the original ER diagram to represent the correct association between these entities
A chasm trap occurs where a model suggests the existence of a relationship between entity
types, but the pathway does not exist between certain entity occurrences. A chasm trap may
occur where there are one or more relationships with optional participation. Resolve the chasm
trap by identifying the missing relationship
You might also like to view...
Which of the following is not a Flash BIOS recovery method?
A) Recovery utility B) Recovery jumper C) Secondary BIOS D) Tape backup
Suppose list is a LinkedList that contains 1 million int values. Analyze the following code:
``` A: for (int i = 0; i < list.size(); i++) sum += list.get(i); B: for (int i: list) sum += i; ``` a. Code fragment A runs faster than code fragment B. b. Code fragment B runs faster than code fragment A. c. Code fragment A runs as fast as code fragment B.