What is Entity-Relationship Diagram
A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are:
- UML diagrams
- ER-model diagrams.
What is Entity-Relationship Diagram? Entity relationship diagrams look very similar to flowcharts, the main difference is the symbols provided by specific ERD notations. There are several models applied in entity-relationship diagrams: conceptual, logical and physical.
Example 1. What is Entity-Relationship Diagram, Crow's foot notation
Creating an entity relationship diagram requires using a specific notation. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Five main components of common ERD notations are Entities, Actions, Attributes, Cardinality and Connections.
Example 2. What is Entity-Relationship Diagram, Chen's notation
ERD notations
The two of notations most widely used for creating Entity-Relationship Diagrams are:
- Chen's notation
- Crow's foot notation.
Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. By the way, the Crow's foot notation originates from the Chen's notation - it is an adapted version of the Chen's notation.
Professional ERD drawing implies knowing of ERD symbols and meanings. Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park includes icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.
Example 3. ERD Libraries
In Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM all entity relationship diagram symbols and meaning, work flow shapes, and entity relationship stencils have easy to understand labels helps you while building Entity Relationship Diagram.
Example 4. Entity-Relationship Diagram Symbols
The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM ector graphics and diagramming software with the ability to describe a database using the Entity-Relationship model. Use it to draw with pleasure your own professional-looking Entity-Relationship Diagrams using Chen's or Crow's foot 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:
ConceptDraw offers you a number of ready-made organizational chart templates which you can use in your drawing. They are grouped in topical sets as organizational chart template files.
Use the Organizational Charts Solution for ConceptDraw DIAGRAM to create your own Organizational Charts of any complexity quick, easy and effective.
The Organizational Charts designed with ConceptDraw DIAGRAM are vector graphic documents and are available for reviewing, modifying, converting to a variety of formats (image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash or MS Visio XML), printing and send via e-mail in one moment.
Picture: Organizational Chart Templates
Related Solution:
What are the favorite educational technology tools and techniques for teachers? Of course these are pictures, images and education infographics! ConceptDraw DIAGRAM software supplied with Education Infographics Solution from the Business Infographics Area provides powerful drawing tools to help design the education infographics of any complexity.
Picture: Educational Technology Tools
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:
How to Draw ER Diagrams? With Entity-Relationship Diagram (ERD) solution from the Software Development Area for ConceptDraw Solution Park you are able to draw ER diagram with no problem. It includes 45 predesigned icons advocated by popular Chen's and Crow’s Foot notations that can be used when describing an enterprise database.
Picture: How to Draw ER Diagrams
Related Solution:
ConceptDraw DIAGRAM can help you make professional diagrams quickly.
Picture: Best Software to Draw Diagrams
Related Solution:
ConceptDraw DIAGRAM extended with the Rapid UML solution is perfect for drawing professional UML diagrams.
Picture: How to create a UML Diagram
Related Solution:
ERD drawing becomes easier with predesigned entity relationship symbols, work flow shapes, entity relationship stencils. All variety of ERD symbols you may need for ERDs design is packed into libraries and templates from Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM diagramming and vector drawing software.
But anyone have an ERD symbols quick reference? Detailed reference information for them is represented at the tables.
Picture: Anyone Have an ERD Symbols Quick Reference?
Related Solution:
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:
The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability to describe a database using the Entity-Relationship (Chen) model. Use it for design your ERDs and verify that ConceptDraw DIAGRAM offers the best ERD diagrams software tools for design element Chen notation._Win_Mac.png)
Picture: Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams
Related Solution:
