Made with
ConceptDraw
DIAGRAM 16

E-R Diagrams

Complexity of databases increases day by day, due to this the Entity relationship models and E-R diagrams become more and more popular, and now are an important part of database design. E-R diagrams allow visually and graphically represent structure and design of databases.

You can use so popular Chen's notation to represent all components of database and their relationships on the ER diagram. This notation was developed and implemented by Peter Chen in 1976. The main components of the E-R diagrams are:

  • entities,
  • attributes that describe these entities,
  • relationships among these entities that describe associations between the data,
  • cardinalities that describe the number of relationship participants: one-to-many (1:M), many-to-many (M:N), and one-to-one (1:1).

In a Chen's notation, entities are represented by rectangles on the diagram with the entity names written inside and relationships are represented by diamonds. Another popular type of E-R diagrams is known as Crow's Foot notation that is derived from the Chen's notation.

E-R Diagram - Students and teachers

Example 1. E-R Diagram - Students and teachers

Use of ConceptDraw DIAGRAM for professional ERD drawing includes using the predesigned components of ER diagram, such as entity relationship symbols, work flow shapes, entity relationship stencils. All they are provided for easy use by 2 libraries of Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park.

ERD Libraries

Example 2. ERD Libraries

There is also wide collection of predesigned E-R Diagrams which is represented at ConceptDraw STORE. All E-R Diagrams samples and templates are well thought-out, professionally designed, can be easy changed according to your needs and further successfully used.

E-R Diagrams *

Example 3. E-R Diagrams in ConceptDraw DIAGRAM

The following features make ConceptDraw DIAGRAM extended with the Entity-Relationship Diagram (ERD) solution the most effective E-R diagrams design software:

  1. You don't need to be an artist to draw professional looking diagrams in a few minutes.
  2. Large quantity of ready-to-use vector objects makes drawing your diagrams quick and easy.
  3. Extensive collection of pre-designed templates and samples give you a great start for your own diagrams.
  4. ConceptDraw DIAGRAM provides you with the possibility to use the grid, rules and guides. You can easily rotate, group, align, and arrange objects, and use different fonts and colors to make your diagram stand out.
  5. 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.
  6. Using ConceptDraw STORE you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from ConceptDraw STORE.
  7. If you have any questions, our support is free of charge and always ready to come to your aid.






TEN RELATED HOW TO's:

What's the best ERD tool for the Mac? →

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:

Fishbone Diagram Problem Solving →

The Ishikawa diagram, Cause and Effect diagram, Fishbone diagram — all they are the names of one and the same visual method for working with causal connections. Originally invented by Kaoru Ishikawa to control the process quality, the Ishikawa diagram is well proven in other fields of management and personal scheduling, events planning, time management. It is a chart in the form of a fish, whose head is a problem, the fins are variants for its causes. To design easily the Fishbone diagram, you can use a special ConceptDraw DIAGRAM vector graphic and diagramming software which contains the powerful tools for Fishbone diagram problem solving offered by Fishbone Diagrams solution for the Management area of ConceptDraw Solution Park.Fishbone Diagram Problem Solving *
Picture: Fishbone Diagram Problem Solving
Related Solution:

ER Diagram for Cloud Computing →

The entity–relationship (ER) model is a data model that lets graphically represent the information system and depict the relationships between people, objects, concepts, places, and events within a given system. It is also convenient to use the ER Diagram for Cloud computing representation and description the Cloud computing architecture, design them with pleasure using the extensive tools of the Cloud Computing Diagrams solution from the Computers and Network area of ConceptDraw Solution Park.ER Diagram for Cloud Computing *
Picture: ER Diagram for Cloud Computing
Related Solution:

Linux Audit Flowchart Example. Flowchart Examples →

Create your own Linux audit flowcharts using the ConceptDraw DIAGRAM diagramming and vector drawing software extended with the Audit Flowcharts solution from the Finance and Accounting area of ConceptDraw Solution Park. This flowchart example describing auditd, the linux audit tool.Linux Audit Flowchart Example. Flowchart Examples
Picture: Linux Audit Flowchart Example. Flowchart Examples
Related Solution:

SDL Diagram →

Specification and Description Language (SDL) is used for creating the object-oriented diagrams, visualizing the processes of the state machines for the systems of communication, telecommunication, automotive, aviation and medical industries. SDL is a specification language for creating specifications, descriptions of the behavior, data, and inheritance for real-time systems. This sample shows the SDL Diagram of the process game.SDL Diagram *
Picture: SDL Diagram
Related Solution:

ConceptDraw DIAGRAM ER Diagram Tool →

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.ConceptDraw DIAGRAM ER Diagram Tool *
Picture: ConceptDraw DIAGRAM ER Diagram Tool
Related Solution:

UML Deployment Diagram →

UML Deployment Diagram depicts the physical deployment of artifacts on nodes (nodes are the existing hardware components, artifacts are the software components running on each node); and how the different pieces are connected. Use ConceptDraw DIAGRAM with UML deployment diagram templates, samples and stencil library from Rapid UML solution to model the physical deployment of artifacts on nodes of your software system.UML Deployment Diagram *
Picture: UML Deployment Diagram
Related Solution:

Martin ERD Diagram →

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 diagramming and vector drawing software. The Entity-Relationship Diagrams (ERD) solution is contained in the Software Development area of ConceptDraw Solution Park.Martin ERD Diagram *
Picture: Martin ERD Diagram
Related Solution:

Design Element: Crows Foot for Entity Relationship Diagram - ERD →

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.Design Element: Crows Foot   <br>for Entity Relationship Diagram - ERD *
Picture: Design Element: Crows Foot for Entity Relationship Diagram - ERD
Related Solution:
ConceptDraw
DIAGRAM 16