Entity-Relationship Diagram (ERD)
with ConceptDraw PRO


ConceptDraw PRO
Discover the World of Visual Communication



Entity-Relationship Diagram (ERD) serves for detailed description of structures and databases. An ERD represents a diagram made up mainly of rectangular blocks (for entities, or data) linked with relationships. The links between the blocks describe relations between these entities. There are three types of relationships:

  • one-to-one,
  • one-to-many,
  • many-to-many.

For example, "driver drives a car". Here, the entity "driver" relates to the entity "car" by means of a one-to-one relationship "drives". One driver drives one car.

ER Diagram: one-to-one

An example of a one-to-many relationship is a sergeant commanding a team of soldiers. Here the entity "sergeant" relates to a number of entities "soldier" by means of a one-to-many relationship.

ER Diagram: one-to-many

Since the many-to-many relationship does not adequately represent the nature of interaction between entities, it is rarely used in diagrams, or is used in diagrams with little detail.

Entities and relationships can both have attributes. Example: a car from the first example has number; the "drives" relation may have quality attributes describing the quality of driving, or time attributes, saying when exactly the driver was driving the car.

ER Diagram: attributes

ERDs are mainly used to describe database structures, though they might be used as diagrams describing a structure of a company, organization, or some business processes.

ConceptDraw PRO extended with Entity-Relationship Diagram (ERD) solution from the Software Development Area allows you to draw very complex and detailed ERD. It has a number of libraries with objects used in diagrams, which are included in relevant templates and samples available from ConceptDraw Solution Browser.

Entity-Relationship Diagram (ERD) Solution in Solution Browser

Example 1. Entity-Relationship Diagram (ERD) Solution in Solution Browser

In actual practice, ERDs employing the method of P.P. Chen are used most. Choose the Chen ERD template in ConceptDraw Solution Browser. A new document will open along with the library with objects necessary to create a diagram. Drag the vector objects representing entities and relationships, and then just connect them between each other in the required order. Use respective library objects to indicate the types of relationships and their attributes.

Example 2. ERD WordPressFile Reference. Chen's Notation

One of advantages of ERD diagram drawn in ConceptDraw PRO is that when you move entities on the diagram, they stay connected and you don't need to move relationships too.

Apart from building a diagram manually, ConceptDraw has a built-in tool for drawing an ERD automatically, from a database.

Entity Relationship Model Diagram. Crow's Foot Notation

Example 3. Entity Relationship Model Diagram. Crow's Foot Notation

The samples you see on this page were created in ConceptDraw PRO using the Entity-Relationship Diagram (ERD) Solution and demonstrate some of solution's capabilities and the results you can achieve.

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 XML, and many other graphic formats) from the ConceptDraw Solution Browser v3. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw PRO v9.5 or later users.











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


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