Made with
ConceptDraw
DIAGRAM 14

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.






NINE RELATED HOW TO's:

UML Timing Diagram, Design Elements →

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:

Best Flowcharts →

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 Diagram →

When thinking about the process of decision making, it's easy to imagine it as a pyramid. We will look at a three level pyramid model as an example. Operational decisions are first that come to mind, and it's the first level. Tactical and strategic decisions are the second and the third levels. Pyramid (triangle) diagrams are used to show some hierarchical data. Because to the pyramid form of diagram, each diagram slice has a different width. The width of each segment depends on its hierarchical level. The current image illustrates the model of information system types. Most graphically the model can be represented as a three level pyramid. The first level shows a system of transaction processing It is concentrated on operational tasks. The second level is devoted to tactical solutions of the information system management. And at least, the third level addresses strategy and represents the executive information system. This three level pyramid sample is supplied with the ConceptDraw Pyramid Diagrams solution from Marketing area of ConceptDraw Solution Park.Pyramid Diagram *
Picture: Pyramid Diagram
Related Solutions:

Why Flowchart Important to Accounting Information System? →

The Accounting flowchart shows how information flows from source documents through the accounting records. The are based on the accounting procedures or processes. Flowcharts are used to represent accounting information in a system. There are special symbols which are used to create accounting flowcharts. Try conceptdraw flowcharting set of symbols to draw a professional charts.Why Flowchart Important to<br> Accounting Information System? *
Picture: Why Flowchart Important to Accounting Information System?
Related Solution:

The Best Mac Software for Diagramming or Drawing →

ConceptDraw DIAGRAM is a powerful intelligent vector graphics engine that can be used to create basic diagrams including flowcharts, charts, workflows, flowcharts, organizational charts, business diagram, learn business diagrams, flow diagrams.The Best Mac Software <br>for Diagramming or Drawing *
Picture: The Best Mac Software for Diagramming or Drawing
Related Solution:

Database Flowchart Symbols →

Data base diagrams describes inter-related data and tables. It describes roles and relationships, internal and external dependencies, data exchange conventions and structures of knowledge domain. ConceptDraw Software provides number of data-base chart libraries including major 49 vector symbols. Use these DFD flowchart symbol libraries to design data-base structure and models, use it to design data base process-oriented models, or simple data-oriented models. The are special drawing tools for making data flowcharts, data process diagrams, structured analysis diagrams, and information flow diagrams.Database Flowchart Symbols *
Picture: Database Flowchart Symbols
Related Solution:

Timing diagram →

UML Timing Diagram as special form of a sequence diagram is used to explore the behaviours of objects throughout a given period of time.Timing diagram *
Picture: Timing diagram
Related Solution:

Sales Process Map →

You need create a Sales Process Map? Use the ConceptDraw DIAGRAM software which is ideal for the sales process management, marketing and engineering thanks to the powerful Sales Flowcharts solution from the Marketing area of ConceptDraw Solution Park.Sales Process Map *
Picture: Sales Process Map
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:
ConceptDraw
DIAGRAM 14