I have a database design for which one entity of Class A always has at least two entities of Class B. Can I express this with valid Crow’s Foot notation?
One possible idea I had was this:
Excuse the giant crow’s foot, was a quick drawing! I know this breaks the Crow’s Foot format of always having two symbols on each end. Also I’m concerned that it’s not particularly obvious. I think doing a UML with 2...M is more obvious.
So is there a way I can do this cleanly with Crow’s Foot?
12
AFAIK there is no “offical” symbol for this. You can help yourself by adding a free-form commentary, or use UML instead.