ERD Symbols and Meanings
Modeling your data using entity-relationship diagram (ERD) with Crow's Foot notation which is popular in Structured Systems Analysis, Barker's Notations, Design Methods and information engineering you need the software that is easy in use having all necessary elements for creating the needed flowcharts as well as their examples. You can find all essential ERD symbols and its meanings on our site with tutorials of how to use it and you can always use the already existing layouts for making your own diagrams in our Solution Park. Once you download our application with extension of hundreds of design elements you’ll find it simple to start using it straight away and you’ll be pleasantly surprised of how smart this tool for making the charts is.
Design elements Crow’s Foot notation
Crow's Foot notation is used in Barker's Notation, Structured Systems Analysis and Design Method (SSADM), and information engineering. Crow's Foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the cardinality of the relationship.
Entity-Relationship model making possibility to describe a database in which in the tables data can be the point to data in other tables — for instance, your entry in the database could point to several entries.
To create an ERD, software engineers mainly turn to dedicated drawing software, which contain the full notation resources for their specific database design — ERD symbols and meanings. CS Odessa has released an all-inclusive Entity-Relationship Diagram (ERD) solution for their powerful drawing program, ConceptDraw DIAGRAM
Example 1. Entity Relationship Diagram symbols and meaning
When you need to describe efficiently a database using the Crow’s Foot notation icons, ConceptDraw DIAGRAM gives you the ability to draw Entity Relationship diagram (ERD) fast and easy.
Design elements Chen's notation
The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships.
Use also ConceptDraw DIAGRAM enhanced with powerful Entity-Relationship Diagram (ERD) solution to draw your own ER diagrams using Chen's notation icons.
| 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. |
In addition to the vector stencil image libraries with full standardized Chen and Crow’s foot notations included, the Entity-Relationship Diagram (ERD) solution contains a number of ERD templates and samples added to the solution pack. They will help users quick start representing their own ideas.
.png "Entity Relationship Diagram samples and templates in ConceptDraw STORE")
Example 2. Entity Relationship Diagram samples and templates in ConceptDraw STORE
Try it today for saving your time sake not to look for something else once you have great chance to use this excellent product already now!
The following features make ConceptDraw DIAGRAM the best Entity Relationship Diagram ERD Software:
- You don't need to be an artist to draw professional looking diagrams in a few minutes.
- Large quantity of ready-to-use vector objects (entity relationship diagram symbols and meaning) makes your drawing diagrams quick and easy.
- Great number of predesigned templates and samples give you the good start for your own diagrams.
- ConceptDraw DIAGRAM provides you the possibility to use the grid, rules and guides. You can easily rotate, group, align, arrange the objects, use different fonts and colors to make your diagram exceptionally looking.
- All ConceptDraw DIAGRAM documents are vector graphic files and are available for reviewing, modifying, and converting to a variety of formats: image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash, MS Visio.
- Using ConceptDraw STORE you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from the ConceptDraw STORE.
- If you have any questions, our free of charge support is always ready to come to your aid.
TEN RELATED HOW TO's:
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.
Picture: Notation & Symbols for ERD
Related Solution:
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:
Enjoy the flowcharting process with the intuitive interface and powerful tools of the user-friendly ConceptDraw DIAGRAM software: ✔️ represent algorithms, ✔️ break down complex processes, ✔️ display workflows, ✔️ show procedures, ✔️ succeed in decision-making, ✔️ streamline processes, ✔️ increase productivity, ✔️ enhance efficiency
Picture: Flowcharting Software
Related Solution:
Functional modeling allows to make complex business processes simple. One of the basic methods is IDEF0 and one of the most effective also. To create a business model, use flowchart symbols.
The IDEF0 library, supplied with ConceptDraw IDEF0 Diagrams solution contains 18 IDEF0 basic notation symbols. All symbols are the vector graphic images what means, that one can customize their size preserving the stable quality. Another library of IDEF0 symbols can be find out in the the Business Process Diagrams solution, included to the Business Processes section of ConceptDraw Solution Park. These libraries composed from just vector objects and are totally compatible. You can apply the IDEF0 symbols from both libraries at your flowcharts, if needed.
Picture: IDEF0 Flowchart Symbols
Related Solution:
Database design is an important part of any project, as databases become more and more complex nowadays. To make the model more representative, entity relationship diagrams are widely used in software engineering area. These diagrams show sets of entities as rectangles connected via lines labeled with their cardinalities.
This an example of the ER-diagram developed to store information regarding some online role-playing game. It includes three main elements of ER diagram: entities, relationships and attributes. The entities, attributes and relationships on this ER-diagram is depicted according to the Chen's notation. Chen's notation for Entity Relationship diagrams admits using of rectangles to depict entities, ovals for attributes and ,at least, diamonds to show relationships. ConceptDraw Entity-Relationship Diagrams solution was applied as ERD software to create this diagram.
Picture: ConceptDraw DIAGRAM ER Diagram Tool
Related Solution:
The vector stencils library Crow's Foot Notation from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Crow's foot notation such as relationship symbols and entity symbols for ConceptDraw DIAGRAM software.
Picture: Martin ERD Diagrams
Related Solution:
Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit.
Electrical Engineering Solution used together with ConceptDraw DIAGRAM drawing facilities makes short a work of drawing various electrical and electronic circuit schemes. A library of vector objects composed from symbols of Analog and Digital Logic elements of electric circuit includes 40 symbolic images of logic gates, bistable switches of bi-stable electric current, circuit controllers, amplifiers, regulators, generators, etc. All of them can be applied in electronic circuit schemes for showing both analog and digital elements of the circuit.
Picture:
Electrical Diagram Symbols F.A.Q.
How to Use Electrical ConceptDraw Diagram Software
Related Solution:
Local area network connects computers and other network appliances within an area, such as office building or a campus. It can be difficult to provide such network without a predesigned plan. For these purposes you can use network diagram software, which helps you to create LAN network diagrams and office network diagrams quickly and effortless. This will speed up your work and you can save the diagram for the future network improvements.
The following diagram illustrates a network topology of the small office. LAN configuration has a star topology. The local network joins 8 computers among which are several desktop PCs, laptop, two iMacs and iBook. The end-point devices are divided into three groups. Each group is connected to its hub. There is a network printer and a modem, which are interconnected with other devices through a network server. Each computer on the LAN can access the server through a corresponding hub.
Picture: Network Diagram Software. LAN Network Diagrams. Physical Office Network Diagrams
Related Solution:
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:
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:
ConceptDraw
DIAGRAM 18