Skip to main content
Delivered

Entity Relationship Diagram / Cardinality / Crow's Foot Notation

Related products:Mapping & Diagramming
Dartoumi
Robert Johnson
Kristin
Max Harper
+320
  • Dartoumi
    Dartoumi
  • Robert Johnson
    Robert Johnson
  • Kristin
    Kristin
  • Max Harper
    Max Harper
  • David Duffett
  • lukejones
  • David Coales
  • Ferdl Graser
  • Andrew Parrucci
  • Joshua
  • Gustavo
  • Parzival
  • Dean
  • Jason Walke
  • Areiel Wolanow
  • Matt Keefe
  • Sean Sankey
    Sean Sankey
  • Kevin Hughes-Jones
  • Izelle
  • Ben
  • Theresa Miller
  • Adrian Sibanda
  • Shyama
  • Nicolaas
  • Wilmarie
  • Nick Strutt
  • Sara Ingham
  • Benjamin Kloester
  • Steve Koppelman
  • Sergey Erlikh
    Sergey Erlikh
  • Chris Brewer
  • Christoph Chi
  • Nathan Wright
  • Michael Kribud
  • Noz Urbina
  • Tim Jones
  • Ashish Chalak
  • Tonio Knuth
  • Eddie Burrowes
  • Alex Moon
  • Sam Peck
  • mshbrad
  • Ian West
  • Pedro Henrique Candido
  • bobino
  • Paul Cunningham
  • Neil Venn
  • Vina Sectiana
  • Cliff Rogers
  • Ian Friedman
  • David Watkins
  • lanroth
  • Brian Goad
  • RobertNZ
  • Nickat
  • YVES NICOLE
  • Thom Vaught
  • nsmithuk
  • Melissa Vander Wilt
  • Robert Pragai
  • Andy Fitzgerald
  • tommarshall
  • Matthew Gates
  • Katie Kindred
  • Sam Vilaboa
  • Michelle Sheu
  • Lauren
  • hsawla
  • Zak Kaufman
  • Mark Tsimerman
  • Brendon McCarthy
    Brendon McCarthy
  • Tom Asel
  • Herschel
  • Amy Grollman
  • Carolyn Ripley
  • MJ41
  • Kelvin Kredens
  • Kiwi Konoid
  • Bas Reus
  • jperelli
  • Julia P
  • Ian
  • Noel Tiangco
  • Guillermo González Fernández
  • Peter Nelson
  • Mishal
    Mishal
  • Laurence Gonsalves
    Laurence Gonsalves
  • Dario da Silva
  • Dayo A
  • DDeis
  • Jarrad Raddon
  • Zaur D.
  • Donna Farris
  • Evo
  • Moll_Joy
  • jerome.ahye
  • acreo
  • Robin Wyles
  • Abdulsalam Ayinla
  • isabelle.pochic
    isabelle.pochic
  • Hannes Vorholz
    Hannes Vorholz
  • Mami Sato
  • Lars Bekk
  • Hannah Härtwich
  • Andre Baaij
  • Alberto Fernandez
  • Harold van Garderen
  • Jun Chan
  • Jonathan Bissell
  • Soumyadeep Mandal
    Soumyadeep Mandal
  • Priyabrata Biswal
  • Ilija Vrajich
  • Nic Byron
  • Gio Delgado
  • Dan Mckean
  • TamaraK
  • Angela Desmond
  • The One and Only SK
    The One and Only SK
  • OddHelge Gravalid
  • IT-Helpdesk
  • growingsparks
  • Joseph Charles Van Horn
  • Smoothy ops
  • Mark Kraemer
  • Mike Lines
  • Bart Stavenuiter
  • Maria Tartaglia
  • Abram Simon
  • Jonathan Cantrell
  • Barhilo
  • Bill Muchmore
  • Aditya
  • NickM_NYC
  • Marie-Sofie Karlsson
  • Joe Zuber
  • Kyle Knauer
  • Wataru Fukatsu
  • stucampbell
  • Brian Doidge
  • Sarah Mercado
  • caboh_pm
  • Michal Mesko
  • Tyler Mills
  • Ali@SB
  • acline
  • Annarr
  • avery_h
  • Benedetto Fiorelli
  • Patrick Slattery
  • Ian Janes
  • Ming Lu
  • hajmasif
  • Paul McManus
  • Michal
  • John Machan
  • Donald Nairn
  • Greyson Y
  • Michael Gartner
  • Miles Taylor
  • Chris Sorrows
  • Sebastian Tober
  • Mike Biglan
  • Christine Jonason
  • Devan England
  • Matthew Ryan
  • Greg A
  • Jonathan Watkins
  • Leonardo Silva
  • Utsav Poddar
  • Mike Milligan
  • Andrew Dixie
  • edouardP
  • Jason Kirby
  • Kevin Kinisky
    Kevin Kinisky
  • Vladimir Ivanov
  • Mykhailo Polieshchuk
  • Alexander Bogush
  • han_carol
  • Tom Krueger
  • Stephen J
  • Hayden Braxton
  • Seth Farnsworth
  • sscope-lars
    sscope-lars
  • Matthew Butt
  • Toon van der Werf
  • Christian Rudmann
  • Hendrik Gerard
  • Alexander Harris
  • chromose
  • Oliver Greuter-Wehn
  • RGKD
    RGKD
  • Максим Шиторев
  • Dan Dutrow
  • Brad Johnson
  • Oleksiy Chapay
  • E G
  • bmoll
  • Andrew Weston
  • Andrey Yuritsyn
  • Sherrard Glaittli
  • Grace Lau
  • mbsmith42
  • Marc-Andre L
  • Darren Marshall
  • Richard Longden-Thurgood
  • Brad Allan
  • SJW71
  • Tyler Thomas
  • Thanos Bot
  • Rei
  • Jonty
  • Jorge Gueorguiev Garcia
  • IvanKulaha
  • PEROUX
  • Stephan Keller
  • Steve Woyicki
  • Eduardo Cortes
  • Ryan J.
  • Ralf Oldenhage
  • Evan Armstrong
  • Tim Clarke
  • Apfel_82
  • Jonathan Carvalho
    Jonathan Carvalho
  • businessmanager
  • Bengt Ellison
  • Andrew Davis
  • DaveL
  • Dan Liebeschutz
  • John Borg Jacob
  • chris_mooney
  • Alejandro Coronel
  • Pieter B
  • Paulo Seabra
  • FJ MORENO
  • Klara
  • nattapon
  • joeprivett
  • Andriy Netseplyayev
  • Jeremy Fourna
  • s-fujisawa
  • Kris Van Hoye
  • t-izuno
  • Andrei Gordienkov
  • Aleksei Lebedev
  • Yair Spolter
  • Andrea Kallies
  • Martijn Klomp
  • PedroS00
    PedroS00
  • Remco Perlee
  • John Crawford
  • KeithWhatling
    KeithWhatling
  • Rob Jenkins
  • MarcoR
  • Ben Vigil
  • kdana
  • Dimitry L
  • Yevhen Kliukin
    Yevhen Kliukin
  • Paul Duryee
  • MarijnS
  • Brian Weiss
  • ProductManager38511
  • tonner
  • Andrew Lukasiewicz
  • Ney Oliveira
  • Andrew Danckert
  • Nicole Gonser
  • Alan Hunt
  • Amine inane
  • Steve B
  • Luis Diaz
  • Jeffrey Gandt
  • sandertan
  • bradallan-improbable
  • J-TPM
  • Megan F
  • Jp Rowan
  • Claudio Shigueo Watanabe
  • Tor Jensen
  • NoelTiangco
  • liotal
  • Martin Valler
  • WillBe
  • Lex Van Der Sluijs
  • D. O.
  • Dilasha Hudson
  • Lucinda
  • clangdo3
  • Matt Frizzell
  • Emmanuel Rodríguez
    Emmanuel Rodríguez
  • Chris Hudson
  • Chris Yarie
  • CelineLeeUX
  • Gill McDonald
  • nezhova
  • hgreen
  • Florent Albert
  • PhilC
  • Susanna Taylor
  • Emma Hernandez
  • justview
  • Alessandro Baldazzi
  • Justin Feldman
  • vimal nelson
  • Timothy Garlick
  • Jan Verley
  • Frédéric Lebel
  • Martin Martinov
  • Max Grant
  • Zack Goldman
  • Matt Emerson
  • Daniel Fields
  • Jihane Abouzeid
  • Sanjiv Kumar
  • Sean B
    Sean B
  • Misu Tasnim
  • Colin Ma
  • Cedar Mountain Main Account
  • Steven Stickler
  • CoreyDiRuAK
    CoreyDiRuAK
  • Benno
  • Richil Cheng
  • ThatguycalledBen
  • Tarang Sanghi
  • ALi Kazemi
  • Lallemand

I’m interested in creating Entity Relationship Diagrams in Miro, and I’ve seen a template for them, but I think a major thing missing is crow’s foot notation which shows cardinality in the relationship.

https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model

 

I would love to see this kind of notation added to the list of arrows and other end-points that you can put on connector lines. 

 

 

I love Miro and would prefer to use it for any types of diagramming, but for people who need to use this kind of notation to make content and data models, Lucid Chart has the market. If Miro can get on board with the means to create more technical diagrams, even just beginning with these notations, I think they would be able to engage many more users.

If anyone has figured out a work-around for this, I would love to hear how. 

Here are a couple of articles worth reading for more understanding of how Entity Relationship Diagrams (ERD) can be useful for designers.

https://uxpamagazine.org/designing-future-friendly-content/

https://uxdesign.cc/structured-content-design-workflow-a-case-study-fd74ec25f17d

Pinned reply

June 17, 2022

Hi all,

 

I’m happy to let you know that we’ve release entity relationship diagram. 

 

In this post you can find more information. I’ll close this thread, please share any feedback or examples you’ve created in the new thread.

 

 

Happy diagramming,

Turner 

Was it helpful?
This topic has been closed for comments

61 replies

Marina
Mironeer
Forum|alt.badge.img+5
  • Mironeer
  • 991 replies
  • March 31, 2020

Thank you for this thorough explanation and feedback, @andyfitts! I will pitch your idea to the Miro team.

For now, I will move the topic to a Wish List :wink:  Let’s see how many people also wish this functionality in Miro.


I’d like to see this as well. I’m working on a content model for a website and the current notation set is limited. We’ve been using LucidChart for this kind of thing, but would prefer to do it in Miro given our research is managed in Miro.


  • New Here
  • 1 reply
  • April 27, 2020

I would also Love to see this feature!

I used existing Line ends and created a “Key” chart above my diagram; but it doesn’t do it justice! But it got the job done! :) 



I Feel like basic support for these diagrams could be added simply with alternate Connecting Line Ends (Aside from Arrows and Dots) 


Please add me to the list of people who would find this really useful.  The ability to designate cardinality is one of the few things that pushes me back to Visio, which after using Miro is really painful


  • New Here
  • 1 reply
  • May 21, 2020

We need this, too. Without it, we’re likely to use other solutions.


Same here - ERDs are one of the few evergreens among technical drawing frameworks. Very useful to model data…


Sergey Erlikh

this is basically MUST for any technology data modelling, surprised it is not part of the product 


I completely agree this is a must to have feature. Due to this feature unavailability, I have to look outside tool to design Entity-Relationship diagrams.


There is few things that I would wish for in miro...but THIS is definitely it! I would fo one step further, I’d love to have full ERD functionality in miro, with custom entity shapes in which we can define name, attributes, Primary and Foreign Keys etc. This would enable me to bring our whole engineering team to miro and finally have engineering and product collaborate fully in one tool. 


  • New Here
  • 1 reply
  • July 8, 2020

+1 - at the moment I use draw.io for this, but the business uses Miro for lots of other things - it’d be great to have one tool. I agree with Knuth above that having even some very basic name/fields/keys functionality is really a must here too.


+1 - would love to see this in Miro. As mentioned above - we’re using Lucid card for ERD with crow’s foot for now, but would love all our diagramming tools to be in one place.


Count me in too!  Cardianlity and ordidinality - you just can’t do an ERD without them.


Please please add this in the next update. I really want to be able to create an ERD in Miro
So now I use Lucidchart for the ERD


+1 Must have! This kind of diagram was the main reason for me to look at a tool like Miro.


I would find this a valuable addition. 


  • Beginner
  • 2 replies
  • September 25, 2020

I use this as a workaround (well actually I prefer it over crow’s foot notation, as it’s easier to read for people not used to ER diagrams):

So you have:
one: 1
many: n
zero or one: 0..1
zero or many: 0..n
one or many: 1..n

 

You can just do this by double clicking on the connector and entering the text there.


I would also love to see crow’s foot notation in Miro. Andy Fitts (no relation, though he is a colleague!) links to an article I wrote about creating domain models. For the diagrams I use there, I actually start the work in Miro, but end up moving it to Omnigraffle for the final diagram. Adding crow’s foot to line ends would allow one to stay in Miro (and stay collaborative!) for the whole thing. The text workaround Jens mentions above does also communicate cardinality, though when I’m labeling the lines (as in a domain model, or other representations of an acyclic graph), it’s nice to limit the amount of text on a single connection. 

So: please add one more vote to the pile! +1


  • New Here
  • 1 reply
  • December 24, 2020

I’d like to see this feature in Miro.

I think there are a few key elements that should exist:

  1. It should support all of the diagrammatic elements noted above
  2. It should provide a mechanism for formatting the diagram, and importantly this formatting should strive to preserve the notion of visual hierarchy (either a top-to-bottom or left-to-right).
  3. It should provide full support for the IDEF1x standard and the concepts it details, such as base-type-subtype relationship clusters.

No need for crow's foot notation. I also use chen notation, like Jens suggested, but I would also prefere to have the possibility to import parts of a db scheme from a sql-dump into the canvas; with or without Relationsgips.

That would help a lot when working with already existing complex db.

Thanks


  • New Here
  • 1 reply
  • February 11, 2021

Please add crows foot notation :laughing:


The One and Only SK

+10000


Please add crows foot notation


  • New Here
  • 1 reply
  • March 26, 2021

Please please please add crows foot notation


  • New Here
  • 1 reply
  • March 26, 2021

This is the feature I miss the most in Miro from less user-friendly tools. I tried creating a custom plugin to add line endings to no avail. This would make sketching out data models a lot easier!


I would also love to see crow’s foot notation in Miro