Made with
ConceptDraw
DIAGRAM 18

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.






TEN RELATED HOW TO's:
The vector stencils library Chen ERD from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Chen ERD notation including entity symbols and relationship symbols for ConceptDraw DIAGRAM software.Chen ERD Diagram
Picture: Chen ERD Diagram
Related Solution:
This sample shows the Flowchart that displays the layout and work flow of the cloud marketing platform. This diagram has a style of the marketing brochure. This style displays the central product that is related to the other issues. Using the ready-to-use predesigned objects, samples and templates from the Flowcharts Solution for ConceptDraw DIAGRAM you can create your own professional looking Flowchart Diagrams quick and easy.Flowchart Marketing Process. <br>Flowchart Examples *
Picture: Flowchart Marketing Process. Flowchart Examples
Related Solution:
The Process Flowchart or Process Flowchart Diagram (PFD) is a visual representation relations between major parts of the system, the steps in a process, and even connections between various systems. The possibility to easy create professional-looking and attractive Process Flowcharts, Business Process Diagrams and Maps which visualize the steps of complex processes is provided by Business Process Diagram Solution from the Business Processes Area of ConceptDraw Solution Park and 16 libraries with 230 process flowchart symbols from BPMN 1.2 and BPMN 2.0.Process Flowchart Symbols *
Picture: Process Flowchart Symbols
Related Solution:
Event-Driven Process chain Diagrams for improvement throughout an organisation. Best software for Process Flow Diagram. The Event-driven Process Chain (EPC) Diagrams allows managers to plan processes and resources.Business process Flow Chart — <br>Event-Driven Process chain (EPC) diagrams *
Picture: Business process Flow Chart — Event-Driven Process chain (EPC) diagrams
Related Solution:
Chemistry solution provides the Chemical Drawings Library with large quantity of vector chemistry equation symbols to help you create professional looking chemistry diagrams quick and easy.Chemistry Equation Symbols *
Picture: Chemistry Equation Symbols
Related Solution:
While creating flowcharts and process flow diagrams, you should use special objects to define different statements, so anyone aware of flowcharts can get your scheme right. There is a short and an extended list of basic flowchart symbols and their meaning. Basic flowchart symbols include terminator objects, rectangles for describing steps of a process, diamonds representing appearing conditions and questions and parallelograms to show incoming data. This diagram gives a general review of the standard symbols that are used when creating flowcharts and process flow diagrams. The practice of using a set of standard flowchart symbols was admitted in order to make flowcharts and other process flow diagrams created by any person properly understandable by other people. The flowchart symbols depict different kinds of actions and phases in a process. The sequence of the actions, and the relationships between them are shown by special lines and arrows. There are a large number of flowchart symbols. Which of them can be used in the particular diagram depends on its type. For instance, some symbols used in data flow diagrams usually are not used in the process flowcharts. Business process system use exactly these flowchart symbols.Flowchart example showing a customer request approval process with start, input output, process steps, decision branches, and end
Picture: Flowchart Symbols: Meaning and Examples
Related Solution:
The Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park extends ConceptDraw DIAGRAM vector graphics and diagramming software with the ability of drawing the Entity Relationship Diagrams for visually describing the databases with Crow’s Foot and Chen's notation icons.Entity Relationship Diagrams *
Picture: Entity Relationship Diagrams
Related Solution:
ConceptDraw DIAGRAM compatible Mac OS X software extended with powerful Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is one of the famous ER Diagram Programs for Mac. It gives the perfect ability to draw ER diagrams for visually describing databases with Chen's and Crow's Foot notation icons.ER Diagram Programs for Mac *
Picture: ER Diagram Programs for Mac
Related Solution:
Process Flow Charts are very popular and widely used in chemical and process engineering for representation a general flow of plant processes and equipment. If you need often draw them, the ConceptDraw DIAGRAM diagramming and vector drawing software extended with tools of Flowcharts Solution will be useful for you. The mostly used set of process flow chart symbols includes the following: Rectangle (box) process flow chart symbol, Rounded rectangle, Circle, Diamond.Process Flow Chart Symbol *
Picture: Process Flow Chart Symbol
Related Solution:
What's the best ERD tool for the Mac? ConceptDraw DIAGRAM on Mac OS X supplied with Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is the best ERD tool! This solution offers for ConceptDraw users so powerful drawing tools, libraries with numerous ERD objects, which will help design ER diagrams of any complexity and any design you want.What
Picture: What's the best ERD tool for the Mac?
Related Solution:
ConceptDraw
DIAGRAM 18