Using Crow’s Foot Notation in an ERD

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.

Image for post

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:

Image for postA gym member belongs to a gym.Image for postA gym member has one gym pass and a gym pass has one member.Image for postA gym member attends many yoga classes and a yoga class has many members.Image for postA gym member has one and only one locker.Image for postA gym member can have one or many towels.Image for postA gym member can have zero or one pool pass.Image for postA 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!

1

No Responses

Write a response