This site uses cookies. By continuing to browse the ConceptDraw site you are agreeing to our Use of Site Cookies.

entity-relationship diagram, ER-diagram, database ERD Entity-Relationship Diagram (ERD)

entity-relationship diagram, ER-diagram, database ERD
An Entity-Relationship Diagram (ERD) is a visual presentation of entities and relationships. That type of diagrams is often used in the semi-structured or unstructured data in databases and information systems. At first glance ERD is similar to a flowch
"In software engineering, an entity–relationship model (ER model) is a data model for describing a database in an abstract way.Chen's notation for entity–relationship modeling uses rectangles to represent entity sets, and diamonds to represent relationships appropriate for first-class objects: they can have attributes and relationships of their own. If an entity set participates in a relationship set, they are connected with a line.
Attributes are drawn as ovals and are connected with a line to exactly one entity or relationship set." [Entity–relationship model. Wikipedia]
This sample Chen's ER-diagram illustrates the structure of a typical MMORP game.
"Massively multiplayer online role-playing game (MMORPG) mixes the genres of role-playing video games and Massively multiplayer online games, possibly in the form of web browser-based games, in which a very large number of players interact with one another within a virtual world.
As in all RPGs, players assume the role of a character (often in a fantasy world or science-fiction world) and take control over many of that character's actions. MMORPGs are distinguished from single-player or small multi-player online RPGs by the number of players, and by the game's persistent world (usually hosted by the game's publisher), which continues to exist and evolve while the player is offline and away from the game." [Massively multiplayer online role-playing game. Wikipedia]
This ERD example was redrawn using the ConceptDraw PRO diagramming and vector drawing software from the Wikipedia file: ER Diagram MMORPG.png. [en.wikipedia.org/ wiki/ File:ER_ Diagram_ MMORPG.png]
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/ licenses/ by-sa/ 3.0/ deed.en]
This Chen's ERD example is included in the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.
Chen's ERD
Chen's ERD, weak key attribute, weak entity, relationship, multivalue attribute, key attribute, identifying relationship, entity, derived attribute, attribute,

Entity Relationship Diagram Symbols

Creating an entity-relationship (ER) model is to visually represent the structure of a business database, where data equates to entities (or objects) that are linked by defined relationships expressing dependencies and requirements. By nature it is an abstract visualization, the first step in the design process towards creating a logical and functional database.
ERD symbols used for professional ERD drawing are collected in libraries from the Entity-Relationship Diagram (ERD) solution for ConceptDraw DIAGRAM.
HelpDesk

How To Make Chen ER Diagram

The Chen ERD notation model is a popular standard and is widely used worldwide in database and software design. The entity-relationship model proposed by Dr. Chen is constructed using a natural view of how the real world comprises entities and the relationships that exist with these identified entities. It was designed to leverage the advantages of the three entity-data models (network model, relationship model, entity model). The free Chen Notation solution for ConceptDraw DIAGRAM provides vector stencil libraries with full standardized Chen notation included.

SDL Diagram

Specification and Description Language (SDL) is used for creating the object-oriented diagrams, visualizing the processes of the state machines for the systems of communication, telecommunication, automotive, aviation and medical industries. SDL is a specification language for creating specifications, descriptions of the behavior, data, and inheritance for real-time systems.
This sample shows the SDL Diagram of the process game.

Design Element: Crows Foot for Entity Relationship Diagram - ERD

Creating an ERD requires choosing a specific set of notations that best serve the specific database being designed. ConceptDraw DIAGRAM software extended with Entity-Relationship Diagram (ERD) solution from Software Development area of ConceptDraw Solution Park allows you to draw ER diagrams for depicting a database using the ERD diagram design element Crow's Foot - Crow′s Foot notation icons.

Entity-Relationship Diagram

Entity Relationship Diagram (ERD) is the world-known way to show the logical structure of databases in visual manner. The best software tool for drawing Entity-Relationship Diagram is ConceptDraw DIAGRAM vector graphics software with Entity-Relationship Diagram (ERD) solution from Software Development area which gives the ability to describe a database using the Entity-Relationship model. The vector graphic diagrams produced using this solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.

Entity Relationship Diagram - ERD - Software for Design Crows Foot ER Diagrams

Crow's Foot notation was proposed by Gordon Everest. According to this notation, the entity is represented by rectangle, relation is depicted by line which ties two entities involved in a relationship. Entity-relationship diagrams based on both Chen's and Crow's Foot notations, can be easily drawn using the ConceptDraw DIAGRAM ERD diagrams software tools for design element Crow's Foot and Chen from Entity-Relationship Diagram (ERD) solution.
How to Build an Entity Relationship Diagram (ERD)
How to Build an Entity Relationship Diagram (ERD)

Drawing ER diagrams on a Mac

Drawing ER diagrams on a Mac is smooth and easy when you have a software tool well-suited for professional ERD drawing. ConceptDraw DIAGRAM software for Mac extended with the Entity-Relationship Diagram (ERD) solution is the best tool for drawing ER diagrams on a Mac.

Data Flow Diagrams

ConceptDraw DIAGRAM software enables you to quickly create data flow diagrams that include data storage, external entities, functional transforms, data flows, and control transforms and signals.