Made with
ConceptDraw
DIAGRAM 14

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.

What is Entity-Relationship Diagram *

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.

What is Entity-Relationship Diagram, Chen's notation

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.

ERD Libraries

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.

Entity-Relationship Diagram Symbols

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:

How to Draw ER Diagrams →

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.How to Draw ER Diagrams *
Picture: How to Draw ER Diagrams
Related Solution:

Best Software to Draw Diagrams →

ConceptDraw DIAGRAM can help you make professional diagrams quickly.Best Software to Draw Diagrams *
Picture: Best Software to Draw Diagrams
Related Solution:

Notation & Symbols for ERD →

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.Notation & Symbols for ERD *
Picture: Notation & Symbols for ERD
Related Solution:

How to create a UML Diagram →

ConceptDraw DIAGRAM extended with the Rapid UML solution is perfect for drawing professional UML diagrams.How to create a UML Diagram *
Picture: How to create a UML Diagram
Related Solution:

Anyone Have an ERD Symbols Quick Reference? →

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.Anyone Have an ERD Symbols Quick Reference? *
Picture: Anyone Have an ERD Symbols Quick Reference?
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.Process Flow Diagram Symbols
Picture: Process Flow Diagram Symbols
Related Solution:

Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams →

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.Entity Relationship Diagram - ERD - Software for Design  <br>Chen ER Diagrams *
Picture: Entity Relationship Diagram - ERD - Software for Design Chen ER Diagrams
Related Solution:

Graphical Symbols to use in EPC diagrams →

Event-Driven Process Chain Diagrams for improvement throughout an organisation. ConceptDraw DIAGRAM - software that reduces the time needed to create a business process model.Graphical Symbols to use in EPC diagrams *
Picture: Graphical Symbols to use in EPC diagrams
Related Solution:
ConceptDraw
DIAGRAM 14