E-R Diagrams


ConceptDraw PRO
Discover the World of Visual Communication



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 PRO 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 Solution Browser. 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.

Example 3. E-R Diagrams in ConceptDraw PRO

The following features make ConceptDraw PRO 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 PRO 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 PRO 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 XML.
  6. Using ConceptDraw Solution Browser v3 you can navigate through ConceptDraw Solution Park, managing downloads and updates. You can access libraries, templates and samples directly from ConceptDraw Solution Browser.
  7. If you have any questions, our support is free of charge and always ready to come to your aid.












Use Product:

  • Software Development Tool
  • Diagram Software
  • Technical Diagramming Tool
  • Business Diagramming Tool
  • Professional Business Graphics Tool
  • ERD Diagrams Software
  • Cross Platform Compatibility


Use Solution:

Entity-Relationship Diagram (ERD)
  • Describing a database
  • Illustrate the logical structure of databases
  • Chen's notation
  • Crow’s Foot notation
  • Quick-Start ERD templates and samples
  • Entity Relationship Diagram examples
  • ERD vector elements
  • Import/Export Microsoft Visio™
  • Export to graphics files and PDF
  • Export to PPT™
  • Make Presentation


See also samples:


SEVEN RELATED HOW TO's:


UML Notation
Unified Modeling Language (UML) is a language of graphic description for object modeling in the field of software engineering. UML was created for definition, visualization, designing of software systems. UML is an open standard that uses graphic notations for creating visual models of object-oriented software systems. Two types of diagrams are used in UML: Structure Diagrams and Behavior Diagrams. Behavior Diagrams represent the processes proceeding in a modeled environment. Structure Diagrams represent the elements that compose the system.  Read more... →
uml diagram types list
Picture: UML Notation
Related Solution: Rapid UML

ERD Symbols and Meanings
Crow's foot notation is used in Barker's Notation, Structured Systems Analysis and Design Method (SSADM) and information engineering. Crow's foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the cardinality of the relationship. The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships. To create an ERD, software engineers mainly turn to dedicated drawing software, which contain the full notation resources for their specific database design - ERD symbols and meanings. CS Odessa has released an all-inclusive Entity-Relationship Diagram (ERD) solution for their powerful drawing program, ConceptDraw PRO.  Read more... →
Entity Relationship Diagram Symbols and Meaning - crow
Picture: ERD Symbols and Meanings
Related Solution: Entity-Relationship Diagram (ERD)

Entity Relationship Diagram Symbols
Creating an entity-relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database. ERD symbols used for professional ERD drawing are collected in libraries from the Entity-Relationship Diagram (ERD) solution for ConceptDraw PRO.  Read more... →
Entity Relationship Diagram Symbols
Picture: Entity Relationship Diagram Symbols
Related Solution: Entity-Relationship Diagram (ERD)

Entity-Relationship Diagram
Entity Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. The best software tool for drawing Entity-Relationship Diagram is ConceptDraw PRO vector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model. The vector graphic diagrams produced using this solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.  Read more... →
Entity-Relationship Diagram (ERD) - Students and Teachers
Picture: Entity-Relationship Diagram
Related Solution: Entity-Relationship Diagram (ERD)

Flowchart Component‎
The ConceptDraw Flowchart component includes a set of samples and templates. This geathered as flowchart maker toolbox which focused on drawing flowcharts of any industry standards.  Read more... →
Basic flowchart symbols - Template, this is flowchart maker
Picture: Flowchart Component‎
Related Solution: Flowcharts

What is Entity-Relationship Diagram
Entity Relationship Diagram (ERD) is an acknowledged method to visualize the logical structure of databases. Using special symbols described in ERD notations you can depict a database of any complexity. The vector graphic ER diagrams produced when using ConceptDraw ERD solution can be used in whitepapers, presentations, datasheets, posters, or any technical materials.  Read more... →
What is Entity-Relationship Diagram
Picture: What is Entity-Relationship Diagram
Related Solution: Entity-Relationship Diagram (ERD)

Entity Relationship Diagram Software
The world-best Entity Relationship Diagram software suitable for professional ERD drawing is ConceptDraw PRO software extended with the Entity-Relationship Diagram (ERD) solution. This solution contains all libraries, templates and samples you may need for professional ERD drawing.  Read more... →
Entity Relationship Diagram Software
Picture: Entity Relationship Diagram Software
Related Solution: Entity-Relationship Diagram (ERD)

Compatibility: Apple® OS X 10.10 or later
Microsoft® Windows® 7/8.1/10

Price: ConceptDraw PRO US$199
 
Download ConceptDraw PRO
Free 21 Trial for Mac and PC
Buy Now
1 Diagram Software
Professional business graphics tool for drawing schemes, diagrams and illustrating business documentation
1 Mind Map Software
Excellent tool for Mind Mapping, Planning, Brainstorming, and Building Processes
1 Project Management Software
The full complement of features needed to successfully plan and execute projects, including task and resource management, reporting, and change control