Crow's foot notation

The notation we use in this book is crow's foot notation. We use rectangles to represent entities. For example, the following represents User entities and Team Entities:

Figure 5.2: Entities

And, we use a line to connect rectangles to represent a relationship. For example, Figure 5.3 represents the relationship between User entities and Team entities:

Figure 5.3: The relationship between User and Team

In this relationship, the symbol with double perpendicular lines on the left side means one and only one, and the symbol on the right side that is similar to a crow's foot means zero or many. It reads like this from left to right—Each user may create zero or many teams. And, it is like this when reading from right to left—Each team must be created by one and only one user.

Here are the relationship symbols in crow's foot notation:

Figure 5.4: Relationship symbols in crow's foot notation
The tool used to create the ER diagram is draw.io (https://www.draw.io). It is a great tool, and it is free and available as an online version as well as a desktop version. Also, you can use it to create many other types of diagrams besides ER diagrams.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.144.65