Made with
ConceptDraw
DIAGRAM 18

Components of ER Diagram

Entity-Relationship model making possibility to describe a database using components of ER Diagram in which in the tables data can be the point to data in other tables - for instance, your entry in the database could point to several entries.

ConceptDraw DIAGRAM is a powerful professional software extended with Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park. It gives the ability to draw ER diagram (ERD) for visual describing database using the Crow’s Foot notation icons and Chen’s notation icons.

Components of ER Diagram *

Example 1. Components of ER Diagram, Crow's Foot and Chen's notations

The Chen's ERD notation is still used and is considered to present a more detailed way of representing entities and relationships.

Most other notation systems are adaptations, or use part of these original styles. Here is a brief list of some of other standards that have been developed:

  • Bachman notation
  • Barker’s notation (ERDs for Oracle)
  • EXPRESS and EXPRESS-G notation
  • IDEFX1
  • UML class diagrams
  • Merise
  • Object role modeling
  • (Min – Max) notation

ER Diagram, Chen's notation

Example 2. ER Diagram, Chen's notation

ERDs are an invaluable tool for software engineers, particularly since computing capacity, and thus data storage capacity, has markedly increased in recent years. They allow every aspect of database design to be managed, tested and communicated before implementation. Because ERDs have such a broad scope of influence across database activities, it’s imperative the standardized notation can be utilized and interpreted by a wide variety of stakeholders.

ER Diagram, Crow's Foot

Example 3. ER Diagram, Crow's Foot

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM ector graphics and diagramming software with the ability to draw your own entity relationship diagrams using Chen's or Crow's Foot notations applying 2 libraries with numerous predesigned ER icons:

  • ERD, Chen's Notation library
  • ERD, Crow's Foot Notation library

ERD Solution

Example 4. ERD Solution

The samples you see on this page were created in ConceptDraw DIAGRAM using the components of ER diagram from the libraries of Entity-Relationship Diagram (ERD) Solution. An experienced user spent 10-15 minutes creating each of these samples.

Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM to create your own Entity-Relationship Diagrams of any complexity quick, easy and effective.

The Entity-Relationship Diagrams designed with ConceptDraw DIAGRAM are vector graphic documents and are available for reviewing, modifying, converting to a variety of formats (image, HTML, PDF file, MS PowerPoint Presentation, Adobe Flash or MS Visio), printing and send via e-mail in one moment.






TEN RELATED HOW TO's:
Use Case Diagram Taxi Service UML. This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Use Case Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park. This sample shows the work of the taxi service and is used by taxi stations, by airports, in the tourism field and delivery service.About UML *
Picture: About UML
Related Solution:
This sample shows the Data Flow Diagram of the Taxi Service and interactions between the Clients, Operators and Divers, as well as Orders and Reports databases.Taxi Service Data Flow Diagram<br>DFD Example *
Picture: Taxi Service Data Flow DiagramDFD Example
Related Solution:
ConceptDraw DIAGRAM is a world-class diagramming platform that lets you display, communicate, and present dynamically. It′s powerful enough to draw everything from basic flowcharts to complex engineering schematics. Video tutorials on ConceptDraw products. Try it today!Business  Process Mapping — How to Map a Work Process *
Picture: Business Process Mapping — How to Map a Work Process
Related Solutions:
ConceptDraw is your tool for driving social integration and managing change across and streamline social media processes of your organisation.This tool keeps the entire team on the same page allowing you to realize your social media strategy, improve the quality of your answers, and minimize the time it takes to respond.Social Media Response Management DFD Charts - software tools *
Picture: Social Media Response Management DFD Charts - software tools
Related Solution:
The vector stencils library Yourdon and Coad Notation from the solution OOAD contains specific symbols of the Yourdon and Coad notation such as data store symbol, data process symbol, loop symbol for ConceptDraw DIAGRAM software.Yourdon and Coad Diagram
Picture: Yourdon and Coad Diagram
ConceptDraw Arrows10 Technology - This is more than enough versatility to produce professional diagrams more quickly. Professional diagramming software for mac helps you create variety diagrams, graphics, charts, live dashboards and plenty of graphics and pictures for your business and study.Produce Professional Diagrams More Quickly,<br> Easily and Cost Effectively *
Picture: Produce Professional Diagrams More Quickly, Easily and Cost Effectively
A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are UML diagrams and ER-model diagrams. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. An entity relationship diagrams look very simple to a flowcharts. The main difference is the symbols provided by specific ERD notations. There are several models applied in entity-relationship diagrams: conceptual, logical and physical. Creating an entity relationship diagram requires using a specific notation. There are five main components of common ERD notations: Entities, Actions, Attributes, Cardinality and Connections. The two of notations most widely used for creating ERD are Chen notation and Crow foot notation. By the way, the Crow foot notation originates from the Chen notation - it is an adapted version of the Chen notation.ERD Symbols and Meanings
Picture: ERD Symbols and Meanings
Related Solution:
UML Timing Diagram as special form of a sequence diagram are used to explore the behaviors of objects throughout a given period of time. ConceptDraw has 393 vector stencils in the 13 libraries that helps you to start using software for designing your own UML Diagrams. You can use the appropriate stencils of UML notation from UML Timing library.UML Timing Diagram, Design Elements *
Picture: UML Timing Diagram, Design Elements
Related Solution:
Flowcharts visualize a process or algorithm of program as step/operation blocks of various shapes connected with arrowed lines showed the process flow direction. They are used to visualize business or technical processes and software algorithms. Conceptdraw DIAGRAM - feature-rich flowchart software. It will allow you to create professional looking flowcharts.Best Flowcharts *
Picture: Best Flowcharts
Related Solution:
Pyramid diagrams help you visualize information as a triangle divided into horizontal slices. Labelled slices represent a hierarchy. Pyramids are used in marketing presentations to show and analyze hierarchy levels. 3D triangular diagram of DIKW pyramid has 6 levels: measurement, facts, data, information, knowledge, wisdom. The data component include different scattered signs or symbols which are merely useless until these random objective facts are somehow processed. Data is a resource which has to be manipulated or rearranged to get useful. Information can be extracted from a pile of data, it also can be mined from different data storages.Pyramid Diagram *
Picture: Pyramid Diagram
Related Solutions:
ConceptDraw
DIAGRAM 18