Made with
ConceptDraw
DIAGRAM 14

Entity-Relationship Diagram (ERD)
with ConceptDraw DIAGRAM

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 DIAGRAM 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 STORE.

Entity-Relationship Diagram (ERD) Solution in ConceptDraw STORE

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

In actual practice, ERDs employing the method of P.P. Chen are used most. Choose the Chen ERD template in ConceptDraw STORE. 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.

Entity-Relationship Diagram (ERD) <br>with ConceptDraw DIAGRAM  *

Example 2. ERD WordPressFile Reference. Chen's Notation

One of advantages of ERD diagram drawn in ConceptDraw DIAGRAM 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 DIAGRAM 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, and many other graphic formats) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.





NINE RELATED HOW TO's:

Fault Tree Diagram →

ConceptDraw DIAGRAM diagramming and vector drawing software offers the Fault Tree Analysis Diagrams Solution from the Industrial Engineering Area of ConceptDraw Solution Park for quick and easy creating the Fault Tree Diagram of any degree of detailing.Fault Tree Diagram *
Picture: Fault Tree Diagram
Related Solution:

Flowchart Program Mac →

ConceptDraw software has been developed for drawing any type of flowchart. Use RapidDraw - thi is flowchart maker technology for adding new objects to a flowchart quickly. This is technology of fast drawing technique focused on making great-looking flowcharts quickly. To get started using it download flowchart maker ConceptDraw DIAGRAM.Flowchart Program Mac *
Picture: Flowchart Program Mac
Related Solution:

Flowchart Examples and Templates →

Visual information is easier to perceive. You can teach even a child to make diagrams with a good flowchart example that would be interesting for it. Flowcharts can be fun, it’s not about business processes or programming algorithms. This flowchart shows step by step process of manufacturing of Nixtamal The product which is obtained by processing maize with calcium hydroxide. We must assume that the Aztecs were very fond of this product, if the recipe of its production came to our times. This flow chart was designed using ConceptDraw DIAGRAM with its solution for designing flowcharts of various types, sizes and purposes. ConceptDraw Flowcharts solution consists from the library of flowchart symbols, containing the set vector objects. Also there are a lot of diverse templates and samples of flow charts.Flowchart Examples and Templates *
Picture: Flowchart Examples and Templates
Related Solution:

Chen ERD Diagram →

The vector stencils library Chen ERD from the solution Entity-Relationship Diagrams (ERD) contains specific symbols of the Chen ERD notation including entity symbols and relationship 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.Chen ERD Diagram *
Picture: Chen ERD Diagram
Related Solution:

Basic Diagramming →

Create flowcharts, organizational charts, bar charts, line graphs, and more with ConceptDraw DIAGRAM.Basic Diagramming *
Picture: Basic Diagramming
Related Solution:
ConceptDraw
DIAGRAM 14