Made with
ConceptDraw
DIAGRAM 14

Developing Entity Relationship Diagrams

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

Developing Entity Relationship Diagrams *

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 DIAGRAM 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 DIAGRAM ector 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 DIAGRAM enhanced with Entity Relationship Diagram (ERD) solution to draw you own ER diagrams using Chen's or Crow's Foot notations.







TEN RELATED HOW TO's:

UML Notation →

There are many ways to track the system in a critical situation. To model a system behavior, uml notation is widely used. Usually, an UML diagram consists of elements such as actor and a case. This diagram represents the structure of UML notations. Unified Modeling Language (UML) is used in software engineering to depict graphically the software modeling process. UM Language uses graphic notations for developing models of object-oriented systems. These notations displays requirements, sub-systems, logical and physical elements, etc. We created this diagram using ConceptDraw DIAGRAM reinforced with Rapid UML solution. It can be helpful for students on software engineering, when learning UML.UML Notation *
Picture: UML Notation
Related Solution:

Cross-Functional Flowchart →

There are many tools to manage a process or to illustrate an algorithm or a workflow. Flowcharting is one of those tools. However, it may be difficult to show complex processes that require multiple attributes or several people in a simple flowchart, so a cross-functional flowchart would be a solution for that situation. To create such flowchart, group processes and steps to labeled rows or columns, and divide those groups with horizontal or vertical parallel lines. It is worth mentioning that there are different types of cross-functional flowcharts, like opportunity or deployment flowchart. This diagram shows a cross-functional flowchart that was made for a trading process. It contains 14 processes, distributed through 5 lines depicting the participants who interact with the process. Also there are connectors that show the data flow of information between processes. The cross-functional flowchart displays a detailed model of the trading process, as well as all participants in the process and how they interact with each other. The lines in the flowchart indicates the position, department and role of the trading process participants.Cross-Functional Flowchart
Picture: Cross-Functional Flowchart
Related Solution:

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.What is Entity-Relationship Diagram *
Picture: What is Entity-Relationship Diagram
Related Solution:

Flow Diagram Software →

Diagrams are a very important part of modern life. With the help of flow diagram software, a lot of companies can promote their ideas at the market. Its usefulness is totally doubtless. This is a flow chart of the invoice payment flow. This flowchart details decrypts all stages of the process of obtaining and paying bills. It is a description of the universal process - such steps performs accounting departments of almost any organization. Since every business no matter what it does is a consumer of some goods or services. The given flow chart was made using ConceptDraw DIAGRAM software and the Diagrams solution for making flowcharts of any kind.Flow Diagram Software *
Picture: Flow Diagram Software
Related Solution:

Data Flow Diagrams →

Software development flourishes nowadays. Students have tons of educational information and courses that would fit every taste. And it's no secret that knowing how to draw data flow diagrams is a useful skill for a future software architect. The diagrams help a lot in understanding how to storage data effectively and how data processes within a system. This data flow diagram represents the model of small traditional production enterprise. It was created using Yourdon and Coad notation. The data flow diagram include four main objects: entity, process, data store and data flow. Yourdon and Coad notation uses circles to depict processes and parallel lines to represent data stores. Dataflows are shown as arrowed lines. They are labeled with the description of the data that move through them. Dataflow's role is to deliver the pieces of information. A process's function is to transform. the input data flow into output data flow. ConceptDraw Data Flow Diagrams solution contains the data flow diagram symbols of both Yourdon-Coad and Gane-Sarson notations and a set of handy templates to get started with DFD.Data Flow Diagrams *
Picture: Data Flow Diagrams
Related Solution:

ER Diagram Programs for Mac →

ConceptDraw DIAGRAM compatible Mac OS X software extended with powerful Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is one of the famous ER Diagram Programs for Mac. It gives the perfect ability to draw ER diagrams for visually describing databases with Chen's and Crow's Foot notation icons.ER Diagram Programs for Mac *
Picture: ER Diagram Programs for Mac
Related Solution:

What's the best ERD tool for the Mac? →

What's the best ERD tool for the Mac? ConceptDraw DIAGRAM on Mac OS X supplied with Entity-Relationship Diagram (ERD) Solution from the Software Development Area for ConceptDraw Solution Park is the best ERD tool! This solution offers for ConceptDraw users so powerful drawing tools, libraries with numerous ERD objects, which will help design ER diagrams of any complexity and any design you want.What
Picture: What's the best ERD tool for the Mac?
Related Solution:

Notation & Symbols for ERD →

The ER diagram is constructed from the specific ERD graphic elements. There are used 2 types of ERD notations: Chen and Crow's Foot. A complete set of work flow shapes, notation & symbols for ERD, entity relationship stencils, included in Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM software, makes drawing diagrams based on ERD notation as smooth as possible.Notation & Symbols for ERD *
Picture: Notation & Symbols for ERD
Related Solution:

ER Diagram for Cloud Computing →

The entity–relationship (ER) model is a data model that lets graphically represent the information system and depict the relationships between people, objects, concepts, places, and events within a given system. It is also convenient to use the ER Diagram for Cloud computing representation and description the Cloud computing architecture, design them with pleasure using the extensive tools of the Cloud Computing Diagrams solution from the Computers and Network area of ConceptDraw Solution Park.ER Diagram for Cloud Computing *
Picture: ER Diagram for Cloud Computing
Related Solution:

ER Diagram Tool →

Creating of Entity-Relationship Diagrams (ERDs) is a complex process that requires convenient, automated tools. ConceptDraw DIAGRAM diagramming and vector drawing software offers a powerful ER Diagram Tool - the Entity-Relationship Diagram (ERD) Solution from the Software Development Area.ER Diagram Tool *
Picture: ER Diagram Tool
Related Solution:
ConceptDraw
DIAGRAM 14