Learn VisualLearn DB Visual
JA

Count Both Sides of a Relationship

A relationship connects two entity types, and cardinality states how many instances may be connected. One customer may place many orders, while each order belongs to one customer, so Customer–Order is one-to-many. Crow’s Foot notation draws a bar at the one side and a three-pronged foot at the many side.

One customer may place several orders, but each order belongs to one customer. Which model matches?