Notation & Symbols for ERD
Creation of the entity-relationship model is one of the most important stages in the process of creating databases and modeling of business processes. Entity Relationship Diagram (ERD) reflects reality and allows you to get the most complete picture about the actual data requirements that are set at the company.
The entity-relationship model described in form of ERD represents the information that is gathered and used at the conduct of business. It visually shows how the database or application system will look, but doesn't disclose a way of realization. The ERD doesn't depend on the choice of database producer. It groups the data into separate entities and links these entities to each other on the base of business rules. The entity has the contents and represents some object about which is needed to store information. The business rules is a line of conduct and procedures for the business organization, they describe how the company is functioning.
The ER diagram is constructed from the specific ERD graphic elements. There are used 2 types of ERD notations: Chen and Crow's Foot.
A complete set of work flow shapes, notation & symbols for ERD, entity relationship stencils, included in Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM software, makes drawing diagrams based on ERD notation as smooth as possible.
Example 1. Entity relationship diagram (ERD) symbols, Crow's Foot notation
All these ERD symbols are vector, you can drag to the document to construct the ER Diagram, resize any of them without loss of quality, change their color to make your diagram more attractive and colorful.
ERD Chen's notation
| Symbol |
Shape Name |
Symbol Description |
| Entities |
 |
Entity |
An entity is represented by a rectangle which contains the entity’s name. |
 |
Weak Entity |
An entity that cannot be uniquely identified by its attributes alone. The existence of a weak entity is dependent upon another entity called the owner entity. The weak entity’s identifier is a combination of the identifier of the owner entity and the partial key of the weak entity. |
 |
Associative Entity |
An entity used in a many-to-many relationship (represents an extra table). All relationships for the associative entity should be many |
| Attributes |
 |
Attribute |
In the Chen notation, each attribute is represented by an oval containing atributte’s name |
 |
Key attribute |
An attribute that uniquely identifies a particular entity. The name of a key attribute is underscored. |
 |
Multivalued attribute |
An attribute that can have many values (there are many distinct values entered for it in the same column of the table). Multivalued attribute is depicted by a dual oval. |
 |
Derived attribute |
An attribute whose value is calculated (derived) from other attributes. The derived attribute may or may not be physically stored in the database. In the Chen notation, this attribute is represented by dashed oval. |
| Relationships |
 |
Strong relationship |
A relationship where entity is existence-independent of other entities, and PK of Child doesn’t contain PK component of Parent Entity. A strong relationship is represented by a single rhombus |
 |
Weak (identifying) relationship |
A relationship where Child entity is existence-dependent on parent, and PK of Child Entity contains PK component of Parent Entity. This relationship is represented by a double rhombus. |
Example 2. ER Diagram - Chen's Notation
ERD Crow’s Foot notation
| Symbol |
Meaning |
| Relationships
(Cardinality and Modality) |
 |
Zero or More |
 |
One or More |
 |
One and only One |
 |
Zero or One |
| Many - to - One |
 |
a one through many notation on one side of a relationship and a one and only one on the other |
 |
a zero through many notation on one side of a relationship and a one and only one on the other |
 |
a one through many notation on one side of a relationship and a zero or one notation on the other |
 |
a zero through many notation on one side of a relationship and a zero or one notation on the other |
| Many - to - Many |
 |
a zero through many on both sides of a relationship |
 |
a one through many on both sides of a relationship |
 |
a zero through many on one side and a one through many on the other |
 |
a one and only one notation on one side of a relationship and a zero or one on the other |
 |
a one and only one notation on both sides |
Example 3. ER Diagram - Crow's Foot Notation
The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park. An experienced user spent 10 minutes creating these samples.
Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM software to create quick and easy your own professional looking ERDs using Crow's Foot and Chen notations.
All source documents are vector graphic documents. They are available for reviewing, modifying, or converting to a variety of formats (PDF file, MS PowerPoint, MS Visio, and many other graphic formats) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.
NINE RELATED HOW TO's:
The use case diagram (behavior scenarios, precedents) is the initial conceptual representation of the system during its design and development. This diagram consists of actors, use cases and relationships between them. When constructing a diagram, common notation elements can also be used: notes and extension mechanisms.
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park.
This sample shows the types of user’s interactions with the system and is used at the registration and working with the database system.
Picture: UML Use Case Diagram Example. Registration System
Related Solution:
Mathematical Drawing Software - Draw mathematical illustration diagrams easily from examples and templates!
Picture: Basic Diagramming
Related Solution:
Stakeholder analysis in conflict resolution, project management, and business administration, is the process of identifying the individuals or groups that are likely to affect or be affected by a proposed action, and sorting them according to their impact on the action and the impact the action will have on them.
Use the ConceptDraw DIAGRAM diagramming and vector drawing software enhanced with powerful tools of Stakeholder Onion Diagrams Solution from the Management Area of ConceptDraw Solution Park to easy and effectively visualize stakeholder analysis.
Picture: Visualize Stakeholder Analysis with Onion Diagram
Related Solution:
These vector illustrations and cliparts are created for drawing the Project management Illustrations and contain plenty of project management design elements. The clipart library Project management includes 35 icons.
Picture: Project management - Design Elements
Related Solution:
It's no secret that there is a list of skills that every average system administrator should have. And it's important to be able to manage domains via active directory technologies. The best way to keep all the details in mind is to draw a diagram representing users, groups and domains.
This diagram represents an Active Directory Services (Active Directory Domain Services). It can be helpful for system and network administrators to organize a network physical and logical elements (domains, data bases, servers, network equipment, end-user computers etc.) into a secure and logical structure. The logical structure of Active Directory is a hierarchical organization of all network components. The data that is stored in Active Directory comes from some diverse sources. The Active Directory diagram created using ConceptDraw Active Directory Diagram solution. It shows allocating group policies and functions assigned to end users. It helps to plan, manage and maintain the certain user access scenario.
Picture: Active Directory Diagram
Related Solution:
Apply Electrical Engineering solution for ConceptDraw DIAGRAM and numerous electric circuit symbols to 🔸 develop and illustrate all types of electrical circuits as ✔️ electrical circuit diagrams, ✔️ electrical schematics, ✔️ electrical diagram drawings
Picture: Electrical Circuits — Electrical Symbols
Related Solution:
When thinking about data visualization, one of the first tools that comes to mind is a flowchart design. You can find flowchart symbols, shapes, stencils and icons easily on the Internet, but it might take time to systematize this information. Nevertheless, once you start flowcharting, you’ll love its simplicity and efficiency.
This diagram consists from standard flowchart symbols, approved by ANSI (American National Standard Institute) for drawing flowcharts. A flowchart is a diagram that represents a step-by-step algorithm of any process, displaying the process stages as boxes that are connected with arrows. Flowchart design makes it clear and readable.
Flowchart designed using ConceptDraw DIAGRAM flowchart software allows to make attractive and clear process presentation, it makes interpretation of the business process flow fresh and versatile. Great flowchart design view is a big advantage over the diagram created manually on a paper.
Picture:
Flowchart Design
Flowchart Symbols, Shapes, Stencils and Icons
Related Solution:
UML Deployment diagram describes the hardware used in system implementations and the execution environments and artifacts deployed on the hardware.
ConceptDraw has 393 vector stencils in the 13 libraries that helps you to start using software for designing your own UML Diagrams. You can use the appropriate stencils of UML notation from UML Deployment library.
Picture: UML Deployment Diagram. Design Elements
Related Solution:
Electrical rotating machines, such as motors and generators, are vital assets for any power plant or large industrial company.
An electric motor is an electrical machine that converts electrical energy into mechanical energy. The reverse of this would be the conversion of mechanical energy into electrical energy and is done by an electric generator.
In normal motoring mode, most electric motors operate through the interaction between an electric motor's magnetic field and winding currents to generate force within the motor. In certain applications, such as in the transportation industry with traction motors, electric motors can operate in both motoring and generating or braking modes to also produce electrical energy from mechanical energy.
26 libraries of the Electrical Engineering Solution of ConceptDraw DIAGRAM make your electrical diagramming simple, efficient, and effective. You can simply and quickly drop the ready-to-use objects from libraries into your document to create the electrical diagram.
Picture: Electrical Symbols — Rotating Equipment
Related Solution:
