Let´s say I have 3 entities. Can I have them all linked to each other "forming a circle" where each one is linked to the other trough a many to many relationship.


  • 5
    You need to provide more information. Of course you can have them all 'linked.' The real question is, should you? And there's no way to say that unless you give more information about the logical design of your database. What data is actually being modeled in this case? Nov 1, 2013 at 12:07
  • Are you using ER modeiling to capture analysis or design? If you are analyzing the subject matter, and you discover circular relationships in the real world, by all means you should model them. If you are designing a database, then you need to consider whether all of these relationships are going to be reflected in the design. Nov 4, 2013 at 13:16

1 Answer 1


Sometimes this is called "a cycle" in database design, and while it is not forbidden (because as the commenters point out, you must take into account your purpose and business problem), it is considered a red flag for many designers.

Here is a related Stack Overflow question that attempts to point out why this can be a red flag: https://stackoverflow.com/questions/8115748/why-should-i-avoid-loops-when-designing-relationships-for-a-database

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.