Developing Entity Relationship Diagrams

ConceptDraw PRO
Discover the World of Visual Communication

Entity Relationship diagrams are the powerful tool for clear and visual modeling the relationships between database entities. When developing Entity Relationship Diagrams are used a set of common block objects and lines to describe the structure of a database.

Use the ConceptDraw PRO software extended with Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park for designing ER diagrams, which offers the predesigned commonly used Entity relationship symbols and ER objects. Thanks to them you can make the ERDs easy understandable for all your colleagues.

Sample 1. Entity Relationship Diagram (ERD), crow's foot notation

How to Build an Entity Relationship Diagram

When you need to visually represent the structure of relational database, Entity relationship diagram (ERD) is the best type of diagram for that case.

Most entity-relationship diagrams can be built with objects from Flowchart solution or ERD Solution which contains inbuilt templates. Follow these steps to create your own custom ERD diagram.

Don't be frightened if it looks complex, ConceptDraw PRO makes it easy to create an ERD, and hundreds of other diagrams, in minutes.

  • Start drawing with Entity object from Crow's foot ERD object.
    Note: This object contains several levels:
    1 - object itself
    2 - lines in the object
    3 - separate cell.
  • It is possible to set different setting to each level.
  • To switch from level to level, click on object with separate clicks when it's selected.

    Developing Entity Relationship Diagram

  • Add text.
  • Change object's color.

    Developing Entity Relationship Diagram

  • Copy Teachers table.
  • Add new rows via drop-down menu.
    Note: Adding and removing is always performed from a bottom row.
  • New added row will have same preferences as bottom one.

    Developing Entity Relationship Diagram

  • Paste copied table as many times as you need.

    Developing Entity Relationship Diagram

  • Filling the table.
    Note: To fill a separate cell, select it clicking with 3 separate clicks.
  • Delete excess rows via drop-down menu for each table.

    Developing Entity Relationship Diagram

  • Use M:1 (many-to-one) connector from ERD Crow’s Foot Notation library.
  • Connect needed rows of tables.

    Developing Entity Relationship Diagram

  • If you want to change connectors' type, select all connectors with held Shift button and click on Smart connector icon at ribbon.
  • To change connectors' elbow position, pull the yellow control dot.

    Developing Entity Relationship Diagram

  • Select tables from left and set the same distribution.

    Developing Entity Relationship Diagram

  • You may block the horizontal moving for object, so figure might be moved only vertically.

    Developing Entity Relationship Diagram

  • Use M:M (many-to-many) connector from ERD Crow’s Foot Notation library.
  • Set the needed connection.
    Note: When connector's end reaches connection point, it changes its appearance.

    Developing Entity Relationship Diagram

  • Edit connector's path manually with yellow control dots.

    Developing Entity Relationship Diagram

  • Select all with command+A.
  • Inspectors - Line - remove object lines (stroke).

    Developing Entity Relationship Diagram

  • Export your document to one of graphic formats.

    Developing Entity Relationship Diagram

  • Set the format and quality.

    Developing Entity Relationship Diagram

  • Your file is ready!

    Developing Entity Relationship Diagram

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw PRO vector graphics and diagramming software with the ability to describe successfully a database using the Entity-Relationship model and easy create ERD.

Video. How to Build an Entity Relationship Diagram (2min 05sec)

Use ConceptDraw PRO enhanced with Entity Relationship Diagram (ERD) solution to draw you own ER diagrams using Chen's or Crow's Foot notations.

Use Product:

  • Software Development Tool
  • Diagram Software
  • Technical Diagramming Tool
  • Business Diagramming Tool
  • Professional Business Graphics Tool
  • ERD Diagrams Software
  • Cross Platform Compatibility
  • ConceptDraw PRO native Mac app
  • Easier to use than Microsoft Visio® and more powerful
  • With free support and thousands of templates

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

Entity Relationship Diagram Examples:

Entity Relationship Diagram Example
Entity-Relationship Diagram Using Chen's Notation

Entity Relationship Diagram Example
Entity-Relationship Diagram Using Crow's Foot Notation

Entity Relationship Diagram Example
WordPress File Reference

Entity Relationship Diagram Example
Entity-Relationship Model Diagram

See also samples:

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