15,961,844 members
See more:
If in erd diagram there is a relationship between the following entities

A with B
B with C
C with A

I see those relationships neccesary
I can't remove any of those relationships
But it makes a closed circle

Is the closed circle wrong in erd diagram
If yes what I should do in this case

What I have tried:

I tried to break the circle but it will not go with the business case
Posted
Updated 10-Nov-19 6:59am

## Solution 1

You can't just say A, B, C; you have to be more specific.

Sometimes it makes sense; sometimes it doesn't.

They're usually ALL the same type; and it's what's known as a recursive relationship and it's simply: (some A) -> A -> (some other A).

Round and round, if you want.

## Solution 2

Top Experts
Last 24hrsThis month
 Pete O'Hanlon 20 Member 16331880 10 RickZeeland -25
 OriginalGriff 178 Pete O'Hanlon 140 merano99 80 den2k88 50 Andre Oosthuizen 50

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900