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:
Why do you need a business process flow diagram? How to use business process diagram software? Explore ✔️ the significance, ✔️ creation process, and ✔️ discover cutting-edge software solutions designed to streamline and optimize your workflows
Picture: Business Process Workflow Diagrams & Software
Related Solution:
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.
Picture: Geo Map — USA — Maryland
Related Solution:
Electrical plan is a document that is developed during the first stage of the building design. This scheme is composed of conventional images or symbols of components that operate by means of electric energy. To simplify the creation of these schemes you can use house electrical plan software, which will not require a long additional training to understand how to use it. You only need to install the necessary software ant it’s libraries and you’ll have one less problem during the building projection.
Any building contains a number of electrical systems, including switches, fixtures, outlets and other lightening equipment. All these should be depicted in a building electrical plans and included to general building documentation. This home electrical plan displays electrical and telecommunication devices placed to a home floor plan. On the plan, each electrical device is referenced with the proper symbol. Electrical symbols are used for universal recognition of the building plan by different persons who will be working on the construction. Not all possible electric symbols used on a certain plan, so the symbols used in the current home plan are included to a legend. The electrical home plan may be added as a separate document to a complete set of building plans.
Picture: How To use House Electrical Plan Software
Related Solution:
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Class Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park.
This sample shows the structure of the building and can be used by building companies, real estate agencies, at the buying / selling of the realty.
Picture: UML Class Diagram Example - Buildings and Rooms
Related Solution:
Sometimes, when it is difficult to create a functional space plan or to rearrange existing one, the art of interior design comes in. It doesn't matter, if you need a cozy bedroom or an office layout plan, you should use appropriate tools to make your design great.
While making a floor plan of a new office it could be useful to apply some design elements such as furniture and office equipment. This diagram presents an office furniture objects that can be used for office interior design planning, or making office furniture and equipment layouts. This vector stencils library is supplied with ConceptDraw Office Layout Plans solution. It contains more then 30 vector objects of office interior for making office floor plans including an office space layout plans and furniture arrangement.
Picture: Interior Design. Office Layout Plan Design Element
Related Solution:
Users can start drawing their own flowchart diagrams in fast and simple way with ConceptDraw software.
ConceptDraw DIAGRAM is the only professional diagramming software that works on both Windows and Macintosh platforms. All its documents and libraries are 100% compatible and can be exchanged hassle-free between the platforms.
Picture: Create a Flow Chart
Related Solution:
No building project can exist without an electrical circuit map. It’s more convenient to develop electrical drawing with a proper software which would contain vector shapes and electrical symbols. This will help in the future if any problems appear.
This circuit diagram shows the scheme of a location of components and connections of the electrical circuit using a set of standard symbols. It can be use for graphical documentation of an electrical circuit components. There are many of different electric circuit symbols that can be used in a circuit diagram. Knowing how to read circuit diagrams is a useful skill not only for professionals, but for any person who can start creating his own small home electronic projects.
Picture: Electrical Drawing Software and Electrical Symbols
Related Solution:
If you are just a beginner in drawing flowcharts, it may seem that a sheet of paper and a pen are just enough. However, at the time you would want to share your results, diagramming applications would suite you better. it’s very easy to create diagrams that way and to discover new kinds of flowcharts.
The huge collection of sample ConceptDraw diagrams, charts, illustrations and other types of business drawings includes a wide range of business themes. A huge number of graphic images of ConceptDraw documents is divides on business application areas according to business-oriented solutions for which they were made.Here is a short visual list of samples of flowcharts, process diagrams, UML models, management charts, computer network diagrams, maps, infographics, illustrations, etc. In short, each ConceptDraw solution is accompanied with at least ten samples representing some particular examples of the application of the given chart.
Picture: Applications
When we start to speak about databases, we must always mention database structure visualization. One of the most common ways to do it is to create an entity relationship diagram, and to put appropriate symbols on it. It is important either for database projecting and for its' future maintenance.
Entity Relationship Diagram describes data elements and their relationships within a database. There are a set of special symbols that depict each element of an entity relationship diagram. Entities - represents some stable components such as supplier, employee, invoice, client, etc. Relation symbols show how the entities interact. Attributes define characteristics of the relationships. Attributes can be one-to-one or many-to-many. Physical symbols is used in the physical models. They represent items such as fields, tables, types and keys. ERD physical symbols are the building material for the database. Notation lines are used to illustrate the relationships. The most common method is Crow’s Feet notation. You can use ConceptDraw Entity-Relationship Diagram (ERD) solution to represent a database using the Entity-Relationship model.
Picture: Entity Relationship Diagram Symbols
Related Solution:
Entity Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. The best software tool for drawing Entity-Relationship Diagram is ConceptDraw DIAGRAM vector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model. The vector graphic diagrams produced using this solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.
Picture: Entity-Relationship Diagram
Related Solution:
ConceptDraw
DIAGRAM 18