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

Computer Science & Information Technology

You might also like to view...

What is a Histogram?

What will be an ideal response?

Computer Science & Information Technology

If multiple individuals are copied on a letter, key the names on separate lines and align the items at the 0.5" tab setting.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A(n) ____________________ is a light-sensing input device that reads printed text and graphics and then translates the results into a form the computer can process.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

 A(n) ____ variable collects a total value over a period of time.

A. catalog B. glossary C. register D. accumulator

Computer Science & Information Technology