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:
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.Basic Flowchart Symbols Meaning
Picture: Basic of Flowchart: Meaning and Symbols
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 is the beautiful design software that provides many vector stencils, examples and templates for drawing different types of illustrations and diagrams.

Mathematics Solution from the Science and Education area of ConceptDraw Solution Park includes a few shape libraries of plane, solid geometric figures, trigonometrical functions and greek letters to help you create different professional looking mathematic illustrations for science and education.Scientific Symbols Chart *

Picture: Scientific Symbols Chart
Related Solution:
Structured-systems analysis and design method uses data flow diagrams to represent the process of data flowing through a system. Talking about this might be useless without a proper example of DFD for online store (Data Flow Diagram). This DFD example shows all the distinctness that a diagram can bring into a scattered data structure. Data flow diagrams are used to show how data is processed within some business processes. Making DFD is a common practice for business process modeling and analysis. This diagram represents the online store business flow. It describes inputs and outputs within online selling process and depicts the interactions between its participants. This DF diagram can be used by system analysts to create an overview of a business, to study and discover its inherent strengths and weak points.Example of DFD for Online Store
Picture: Example of DFD for Online Store (Data Flow Diagram)
Related Solution:
The Flowchart is a very popular type of diagram, it is widely used for analyzing, designing, managing and visualizing the business and technical processes, various software algorithms. But how to create Flowchart quick and easy? Flowcharts solution from the Diagrams area of ConceptDraw Solution Park helps you to design the professional looking Flowchart Diagrams quick and easy using the ConceptDraw DIAGRAM diagramming and vector drawing software.Create Flowchart *
Picture: Create Flowchart - Making a Flowchart
Related Solution:
To maintain big and complex mechanical systems, you need an appropriate education and tools. It’s needless to say that mechanical drawing is important part of any industrial project. There are a lot of standard symbols depicting valves, pumps, motors, etc. This drawing illustrates the content of the Fluid Power Equipment library provided by the ConceptDraw Mechanical Engineering solution. The solution is composed from the 8 libraries, containing about 500 elements related to mechanical engineering visualization. it will be helpful for drawing various schemes, charts and blueprints of pneumatic, and hydraulic equipment or other drawing related mechanical engineering. All drawings can be freely resized without loss of quality due to the vector graphics components of its facilities.Mechanical Drawing Symbols
Picture:
Mechanical Drawing Symbols F.A.Q.
How to Use Mechanical Engineering Design Software
Related Solution:
ConceptDraw
DIAGRAM 18