Others

Create a Crow’s Foot ER Diagram in Visio Standard 2019

Huda QurayshiHuda Qurayshi Nov 18, 2026 868 views

Question details

The user needs to create a Crow’s Foot entity relationship diagram in Visio Standard without dedicated entity, attribute, and primary key shapes.

Create a Crow’s Foot ER Diagram in Visio Standard 2019
Product
Microsoft Visio Standard 2019
Device & OS
not provided
Scenario
The user wants to represent database entities and their relationships using Crow’s Foot notation.
Observed behavior
Dedicated shapes for entities, attributes, and primary keys are not available in the user's Visio Standard diagram.
Before you start

Identify the entities, their attributes and primary keys, and the cardinality of each relationship. Open a blank diagram in Visio Standard 2019 so you can build the notation with basic shapes and connectors.

Solution 1Recommended

Build the ER diagram with basic shapes and Crow’s Foot line endings

Use this workaround in Visio Standard when the dedicated Crow’s Foot template is unavailable.

Represent entities with boxes and list their attributes as text inside them. Relationship symbols and labels may need to be added manually.

1
Add entity boxes

In the blank diagram, drag rectangle shapes from the Shapes pane onto the page. Add an entity name and its attributes inside each box, marking primary keys with a label such as PK.

2
Connect related entities

Select the Connector tool and draw a line between each pair of related entity boxes.

3
Set the Crow’s Foot ending

Select a relationship line, then open Home > Shape Styles > Line > Line Options. Under line formatting, choose the Crow’s Foot symbol for End Arrow Type; it may be listed as option 27.

4
Adjust and label relationships

Increase End Arrow Size if the symbol is too small. Add text or basic shapes near the connector ends to indicate any other cardinality or optionality markers your diagram requires.

Build the ER diagram with basic shapes and Crow’s Foot line endings
Template availability: The dedicated Crow’s Foot database notation template is available in Visio Professional. The Standard workaround uses manually formatted shapes and connectors.
Free Microsoft Office alternative

Document database designs with WPS Office

WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make it easy to move existing work, although it does not fix Visio or replace its dedicated Crow’s Foot template.

Document entities, attributes, and primary keys in WPS Writer or Spreadsheets.Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTX.Use a familiar interface for a smoother transition from Microsoft Office.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Does Visio Standard 2019 include the dedicated Crow’s Foot template?

The dedicated Crow’s Foot database notation template is available in Visio Professional. In Visio Standard, you can build a diagram manually with rectangles, text, and formatted connectors.

Where can I find the Crow’s Foot line ending?

Select a connector and open Home > Shape Styles > Line > Line Options. Choose the Crow’s Foot symbol under End Arrow Type; it may appear as option 27.

How do I show a primary key without a dedicated shape?

Add the attribute as text inside its entity rectangle and label it PK. Use the same convention consistently throughout the diagram.

What if the Crow’s Foot symbol is too small?

Select the connector, open Line Options, and increase End Arrow Size until the symbol is readable.