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.






TEN RELATED HOW TO's:

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:

Network Diagram Software. LAN Network Diagrams. Physical Office Network Diagrams →

Local area network connects computers and other network appliances within an area, such as office building or a campus. It can be difficult to provide such network without a predesigned plan. For these purposes you can use network diagram software, which helps you to create LAN network diagrams and office network diagrams quickly and effortless. This will speed up your work and you can save the diagram for the future network improvements. The following diagram illustrates a network topology of the small office. LAN configuration has a star topology. The local network joins 8 computers among which are several desktop PCs, laptop, two iMacs and iBook. The end-point devices are divided into three groups. Each group is connected to its hub. There is a network printer and a modem, which are interconnected with other devices through a network server. Each computer on the LAN can access the server through a corresponding hub.LAN Network Diagram
Picture: Network Diagram Software. LAN Network Diagrams. Physical Office Network Diagrams
Related Solution:

Stakeholder Onion Diagram Template →

For depicting the onion model are actively used Stakeholder Onion Diagrams. The ConceptDraw DIAGRAM diagramming and vector drawing software extended with Stakeholder Onion Diagrams Solution from the Management Area of ConceptDraw Solution Park offers the number of useful tools and Stakeholder Onion Diagram template for their easy design.Stakeholder Onion Diagram Template *
Picture: Stakeholder Onion Diagram Template
Related Solution:

Sales Process Flowchart. Flowchart Examples →

Process mapping helps with sharing business results and reorganizing workflow. In almost every case, after creating a sales process flowchart the steps that are redundant become obvious for a manager. It's easy to find a flowchart examples that will help in developing one for your business. This sales process flowchart consists of a sequence of steps that represent a simple sale process. Each step is shown graphically by a rectangle representing processing steps or an activity, or a diamond representing a decision. These rectangles are linked by arrows, that indicate the direction of the sales workflow. ConceptDraw Sales Flowcharts solution delivers a the full set of classical flowchart notation symbols, along with sales-related icons and pictograms.Sales Process Flowchart. <br>Flowchart Examples *
Picture: Sales Process Flowchart. Flowchart Examples
Related Solutions:

Flow Chart Symbols →

ConceptDraw DIAGRAM software extended with Flowcharts Solution from the "Diagrams" Area is a powerful software that will help you design the flowcharts for any business and technical processes, and software algorithms thanks to the predesigned flow chart symbols. Flowcharts solution offers 2 libraries with large collection of vector flow chart symbols: Flowchart Library, Flowcharts Rapid Draw Library that you can use to create your flowcharts quick and easy. Flowchart Solution is number of diagraming stencils including special set of flow chart symbols such as: terminator, process, decision which indicates a decision points between two or more paths in a flowchart, symbol of delay. Major symbols includes symbol of data, document or multiple documents, subroutine, preparation for processing of documents. Also includes symbols: display, manual input, manual loop, loop limit, stored data,connectors and suming junctions, sort and merge operations, symbols of database and internal storFlow Chart  Symbols
Picture: Flow Chart Symbols
Related Solution:

Types of Flowchart - Overview →

A flowchart is a powerful tool for examining processes. It helps improving processes a lot, as it becomes much easier to communicate between involved people, to identify potential problems and to optimize workflow. There are flowcharts of different shapes, sizes and types of flowchart vary from quite basic process flowcharts to complex program flowcharts. Nevertheless, all these diagrams use the same set of special symbols like arrows to connect blocks, parallelogram to show data receiving or rectangles for showing process steps. Basic flowcharts are used to represent a simple process algorithm. A basic flowchart notation consists of rectangles (business processes), arrows (the flow of information, documents, etc.). The same notation is used in items such as the "decision", which allow you to do the branching. To indicate the start of the entire business process and its termination can be used the "Terminator" element. The advantages of Basic Flowchart are simplicity and clarity. With it you can quickly describe the business process steps. Creating of Basic Flowchart does not require any special knowledge, as easily understand by employees with different levels of education and IQ.Types of Flowchart - Overview *
Picture: Types of Flowchart - Overview
Related Solution:

UML Class Diagram. Design Elements →

UML Class Diagrams describes the structure of a system by showing the system's classes, their attributes, and the relationships among the classes.UML Class Diagram. Design Elements *
Picture: UML Class Diagram. Design Elements
Related Solution:
ConceptDraw
DIAGRAM 14