The models that database designers create are called Entity Relationship Diagrams, because they are intended to model the way tables will eventually relate to each other in the finished database.
In our video on modeling table relationships, we saw some examples of simple Crow’s Foot notation. There are actually many combinations of cardinality symbols used in Crow’s Foot models.
Also, as with many things in technology and the rest of the world, there are more than one way to do things. There are other types of relationship notation that we didn’t get into.
Here are a few:
You need to sign up for Treehouse in order to download course files.Sign up