Made with
ConceptDraw
DIAGRAM 14

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

ER-model is used in a high-level (conceptual) design databases. You can use it to identify key entities and designate connections that can be established between these entities. During database design the ER model is converted into specific database scheme based on the selected data model (relational, objective, networking, or any other).

Crow's Foot notation was proposed by Gordon Everest, originally called Inverted Arrow. According to this notation, the entity is represented by rectangle containing its name. Name of the entity must be unique within this model. In this case, the name of the entity is a name of type, rather than a specific instance of this type. A concrete representative of the entity is called by the entity instance.

The entity attributes are written inside the rectangle depicting entity. Among the attributes is also highlighted the entity key - the set of attributes the values ​​of which in aggregate are unique for each instance of the entity.

Relation is depicted by line which ties two entities involved in a relationship. The plurality of the relationship is indicated graphically by a "plug" on the end of the link. Optionality of a link is marked by a circle at the end of the link.

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.

ERD Crow's Foot library from Entity-Relationship Diagram (ERD) solution contains 17 Crow's Foot notation symbols.

Crow's Foot notation symbols

Example 1. Crow's Foot notation symbols

The shapes which include circles, bars, and symbols, indicate various possibilities. A single bar at Crows foot notation indicates one, a double bar indicates one and only one, a circle indicates zero, and a crow's foot indicates many.

Entity Relationship Diagrams (ERD) illustrates the logical structure of databases. The vector graphic diagrams produced when using the ConceptDraw ERD solution can be successfully used in whitepapers, presentations, datasheets, posters, or any technical materials.

Entity Relationship Diagram - ERD - Software for Design  <br>Crows Foot ER Diagrams *

Example 2. Entity Relationship Diagram Software
Design Elements — Crow's Foot (Windows, Macintosh).

The samples you see on this page were created in ConceptDraw DIAGRAM software in macOS and Windows using the Entity-Relationship Diagram (ERD) solution and show the ER Diagrams created with Crow's Foot notation. An experienced user spent 10 minutes creating each of these samples.

Use the Entity-Relationship Diagram (ERD) Solution for ConceptDraw DIAGRAM to create quick and easy your own Entity-Relationship Diagrams using the Crow's Foot and Chen's notations.

Entity-Relationship Diagram (ERD) solution

Example 3. Entity-Relationship (ERD) Diagram Solution

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 users.






TEN RELATED HOW TO's:

How to Prepare Learning Presentations for Training →

Interactive tool helps you find the appropriate response to social media mentions quickly.How to Prepare Learning Presentations for Training *
Picture: How to Prepare Learning Presentations for Training
Related Solutions:

Business Process Modeling Software for Mac →

ConceptDraw DIAGRAM - business process modeling software for mac offers the Business Process Diagram Solution with powerful tools to help you easy represent the business processes and create the business process diagrams based on BPMN 1.2 and BPMN 2.0 standards that allows to create of both simple and complex (nested) models of processes. There are 16 BPMN 1.2 and BPMN 2.0 stencil libraries containing 230 vector objects: Rapid Draw library, Connections library, Gateways and Artifacts libraries, Data library, Gateways library, Choreographies library, Conversations library, Activities libraries, Events libraries, Expanded Objects libraries, Swim lanes libraries.Business Process Modeling Software for Mac *
Picture: Business Process Modeling Software for Mac
Related Solution:

BCG Matrix →

The growth–share matrix (BCG Matrix) was created by Bruce D. Henderson for the Boston Consulting Group in 1970 to help corporations to analyze their business units and to help the company allocate resources. How is it easy design the BCG Matrices in ConceptDraw DIAGRAM diagramming and vector drawing software supplied with unique Matrices Solution from the Marketing Area of ConceptDraw Solution Park.BCG Matrix *
Picture: BCG Matrix
Related Solution:

UML Diagram Types List →

Two types of diagrams are used in UML: Structure Diagrams and Behavior Diagrams. Behavior Diagrams represent the processes proceeding in a modeled environment. Structure Diagrams represent the elements that compose the system.UML Diagram Types List *
Picture: UML Diagram Types List
Related Solution:

Competitor Analysis →

Competitor analysis is a first and obligatory step in elaboration the proper corporate marketing strategy and creating sustainable competitive advantage. Use powerful opportunities of numerous solutions from ConceptDraw Solution Park for designing illustrative diagrams, charts, matrices which are necessary for effective competitor analysis.Competitor Analysis
Picture: Competitor Analysis
Related Solution:

IDEF0 standard with ConceptDraw DIAGRAM →

The activity of any organization is more or less branchy network of processes. The description of these processes is a hard technical task which requires definite methodology and standards. According to the IDEF0 standard any process can be described in the form of a block (Activity Box) which has inputs and outputs. The process consists in transformation of inputs into outputs under the influence of the management and in the presence of necessary resources. Outputs of the given process later on can be either inputs for the next process or resources, or management means.IDEF0 standard with ConceptDraw DIAGRAM *
Picture: IDEF0 standard with ConceptDraw DIAGRAM
Related Solution:

Sentence Diagrammer →

Sentence a grammatical unit of several words, and provides a narrative, question, comment, etc. It begins with a capital letter and ends with proper punctuation. Sentence diagramming allows you to visually present the sentence part function, which helps you build right sentences. Language Learning solution offers the Sentence Diagrams Library with set of vector stencils for drawing various Sentence Diagrams, for visualizing grammatical structures that will assist you in language learning and construction of grammatically correct sentences. ConceptDraw DIAGRAM diagramming software extended with Language Learning solution from the Science and Education area provides the powerful sentence diagraming tools.Sentence Diagrammer *
Picture: Sentence Diagrammer
Related Solution:

Ice Hockey Rink Diagram →

The main advantage of using ConceptDraw Ice Hockey Solution is that you don't need to draw objects manually, you have all you need in libraries, templates and samples. This allows you produce professional ice hockey diagrams as quickly as possible, and then post them to blog or social media, print or present on a large screen.Ice Hockey Rink Diagram
Picture: Ice Hockey Rink Diagram
Related Solution:

How to Create a Pie Chart →

Create a Pie Chart with ConceptDraw software quickly and easily. The simple tutorial helps you learn how to create a pie chart.How to Create a Pie Chart *
Picture: How to Create a Pie Chart
Related Solution:
ConceptDraw
DIAGRAM 14