Diagram Conventions   «Prev  Next»
 Lesson 3 Types of entity-relationship diagrams Objective Describe the types of entity-relationship diagrams.

# Types of Entity-relationship Diagrams

The three best-known types of ER diagrams are:
1. The Crowsfoot model: One of several types of entity-relationship (ER) diagrams, the Crowsfoot model neatly packages entities with their attributes by placing them in boxes. Also referred to as the Information Engineering model. Crowsfoot model also called the Information Engineering model.
2. The Chen model: One of several types of entity-relationship ER-diagrams. The Chen model is named after the inventor of ER diagramming Chen model.
3. The IDEF1X model (the least well-known of the three)

To get a sense of how different (but also, of how similar) these three models are, consider the following business rule, captured by each type of diagram: "An office is assigned to employees." (Do not be concerned at this point with interpreting the diagrams, you will learn how to do that shortly.)

## Weigh the Pros and Cons of the Three Different Models

I will provide a brief overview of each model's advantages and disadvantages.

## I. Crowsfoot Model:

1. Simplicity: The Crowsfoot model is arguably the easiest ER model to understand and interpret due to its minimalistic notation. The relationship types and cardinality are clearly marked on the diagram, making it suitable for simple and quick modeling exercises.
2. Visual clarity: The Crowsfoot notation uses distinctive symbols, which can be easily distinguished, adding to its ease of comprehension.
3. Flexibility: The model can easily accommodate various relationship types, including one-to-one, one-to-many, and many-to-many.

1. Limited expressiveness: Despite its simplicity, the Crowsfoot model falls short when it comes to modeling more complex relationships, and doesn't directly support concepts like inheritance or disjoint relationships.
2. No standardization: There is no standardization or widely accepted version of the Crowsfoot notation, leading to potential confusion and inconsistency across different implementations.

## Chen Model:

1. Expressiveness: The Chen model is well-regarded for its ability to accurately represent complex relationships. It directly supports concepts like inheritance, disjoint relationships, and explicit relationship types.
2. Standardization: The Chen model is a standardized form of ER diagrams, which helps ensure consistency across different databases and systems.
3. Semantic clarity: The Chen model uses clear, verbose symbols to describe entity relationships, which can help in understanding the business rules being represented.
1. Complexity: The Chen model's thoroughness comes at a cost – it can be quite complex to read and understand, particularly for those without prior database or systems design experience.
2. Verbose Notation: The model's verbosity can lead to crowded and complex diagrams, especially for larger systems, potentially leading to difficulty in comprehending the model.