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.







NINE RELATED HOW TO's:

Network Security Tips →

The Internet is a huge world with unlimited possibilities. But with all its numerous advantages, the Internet also conceals many dangers and security threats, that's why we advise you to follow simple network security tips. ConceptDraw DIAGRAM diagramming and vector drawing software supplied with Network Security Diagrams Solution from the Computer and Networks Area of ConceptDraw Solution Park is an ideal software for easy designing Network Security Diagrams and attractive illustrations with effective network security tips.Network Security Tips *
Picture: Network Security Tips
Related Solution:

Authority Matrix Diagram Software →

You need to draw Authority Matrix Diagram quick and easy? Design it with ConceptDraw DIAGRAM! ConceptDraw DIAGRAM extended with Seven Management and Planning Tools solution from the Management Area is the best Authority Matrix Diagram Software.Authority Matrix Diagram Software *
Picture: Authority Matrix Diagram Software
Related Solution:

Watercraft - Design Elements →

The vector stencils library Watercraft contains clipart of ships, boats, yachts, submarines for ConceptDraw DIAGRAM diagramming and vector drawing software. Use it to draw illustrations of vessels and water transport over a sea, ocean, lake, canal, river.Watercraft - Design Elements *
Picture: Watercraft - Design Elements
Related Solution:

Ice Hockey Offside Diagram →

"Offsides" is a very basic sports term, which can be very hard to explain to a novice. The fundamental concepts in sports can be extremely difficult to convey without a drawing, that's why we included an Offsides Sample in the Hockey solution. Explaining with ConceptDraw in your playbook is easier than ever before!Ice Hockey Offside Diagram *
Picture: Ice Hockey Offside Diagram
Related Solution:

Data Flow Diagram →

There are many ways to define the flow of information within a system. Structured-systems analysis method often uses data flow diagrams to show data flow, data storages and data processing visualization. These diagrams are easy to develop and quite useful. Here is a dataflow diagram presenting an example of the manufacturing process flow. The oval process shapes represent a process that controls data within the current system. The process may produce data or make some action based on data. Data flows are represented by lines. They show the movement of information through the system. The direction of the data flow is depicted by the arrow. The external entities are shown by rectangles. They represent the external entities interacting with the system. The data store objects (unclosed rectangles) are used to show data bases participating in a process flow.Data Flow Diagram *
Picture: Data Flow Diagram
Related Solution:

Healthy Food Recipes →

A healthy lifestyle and a balanced healthy diet are the basis of health, longevity and good feeling. Every day a human must receive with a food the correct proportions of nutrients and vitamins. It is very important to make a proper menu that includes tasty and healthy dishes. ConceptDraw DIAGRAM diagramming and vector drawing software enhanced with Health Food solution from the Food and Beverage area of ConceptDraw Solution Park will help you easy develop, depict and appetizingly illustrate your healthy food recipes.Healthy Food Recipes *
Picture: Healthy Food Recipes
Related Solution:

Flow chart Example. Warehouse Flowchart →

If you want to find a way to understand complex things in minutes, you should try to visualize data. One of the most useful tool for this is creating a flowchart, which is a diagram representing stages of some process in sequential order. There are so many possible uses of flowcharts and you can find tons of flow charts examples and predesigned templates on the Internet. Warehouse flowchart is often used for describing workflow and business process mapping. Using your imagination, you can simplify your job or daily routine with flowcharts. Warehouse flowcharts are used to document product and information flow between sources of supply and consumers. The flowchart provides the staged guidance on how to manage each aspect of warehousing and describes such aspects as receiving of supplies; control of quality; shipment and storage and corresponding document flow. Warehouse flowchart, being actual is a good source of information. It indicates the stepwise way to complete the warehouse and inventory management process flow. Also it can be very useful for an inventory and audit procedures.Warehouse Flowchart
Picture: Flow chart Example. Warehouse Flowchart
Related Solution:

Property Management Examples →

This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Seven Management and Planning Tools Solution from the Business Productivity area of ConceptDraw Solution Park. This sample shows the Property Management matrix, the ideas are ordered in regards to importance and frequency. This matrix gives the ability to turn the theory into quantifiable data.Property Management Examples *
Picture: Property Management Examples
Related Solution:

Create Flow Chart on Mac →

Times when you had difficulties in searching for an appropriate software depending on your OS, had passed. If you still look for a great software to create flowcharts on Mac, here is the answer. ConceptDraw Pro is a great tool for creating diagrams, with tons of samples, libraries and tutorials. Making flowchart diagram is the best way to represent a process as a sequence of steps. Flowcharting provides a simple way of organizing and representing data so that even complex and detailed processes become clear. That is why using a flowchart software tool is proven to be an ideal for structure and share an information on process workflow structure. This flow chart was created to depict the steps of certification process. This flow chart was created using ConceptDraw DIAGRAM software for Apple OS X. The Rapid Draw technology was used to create this flow chart. ConceptDraw DIAGRAM also supports popular Apple OS X features such as Quick Look, Full-Screen Mode, Version Browsing and Autosave. You can export your multi-page diagrams to SVG or graphic formats such as TIFF, JPEG, PNG and PDF.Create Flow Chart on Mac *
Picture: Create Flow Chart on Mac
Related Solution:
ConceptDraw
DIAGRAM 14