Entity-Relationship Diagram (ERD)
with ConceptDraw DIAGRAM
Entity-Relationship Diagram (ERD) serves for detailed description of structures and databases. An ERD represents a diagram made up mainly of rectangular blocks (for entities, or data) linked with relationships. The links between the blocks describe relations between these entities. There are three types of relationships:
- one-to-one,
- one-to-many,
- many-to-many.
For example, "driver drives a car". Here, the entity "driver" relates to the entity "car" by means of a one-to-one relationship "drives". One driver drives one car.
An example of a one-to-many relationship is a sergeant commanding a team of soldiers. Here the entity "sergeant" relates to a number of entities "soldier" by means of a one-to-many relationship.
Since the many-to-many relationship does not adequately represent the nature of interaction between entities, it is rarely used in diagrams, or is used in diagrams with little detail.
Entities and relationships can both have attributes. Example: a car from the first example has number; the "drives" relation may have quality attributes describing the quality of driving, or time attributes, saying when exactly the driver was driving the car.
ERDs are mainly used to describe database structures, though they might be used as diagrams describing a structure of a company, organization, or some business processes.
ConceptDraw DIAGRAM extended with Entity-Relationship Diagram (ERD) solution from the Software Development Area allows you to draw very complex and detailed ERD. It has a number of libraries with objects used in diagrams, which are included in relevant templates and samples available from ConceptDraw STORE.
Example 1. Entity-Relationship Diagram (ERD) Solution in ConceptDraw STORE
In actual practice, ERDs employing the method of P.P. Chen are used most. Choose the Chen ERD template in ConceptDraw STORE. A new document will open along with the library with objects necessary to create a diagram. Drag the vector objects representing entities and relationships, and then just connect them between each other in the required order. Use respective library objects to indicate the types of relationships and their attributes.
Example 2. ERD WordPressFile Reference. Chen's Notation
One of advantages of ERD diagram drawn in ConceptDraw DIAGRAM is that when you move entities on the diagram, they stay connected and you don't need to move relationships too.
Apart from building a diagram manually, ConceptDraw has a built-in tool for drawing an ERD automatically, from a database.
Example 3. Entity Relationship Model Diagram. Crow's Foot Notation
The samples you see on this page were created in ConceptDraw DIAGRAM using the Entity-Relationship Diagram (ERD) Solution and demonstrate some of solution's capabilities and the results you can achieve.
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:
The Total Quality Management Diagram solution helps your organization visualize business and industrial processes. Create Total Quality Management diagrams for business process with ConceptDraw software.
Picture: A Study of the Business Value of Total Quality Management
Related Solution:
SIPOC is a tool that summarizes the inputs and outputs of one or more processes in table form.
You need to draw professional looking SIPOC Diagram quick and easy? Pay please your attention on ConceptDraw DIAGRAM diagramming and vector drawing software. Extended with Business Process Mapping Solution from the Business Processes Area of ConceptDraw Solution Park, it suits ideal for this.
Picture: SIPOC Diagram
Related Solution:
This sample was created in ConceptDraw DIAGRAM diagramming and vector drawing software using the UML Sequence Diagram library of the Rapid UML Solution from the Software Development area of ConceptDraw Solution Park.
This sample shows the interactions of the customer with the system and is used at the registration on the sites.
Picture: UML Sequence Diagram Example. SVG Vectored UML Diagrams Tools
Related Solution:
While developing software, it is very important to have a visual model, because it helps to represent the logic and the architecture of an application. Experienced engineers use UML diagrams to denote relationships between classes and their instances. UML is a general language for a set of diagrams like deployment diagrams, object diagrams or use case diagrams.
This diagram represents UML class diagram used for a software system development using an object-oriented method. Class diagrams are categorized as static structure diagrams that depict the physical structure of a system. Class diagram divides a software system's structure into "classes". Classes are defined by the methods and variables of objects. UML Class diagram is used to depict relationships and source code dependencies between objects.
Picture: UML Diagram
Related Solution:
Data processing can be very complex sometimes. If you are interested in facilitating your work with data, it’s time to learn how to draw flowcharts with special software or using just a piece of paper. The list of flowchart basic symbols includes rectangles, diamond, ellipses etc. and is used to represent processes, actions, decisions or data processing.
A well-done flowchart bring the clearness of the sequence of a process stages. There are number of symbols that can be used in flow charts to show various sorts of steps. The basic flowchart can be created using a few of them: Process, Decision, Start/Finish. A basic element of a flowchart represents a simple action and looks like a box, that contains a description of the action. The depicting of actions sequence is made with arrows between corresponding action boxes, as you can see on the sample diagram. Also it shows the symbols for flowchart start and finish steps. ConceptDraw Flowcharts solution provides the ability to build basic flow charts as well as the ones of any size and complexity with a minimum of actions.
Picture: How to Draw a Flowchart: Step-by-Step Guide
Related Solution:
Working with disordered network data can be quite exhausting. Sometimes it's necessary to find a network diagramming software to design Cisco network diagrams that would be easy to use and would be able to export diagrams to various graphic formats. ConceptDraw DIAGRAM is a great diagramming tool that is able to perform all these tasks easily.
This vector library represents a set of 26 objects depicting the manufacturer - standard equipment of Cisco switches and hubs. This is only a small part of the vector graphic objects of Cisco equipment that comprise the Cisco Network Diagrams solution. In full the ConceptDraw Cisco Network Diagrams solution has 15 libraries, containing more then 500 objects to create a Cisco network diagrams. They can be used by IT specialists and corporative IT divisions, system and network administrators to make the visual documentation of Cisco networks topology.
Picture: Network Diagramming Software for Design. Cisco Network Diagrams
Related Solution:
The vector stencils library Rail transport contains clipart of railway transport for ConceptDraw DIAGRAM diagramming and vector drawing software.
Use it to draw illustrations of trains and transportation of passengers and goods by railroads.
Picture: Rail transport - Design elements
Related Solution:
Create value stream maps - for value stream analysis and value stream management, material and information flow mapping, using our quick start templates included with ConceptDraw.
Picture: Value-Stream Mapping for Manufacturing
Related Solution:
Network Diagrams visualize schematically the computer networks topology, equipment nodes and different types of their logical and physical connections. They are widely used by IT professionals to visually document the topology and design of computer and telecommunication networks.
Picture: Computer Networking Tools List
Related Solution:
ConceptDraw MINDMAP is ready to provide you with mind mapping tool which can serve as comprehensive productivity tool for your business.
Picture: Think. Act. Accomplish.
