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:
Types of Flowcharts →
A flowchart is a simple but very functional tool when it comes to understanding a workflow or to removing unnecessary stages from a process. When drawing flowcharts, keep in mind that there are four common types of flowcharts, like document flowcharts and data flowcharts that show control over a data or document flow over a system. To show controls on a physical level, use system flowcharts. In addition, to show controls in a program, you can draw a program flowchart. This flowchart diagram represents the piece of an article editing process, that involves the author and editor. It was created using the Basic Flowchart notation that consists from the basic flowchart symbols. The start and the end of the process are indicated with "Terminator" symbols. The "Process" symbols show the action steps consisting from making edits and searching for a compromise, when the author does not agree with the suggestions of the editor. The "Process" symbol is the general symbol in process flowcharts. The "Decision" symbol indicates a branching in the process flow. There are two branches indicated by a Decision shape in the current flowchart (Yes/No, Disagree/Agree). This basic flowchart can be used as a repeating unit in the workflow diagram describing the working process of some editorial office.
Picture: Types of Flowcharts
Related Solution:
Building Drawing. Design Element Site Plan →
These libraries of vector objects depict the Site Accessories and Parking and Roads elements. They are needed to draw architectural and landscape plans that show the architectural elements around buildings: parking spaces, hiking and biking trails, drainage systems, lights, and vehicle access control elements. These libraries are included into ConcepDraw solution for Site Planning. Site Accessories and Parking, Roads libraries contain near 40 vector images that will help depict an a surrounding territory at building plans. These libraries of vector objects depict the Site Accessories and Parking and Roads elements. They are needed to draw architectural and landscape plans that show the architectural elements around buildings: parking spaces, hiking and biking trails, drainage systems, lights, and vehicle access control elements. These libraries are included into ConcepDraw solution for Site Planning. Site Accessories and Parking, Roads libraries contain near 40 vector images that will help depict an a surrounding territory at building plans.
Picture: Building Drawing. Design Element Site Plan
Related Solution:
Social Media Flowchart Symbols →
Social media is a popular view of mass communication which allows people, companies and organizations create, share, discover, modify, access, comment, discuss and exchange information through the Internet. Social Media Response solution for ConceptDraw DIAGRAM provides collection of 10 libraries with diversity of predesigned vector social media flowchart symbols for fast and easy creating interactive Social Media Flowcharts, Response Charts and Action Mind Maps.
Picture: Social Media Flowchart Symbols
Related Solution:
Design Element: Crows Foot for Entity Relationship Diagram - ERD →
The first thing that usually comes to mind when talking about database models is ER-diagrams, and the ways to create them. The second most recognizable notation is the Crow’s Foot, which visually differs from Chen’s notation. Actually, it doesn’t matter which notation you’ll use for your entity relationship diagram (ERD), but the content is what matters. When designing an Entity-Relationship Diagram one need to use a certain notated symbols that were developed and standardized especially for databases description. First of them - the Chen’s notation had a linguistic origin. It includes rectangle boxes to show entities that may be described as nouns, and the relationships between them described as verbs depicted in a form of diamond. Finally the Chen’s notation was simplified up to the Crow’s Foot notation. It represents a relationship as labeled line. It is precisely this notation is shown in the given figure. ConceptDraw DIAGRAM together with its Entity-Relationship Diagram (ERD) solution is designed to support professionals who deals with creating ER diagrams using the element of both - Chen’s and Crow's Foot notations.
Picture: Design Element: Crows Foot for Entity Relationship Diagram - ERD
Related Solution:
Chemistry Drawing Software →
ConceptDraw DIAGRAM extended with Chemistry solution from the Science and Education area is a powerful chemistry drawing software that provides the useful tools to help you design all kinds of chemistry drawings and illustrations, chemical schemes and diagrams of formulas, reaction schemes and lab set-ups of any complexity.
Picture: Chemistry Drawing Software
Related Solution:
How To Create Restaurant Floor Plan in Minutes →
As restaurant industry is growing rapidly nowadays, researches show that almost half of the adults have worked in a restaurant or a cafe. Moreover, many of them dream to start their own someday. Unfortunately, it takes a lot of time to write a business plan and to find a great location, although some know how to create a restaurant floor plan in minutes or how to plan budget effortlessly. Hiring employees can also cause a lot of headache, but this is crucial for further success, because every guest comes to restaurant for a good service and delicious food. It is also worth noting that restaurant concept is also important, because it defines target audience and influences the menu. This diagram represents the floor plan of an ongoing sports-theme establishment - restaurant, cafe, or other food service. A number of widescreen monitors installed along the perimeter provide visitors the opportunity to follow the course of a match from anywhere in the dining room of restaurant or cafe. The most of sports fans believe that food and alcohol is a big part of any sports show. That is why the dining room takes the most space - almost 60% of the total establishment space. Nearly all sports fans consume beverages while watching sports - beer, soda or water at least. Thus, the restaurant floor plan designers added a large lavatory there. Moreover, project developers considered unnecessary the gender division of such delicate place - perhaps they guess that only men are watching football, or believe that alcohol will eliminate the most of gender differences.
Picture: How To Create Restaurant Floor Plan in Minutes
Related Solution:
Process Flow Diagram Symbols →
Chemical and Process Engineering solution contains variety predesigned process flow diagram elements relating to instrumentation, containers, piping and distribution necessary for chemical engineering, and can be used to map out chemical processes or easy creating various Chemical and Process Flow Diagrams in ConceptDraw DIAGRAM.
Picture: Process Flow Diagram Symbols
Related Solution:
Drawing ER diagrams on a Mac →
Database model is a graphic representation need at the beginning of project development. You won't have any problems with drawing ER diagrams on a Mac anymore with ConceptDraw DIAGRAM application. Special libraries that contain all the symbols of both Chen's and Crow’s foot notation allow you to start database modeling within a few minutes. Creating entity-relationship diagrams on Mac is fun and effortless when you use a software designed for professional ERD drawing tailored to specific characteristics of Apple OS X. ConceptDraw DIAGRAM is a business diagramming software for those using OS X. The Entity-Relationship Diagrams solution for ConceptDraw has 2 libraries containing about 50 vector icons, depicting ERD symbols of the most popular Chen's and Crow’s Foot Notations. The other valuable component of the solution is a collection of ERDs samples and templates that can be opened on Macs and PCs.
Picture: Drawing ER diagrams on a Mac
Related Solution:
Flowchart →
If you ever tried programming, you could face a lot of problems as a beginner. To help yourself, create a flowchart to follow an algorithm logic. Flowchart represents a program as a sequence of steps depicted in special symbols for each type of action. This image of the interactive diagram made in ConceptDraw DIAGRAM applying the Live Objects technology. The diagram shows the effect of Selection Sort algorithm. The left part of the chart is the input area. The diagram in the central part of the drawing is a flow chart showing of the selection sort algorithm. The flowchart includes basic flowchart symbols, that represent various stages of algorithm. The flowchart symbols are connected with arrows ended lines, that depict the direction of the process flow. On the right side — the result is displayed.
Picture: Flowchart
Related Solution:
ConceptDraw
DIAGRAM 14