Is the close circle in erd diagram wrong?

Question

0.00/5 (No votes)

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 9-Nov-19 9:30am

Member 14641515

Updated 10-Nov-19 6:59am

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2019-11-10T07:00:00

Solution 2

Not necessarily, see example here: database design - Avoid Circular Dependency - Stack Overflow[^]
But also: Prevent Circular References in Database Design[^]

Posted 10-Nov-19 7:00am

RickZeeland

Gerry Schmitz · Answer 2 · 2019-11-09T15:03:00

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.

Posted 9-Nov-19 15:03pm

Gerry Schmitz

Is the close circle in erd diagram wrong?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Is the close circle in erd diagram wrong?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us