Chen ER Diagram - Entity-Relationship Diagram in Chen Notation

Chen's notation of the entity-relationship diagram depicts data and domain models using entities, attributes, and relationships. Unlike other ER diagram notations, it shows attributes as standalone boxes, not as a part of entities.

What is Chen ER Diagram?

Chen ER diagram is an entity-relationship diagram notation that shows entities, attributes, and relationships within a data model. It is a useful method for designing conceptual models. Unlike the other entity-relationship diagram notations, it depicts the entity attributes and relationships in separate boxes, connected to the entities.

The Chen notation was created by Peter Chen, a computer scientist who specialized in database theory. He is most notable for his work on the entity-relationship model, which he first published in 1976. The Chen ER diagram is one of the most popular notations for conceptual and logical ER models.

The diagram notation is used in software engineering and database design.

Chen Diagram Symbols

Chen ER diagram offers these symbols:

Entity

An entity represents a set of objects with the same attributes within a data model. An entity represents a real-world object or concept, such as a person, place, concept, or thing. It is depicted as a rectangle.

Entity (Chen ERD)
Entity (Chen ERD)

Weak Entity

A weak entity is a type of entity that does not have any unique key for the attribute tuples. A weak entity depends on another entity, that is considered its owner. It is depicted as a rectangle with a double border.

Weak Entity (Chen ERD)
Weak Entity (Chen ERD)

Associative Entity

An associative entity represents a many-to-many relationship that is expressed by another entity (or a table in a database). It is depicted as a rectangle with a diamond inside.

Associative entities are used when there is a need to store data about associations between two entities. For example, if we have a department and its employees, the employee may have an "employee classification" that indicates which department he or she works for.

Associative Entity (Chen ERD)
Associative Entity (Chen ERD)

Attribute

An attribute contains a piece of information that describes an entity. An attribute is depicted as an ellipse. There are these types of attributes:

Attribute (Chen ERD)
Attribute (Chen ERD)

Key Attribute

A key attribute represents an identifying attribute. The key attributes define a combination of keys that unambiguously define a tuple within an entity.

Key Attribute (Chen ERD)
Key Attribute (Chen ERD)

Weak Key Attribute

A weak key attribute (or partial key) is an attribute that in combination with the owner's key creates a key for a weak entity.

Weak Key Attribute (Chen ERD)
Weak Key Attribute (Chen ERD)

Multi-Value Attribute

A multi-value attribute can have multiple distinctive values. The attribute is represented by an array of values.

Multi Value Attribute (Chen ERD)
Multi Value Attribute (Chen ERD)

Derived Attribute

A derived attribute represents an attribute that does not physically exist in permanently stored form. It is an attribute that is calculated from other attributes.

Derived Attribute (Chen ERD)
Derived Attribute (Chen ERD)

Relationship

A relationship defines the interconnection between two entities. It is depicted as a diamond. There are two specific types of relationships:

  • Strong relationship - is depicted as a diamond with a normal line border.
  • Weak relationship (Identifying) - is depicted as a diamond with a double line border.

Strong Relationship

When entity A connected with a strong relationship to entity B, the existence of entity A is independent of the existence of entity B.

Relationship (ERD Chen)
Relationship (ERD Chen)

Weak Relationship

When entity A connected with a weak relationship to entity B, the existence of entity A depends on B entity existence.

Weak Relationship (Chen ERD)
Weak Relationship (Chen ERD)

Participation

The Chen ER diagram allows you to define a type of entity participating in a relationship. It can be:

  • Total participation - is depicted as a double line
  • Partial participation - is depicted as a solid line
  • Optional participation - is depicted as a dashed line

Cardinality

The relationship can connect one or multiple tuples from one entity to one or multiple tuples of another entity. You can use these cardinalities for the relationships:

  • One-to-one (1:1)
  • One-to-many (1:N)
  • Many-to-one (N:1)
  • Many-to-many (M:N)

How to Make Chen ER Diagram

1. Press CTRL+D or click on the Plus button in the tab bar above the diagram editor and select the Chen Entity-Relationship Diagram. You can also press CTRL+SHIFT+D and choose the diagram in the dialog. The dialog allows you to specify the diagram name and add the diagram to the project in one step.

Add Chen ER diagram using the dialog
Add Chen ER diagram using the dialog

2. Add entities, attributes, and relationships using the toolbox. You can drag & drop the elements to the diagram or select the element in the toolbox and then specify the bounds of the element in the diagram (press and hold the mouse button in the top left corner of the bounds, move to the right bottom corner and release the button).

Chen ER Diagram Example
Chen ER Diagram Example

3. You can adjust the positions of existing entities, attributes, and relationships using the Selection tool. Select the element you want to move and drag it to the desired position.

You can also change the type of entity, attribute, relationship, and participation without its re-creation.

Just select the desired element in the diagram editor and right-click on it. You can change the new type from the context menu:

  • for Entity you can choose between Standard and Weak.
  • for Attribute you can choose between Key, Weak Key, Derived, Multi Value, and Standard.
  • for Relationship you can choose between Standard, Weak and Associative Entity.
  • for Participation you can choose between Standard, Optional and Total.

Alternatively, you can change the type of the selected Chen ERD element using the ribbon - switch to the Model context tab and choose the desired element subtype using the respective button in the Modifiers group.

4. You should set the correct cardinalities for particular participations. Select a participation connector which leads from an entity to a relationship. Then click on the highlighted label and choose from the offered cardinalities or enter the custom one.

Set cardinality of the participation in the Chen ER diagram
Set cardinality of the participation in the Chen ER diagram

5. Export the Chen ER diagram to an image format to use it outside Software Ideas Modeler. Click on the Diagram tab in the top ribbon and then click on the Export button (located in the Process group). Choose Image from the displayed drop-down menu and specify format, size, and exported content in the follow-up dialog.

Chen ER Diagram Examples

You can check out our examples of Chen ER diagrams:

Chen ER Diagram Tool

Chen ER diagrams can be created and edited with the ERD Chen notation tool Software Ideas Modeler.

New Comment

Comment