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:
Chemistry solution provides the Chemical Drawings Library with large quantity of vector chemistry equation symbols to help you create professional looking chemistry diagrams quick and easy.Chemistry Equation Symbols *
Picture: Chemistry Equation Symbols
Related Solution:
Astronomy solution provides the Stars and Planets library with wide variety of solar system symbols. You can find here vector objects of solar system, of stars and planets of the universe. To quickly draw any astronomy illustration: create new document and simply drag the needed solar system symbols from the Stars and Planets library, arrange them and add the text. You can also use the predesigned templates and samples from the ConceptDraw STORE as the base for your own sun solar system illustrations, astronomy and astrology drawings.Solar System Symbols *
Picture: Solar System Symbols
Related Solution:
Event-Driven Process Chain Diagrams for improvement throughout an organisation. ConceptDraw DIAGRAM - software that reduces the time needed to create a business process model.Graphical Symbols to use in EPC diagrams *
Picture: Graphical Symbols to use in EPC diagrams
Related Solution:
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the Computer and Networks solution from Computer and Networks area of ConceptDraw Solution Park. This sample shows the Point-to-point network topology. Network topology is the topological structure of the computer network. Point-to-point network topology is a simple topology that displays the network of exactly two hosts (computers, servers, switches or routers) connected with a cable. Point-to-point topology is widely used in the computer networking and computer architecture.Point to Point Network Topology
Picture: Point to Point Network Topology
Related Solution:
A waterfall model describes software development process as a sequence of phases that flow downwards. SSADM is one of the implementations of waterfall method. It’s easier to learn about structured systems analysis and design method (SSADM) with ConceptDraw DIAGRAM because this software has appropriate tools for creating data flow diagrams. You can use all the three main techniques of SSADM method with special tools and predesigned templates. This data flow diagram illustrates the Structured Systems Analysis and Design Method. This method method considers analysis, projecting and documenting of information systems. Data flow models are the most important elements of SSADM and data flow diagrams are usually used for their description. It includes the analysis and description of a system as well as visualization of possible issues.Structured Systems Analysis and Design Method
Picture: Structured Systems Analysis and Design Method. SSADM with ConceptDraw DIAGRAM
Related Solution:
Entity Relationship Diagram (ERD) is an acknowledged method to visualize the logical structure of databases. Using special symbols described in ERD notations you can depict a database of any complexity. The vector graphic ER diagrams produced when using ConceptDraw ERD solution can be used in whitepapers, presentations, datasheets, posters, or any technical materials.What is Entity-Relationship Diagram *
Picture: What is Entity-Relationship Diagram
Related Solution:
Any information system receives data flows from external sources. In order to visualize them there is a list of data flow diagram symbols that describes how the system components cooperate. If you want to create a data flow diagram, ConceptDraw DIAGRAM Solution Park has DFD Library that contains both Yourdon and Gane-Sarson notations. This figure shows the content of vector libraries, delivered with ConceptDraw solution for data flow diagram (DFD). There are three libraries composed from about 50 vector objects used to make data flow diagrams. They include a complete set of objects utilized by Yourdon-Coad and Gane-Sarson notations - two primary notations that are apply for data flow diagramming. Also, one can discover additional "Data flow diagram (DFD)" library that provides a data flow diagram elements for designing level 1 and context-level data flow diagrams.Data Flow Diagram Symbols. DFD Library *
Picture: Data Flow Diagram Symbols. DFD Library
Related Solution:
The popularity of Block Diagrams grows day by day. The existence of powerful software for their design is an excellent news! ConceptDraw DIAGRAM Block Diagram Software offers the Block Diagrams Solution from the Diagrams Area.Block Diagram Software *
Picture: Block Diagram Software
Related Solution:
Acquaintance with flowcharting starts from getting into basic terms. First of all, flowchart definition is quite clear – a flowchart is a graphical representation of a process or an algorithm made of special symbols. Secondly, flowcharting is an irreplaceable tool for IT specialists, project managers, and anyone who wants a clear understanding of any imaginable process.Flowchart Definition
Picture: Flowchart Definition: A Complete Guide
Related Solution:
There are a lot of structured analysis and design technique methodologies used to describe systems and data sources. To visualize data structures, data flow diagrams can be used for various purposes in the area of software engineering. Nowadays these diagrams are also used in the area of business analysis and information system analysis. This data flow diagram depicts an account processing system of a typical account department of a small manufacturing enterprise. It shows the data transmission through the order processing to shipping verification. This data flow diagram was created according to standard of Yourdon and Coad notation. The vector graphic objects of Yourdon/Coad notation symbols was delivered by ConceptDraw Data Flow Diagrams solution. The current DFD can be employed as an example of a business process model, representing the set of business events and interactions commonly engaged in a accounts receivable process.Data Flow Diagrams
Picture: Data Flow Diagrams
Related Solution:
ConceptDraw
DIAGRAM 18