Chen ER Diagram - Entity-Relationship Diagram in Chen Notation
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.
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.
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.
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:
- Standard attribute
- Key attribute
- Weak key attribute
- Multi-value attribute
- Derived attribute
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.
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.
Multi-Value Attribute
A multi-value attribute can have multiple distinctive values. The attribute is represented by an array of values.
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.
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.
Weak Relationship
When entity A connected with a weak relationship to entity B, the existence of entity A depends on B entity existence.
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.
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).
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.
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