Using Crow’s Foot Notation in an ERD

Managing your relational databases can get a little tricky, so it’s nice to have a clear diagram of your entities. Lucidchart is a great tool for this task. It provides you with the ability to model databases in an easy-to-read format with entity relationship diagrams.

Crow’s Foot Notation is useful for illustrating the relationships and cardinality of the entities, but it’s also difficult to remember which symbols and notations are appropriate. Consider the following scenarios:

A gym member belongs to a gym.

A gym member has one gym pass and a gym pass has one member.

A gym member attends many yoga classes and a yoga class has many members.

A gym member has one and only one locker.

A gym member can have one or many towels.

A gym member can have zero or one pool pass.

A gym member can have zero or many gym visits. Don’t judge…

All of these relational tables were created in Lucidchart. You can find the tables if you go to + Shapes (on the left) and checkmark Entity Relationship (under Software). Line endpoints are available in the toolbar. Hope this helps!