Made with
ConceptDraw
DIAGRAM 18

What is Entity-Relationship Diagram

A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are:

  • UML diagrams
  • ER-model diagrams.

What is Entity-Relationship Diagram? Entity relationship diagrams look very similar to 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.

What is Entity-Relationship Diagram *

Example 1. What is Entity-Relationship Diagram, Crow's foot notation

Creating an entity relationship diagram requires using a specific notation. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Five main components of common ERD notations are Entities, Actions, Attributes, Cardinality and Connections.

What is Entity-Relationship Diagram, Chen's notation

Example 2. What is Entity-Relationship Diagram, Chen's notation


ERD notations

The two of notations most widely used for creating Entity-Relationship Diagrams are:

  • Chen's notation
  • Crow's foot notation.

Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. By the way, the Crow's foot notation originates from the Chen's notation - it is an adapted version of the Chen's notation.

Professional ERD drawing implies knowing of ERD symbols and meanings. Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park includes icons advocated by Chen's and Crow’s Foot notation that can be used when describing a database.

ERD Libraries

Example 3. ERD Libraries

In Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM all entity relationship diagram symbols and meaning, work flow shapes, and entity relationship stencils have easy to understand labels helps you while building Entity Relationship Diagram.

Entity-Relationship Diagram Symbols

Example 4. Entity-Relationship Diagram Symbols

The Entity-Relationship Diagram (ERD) solution from ConceptDraw Solution Park extends ConceptDraw DIAGRAM ector graphics and diagramming software with the ability to describe a database using the Entity-Relationship model. Use it to draw with pleasure your own professional-looking Entity-Relationship Diagrams using Chen's or Crow's foot notations.

All source documents are vector graphic documents. They are available for reviewing, modifying, or converting to a variety of formats (PDF file, MS PowerPoint, MS Visio, and many other graphic formats) from the ConceptDraw STORE. The Entity-Relationship Diagram (ERD) Solution is available for all ConceptDraw DIAGRAM or later users.






TEN RELATED HOW TO's:
To maintain big and complex mechanical systems, you need an appropriate education and tools. It’s needless to say that mechanical drawing is important part of any industrial project. There are a lot of standard symbols depicting valves, pumps, motors, etc. This drawing illustrates the content of the Fluid Power Equipment library provided by the ConceptDraw Mechanical Engineering solution. The solution is composed from the 8 libraries, containing about 500 elements related to mechanical engineering visualization. it will be helpful for drawing various schemes, charts and blueprints of pneumatic, and hydraulic equipment or other drawing related mechanical engineering. All drawings can be freely resized without loss of quality due to the vector graphics components of its facilities.Mechanical Drawing Symbols
Picture:
Mechanical Drawing Symbols F.A.Q.
How to Use Mechanical Engineering Design Software
Related Solution:
Computer networks nowadays are spread all across the world. The large number of parameters, such as geographic scale or communication protocols, can divide networks. One of the most common types of networks is called local area network (LAN). It convenient to represent network examples by means of diagrams. This local area network (LAN) diagram provides an easy way to see the way the devices in a local network are interacted. The diagram uses a library containing specific symbols to represent network equipment , media and the end-user devices such as computers (PC, mac, laptop) , network printer, hubs, server and finally a modem. There are two types of network topologies: physical and logical. The current diagram represents precisely a physical type of LAN topology because it refers to the physical layout of a local network equipment.Local area network (LAN) diagram
Picture:
What is a Local Area Network?
Examples of LAN Diagrams
Related Solution:
UML Deployment diagram describes the hardware used in system implementations and the execution environments and artifacts deployed on the hardware. 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 Deployment library.UML Deployment Diagram. Design Elements *
Picture: UML Deployment Diagram. Design Elements
Related Solution:
A concept map is a way of representing relationships between ideas, images, or words. How to draw a Concept Map quick, easy and effective? ConceptDraw DIAGRAM offers the unique Concept Maps Solution from the Diagrams Area that will help you!Concept Map *
Picture: Concept Map
Related Solution:
ConceptDraw helps you to start designing your own UML Collaboration Diagrams with examples and templates.Diagramming Software for Design <br>UML  Collaboration Diagrams *
Picture: Diagramming Software for Design UML Collaboration Diagrams
ConceptDraw DIAGRAM diagramming and vector drawing software extended with Physics solution from the Science and Education area is a powerful software for creating various physics diagrams. Physics solution provides all tools that you can need for physics diagrams designing. It includes 3 libraries with predesigned vector physics symbols: Optics Library, Mechanics Library and Nuclear Physics Library.Physics Symbols
Picture: Physics Symbols
Related Solution:
ConceptDraw DIAGRAM extended with IDEF Business Process Diagrams solution from the Business Processes area of ConceptDraw Solution Park is an ideal software for effective database design and drawing IDEF diagrams visually representing all steps of database design process.Database Design *
Picture: Database Design
Related Solution:
The ConceptDraw vector stencils library Cisco Security contains 16 symbols of security devices and equipment for drawing the computer network diagrams using the ConceptDraw DIAGRAM diagramming and vector drawing software.Cisco Security. <br>Cisco icons, shapes, stencils and symbols *
Picture: Cisco Security. Cisco icons, shapes, stencils and symbols
Related Solution:
Sometimes, when it is difficult to create a functional space plan or to rearrange existing one, the art of interior design comes in. It doesn't matter, if you need a cozy bedroom or an office layout plan, you should use appropriate tools to make your design great. While making a floor plan of a new office it could be useful to apply some design elements such as furniture and office equipment. This diagram presents an office furniture objects that can be used for office interior design planning, or making office furniture and equipment layouts. This vector stencils library is supplied with ConceptDraw Office Layout Plans solution. It contains more then 30 vector objects of office interior for making office floor plans including an office space layout plans and furniture arrangement.Office Layout Plan Design Element
Picture: Interior Design. Office Layout Plan Design Element
Related Solution:
UML Component for Bank - This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Component Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution ParkUML Component for Bank *
Picture: UML Component for Bank
Related Solution:
ConceptDraw
DIAGRAM 18