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.
TEN RELATED HOW TO's:
Data Modeling with Entity Relationship Diagram →
Data modeling is actively applied in analysis and uses wide set of methods for description the data requirements in a system. One of the most popular and well-known is the ERD method of database modeling. The best ERD tool for the Mac and Windows is ConceptDraw DIAGRAM software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development Area for ConceptDraw Solution Park, which is sharpened for professional ERD drawing and data modeling with Entity Relationship Diagram.
How to draw Metro Map style infographics? (Los Angeles) →
Tool to draw Metro Map styled inforgraphics. Los Angeles Metro Rail and Liner sample. This is a one-click tool to add stations to the map. It lets you control the direction in which you create new stations, change lengths, and add text labels and icons. It contains Lines, Stations, and Landmarks objects.
Process Flow Chart Symbols →
Process Flow Chart is a visual diagram which shows the processes and relationships between the major components in a system, and uses for this the special process flow chart symbols: special shapes to represent different types of actions and process steps, lines and arrows to represent relationships and sequence of steps. It often named process flow diagram, it use colored flowchart symbols. It is incredibly convenient to use the ConceptDraw DIAGRAM software extended with Flowcharts Solution from the "Diagrams" Area of ConceptDraw Solution Park for designing professional looking Process Flow Charts.
Block Diagram Software →
The popularity of Block Diagrams grows day by day. The existence of powerful software for their design is an excellent news! ConceptDraw DIAGRAM Block Diagram Software offers the Block Diagrams Solution from the "Diagrams" Area.
Create Floor Plans Easily with ConceptDraw DIAGRAM →
Interior design is an art of planning and coordinating the space in a building or on a floor to produce a charming and convenient environment for the client. You can ask professionals for help, or you can create floor plans easily with ConceptDraw DIAGRAM , using diverse libraries or altering numerous templates. You don’t need no formal training anymore to be a designer, isn’t it great? Using a ConceptDraw DIAGRAM floor plan software makes depicting of home or office layout ideas a simple task. It does not require special skills to make detailed and scaled floor plans. Adding furniture to design interior is also a breeze. You can draw and furnish your floor plans with a floor plan software. Moreover, using software for floor planning you gain an opportunity to share your plans and high-resolution images of your designs with clients or stakeholders.
Design Element: Chen for Entity Relationship Diagram - ERD →
It is very difficult to get into database model idea without any examples. To create one, you can use Chen’s notation for Entity Relationship Diagrams (ERD) and try to see all the peculiarities yourself. This notation describes entities and relations as basic geometric shapes like rectangles and diamonds. Chen notation for Entity-relationship diagrams is used for designing relational databases. It depicts the database entities as a set of subjects. For example events, people, ideas, etc. All entities has common characteristics (attributes). Any object of the system is identified as the sole and unique. The name of entity should indicate the class or type of the the whole object, not a given example. The connection commonly represents a relationship between entities. Conceptdraw Entity-Relationship Diagrams (ERD) solution provides the libraries with ready-to-use ERD element fitting Chen's notation objects and relationships.
Personal area (PAN) networks. Computer and Network Examples →
All computer networks differ by various params, and their size is one of them. As global area networks are the biggest, personal area (PAN) networks are the smallest. Personal computers, smartphones and other devices that have possibility to connect to Internet form a personal network. This diagram was created using ConceptDraw Computer Network Diagrams to represent a typical components of Personal area network. A personal area network (PAN) is the connection of IT devices around an individual person. This sample of personal area network involves a notebook, a personal digital assistant (PDA), and a portable printer. Commonly a PAN contains such wireless devices as mouse, keyboard, smartphone and tablet. A wireless connection is typical for a PAN.
Business Process Workflow Diagram →
Business Process Workflow Diagram is a professional visual tool that is widely applied for business development, business analysis, business process optimization and documenting business processes. Business Process Workflow Diagram lets depict in details the steps of business processes and flow of tasks between them, the execution of business processes, transfer of data and documents. The workflows on the Business Process Workflow Diagram are represented using the set of common symbols which let easy illustrate business processes and process flows, depict the start, all major steps and end of the process, what data are used by the process, how the data flow through the business areas within scope of our project, how the tasks are executed and by who, and how workers interact with each other.
Geo Map - USA - Maryland →
Maryland is a U.S. state located in the Mid-Atlantic region of the United States, bordering Virginia, West Virginia, and Washington, D.C. to its south and west; Pennsylvania to its north; and Delaware to its east. The vector stencils library Maryland contains contours for ConceptDraw DIAGRAM diagramming and vector drawing software. This library is contained in the Continent Maps solution from Maps area of ConceptDraw Solution Park.