Create a Crow’s Foot ER Diagram in Visio Standard 2019
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.

- 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.
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.
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.
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.
Select the Connector tool and draw a line between each pair of related entity boxes.
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.
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.

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.

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.




