I need to design an ER diagram, but I am confused in a section, more specifically how to relate the post with the groups, because I need that post contains the information of in which group I publish and that user I publish it, I have two diagrams one where the relation of post, group and user are direct, and other where the post is related by means of the table generated of the relation many to many between group and user. My question is which of these two is more recommended.

Diagram A Diagram A

Diagram B enter image description here

1 Answer 1


the bridge table group_user between User and group is the right idea, when there is a many to many relationship

But users should be connected directly to posts like in the first image, because only pone user can have written the post-

Conclusion make a new mixed version

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.