Crow's Foot Notation

One standard way to visualize ER Models.

Correct way to interpret

The place the notation symbols are placed can be confusing. There is a correct method to read the relationship correctly.

1. Select table and relationship you want to start with.
2. From that relationship line, follow till the other end.
3. Read It like this eg.

   1. Lets take relationship of audit_log and user_account A user_account can have zero or many audit_log entries (optional), while each audit_log entry must belong to exactly one user_account.

   2. user_account to officer Each user_account is associated with exactly one officer, and each officer must have exactly one corresponding user_account (1:1 mandatory relationship).