I'm designing a database and I want to represent the relationship between users and groups:

A user can be on zero or more groups. A group can have one or more users.

Using Microsoft Visio 2013 I've drawn this diagram:

enter image description here

Is correct?

1 Answer 1


Yes that is correct.

Of course you no longer actually have a many-to-many relationship in your model. You are no longer "representing" the relationship, as you say in your question. You have, in fact, resolved the relationship into an association entity type with two one-to-many relationships.

Your Answer

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

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