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:


THREE RELATED HOW TO's:


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 ER Diagram solution for ConceptDraw PRO.  Read more... →
Entity Relationship Diagram Symbols
Picture: Entity Relationship Diagram Symbols
Related Solution: Entity-Relationship Diagram (ERD)

ER diagram tool for OS X
ER diagram is the most popular database design tool which lets create graphical representations of database tables, their columns and also relationships. As for the Mac users, they are very interested in powerful database diagramming tools and ER diagram tool for OS X to design professional looking E-R Diagrams and ERD drawings. ConceptDraw PRO software on Mac OS X gives the ability to easy draw ERDs.  Read more... →
ER diagram tool for OS X
Picture: ER diagram tool for OS X


Entity Relationship Diagram Examples
ConceptDraw gives the ability to describe a database using the Entity-Relationship model. Entity-Relationship Diagram solution includes icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database. ConceptDraw contains Entity Relationship Diagram examples and templates for Data Modeling.  Read more... →
Entity Relationship Diagram Examples
Picture: Entity Relationship Diagram Examples
Related Solution: Entity-Relationship Diagram (ERD)

Compatibility: Apple® OS X 10.9 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