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:
Data modelling will help you to study and analyze business processes in your organization for optimization and increase of effectiveness and production.Data modeling with ConceptDraw DIAGRAM  *
Picture: Data modeling with ConceptDraw DIAGRAM
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Physics solution from the Science and Education area is the best for creating: physics diagrams, pictures which describe various physical facts and experiments, illustrations of various electrical, mechanical and optic processes, of any complexity quick and easy.Physics Diagrams *
Picture: Physics Diagrams
Related Solution:
Create flowcharts, organizational charts, bar charts, line graphs, and more with ConceptDraw DIAGRAM.Basic Diagramming *
Picture: Basic Diagramming
Related Solution:
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.UML  Block Diagram *
Picture: UML Block Diagram
Related Solution:
Professional diagramming software for mac helps you create Cause and Effect diagram known as Fishbone diagram or Ishikawa diagram from ConceptDraw Business Solution. You will be offered to use templates, samples or draw your diagram using ConceptDraw Arrows10 TechnologyDraw Diagram on Mac *
Picture: Draw Diagram on Mac
Sales process engineering is a complex and labour-intensive process which requires a lot of time, efforts, and powerful software. We recommend to use the ConceptDraw DIAGRAM software enhanced with Sales Flowcharts solution from the Marketing area of ConceptDraw Solution Park. It gives the possibility to easy illustrate all sales process steps and their results.Sales Process Steps *
Picture: Sales Process Steps
Related Solution:
A Venn diagram, sometimes referred to as a set diagram, is a diagramming style used to show all the possible logical relations between a finite amount of sets. Having ConceptDraw DIAGRAM software one allows anyone who cares for their drawings to look not only nice but also smart and professional.Venn Diagram Examples for Problem Solving. Chomsky Hierarchy
Picture:
Venn Diagram Examples for Problem Solving
Computer Science. Chomsky Hierarchy
Related Solution:
Data Flow Diagram is used to depict the flow of data through the system, where it enters and exits the system, as well as where it is stored. To simplify the process of drawing a data flow diagram (DFD), ConceptDraw DIAGRAM provides a DFD Library - design elements that will help you make your diagram as informative, streamlined and understandable as possible. Data flow diagrams are useful to create a general overview of the system or to document major data flows. Here are the library of symbols used in data flow diagrams (DFD). Data Flow diagrams are graphic means of business process visualization. Any business process may involve the data transfer. It can be easily shown using data flow diagrams. DFDs are used to represent the processing and transformation of data within a business process. One can find out the Vector library of DFD symbols, that is a component of ConceptDraw solution for Data Flow Diagramming and is welcome to use in as addition to the common Conceptdraw DIAGRAM diagramming facilities.DFD Library — Design elements *
Picture: DFD Library — Design elements
Related Solution:
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:
UML for Bank - This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Class Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park.UML  for Bank *
Picture: UML for Bank
Related Solution:
ConceptDraw
DIAGRAM 18