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.
- What are the bad design points in the following (simple) Entity-Relationship Diagram
- Modeling a scenario in which each Music Artist is either a Group or a Solo Performer
- Modeling Subclass (or Subtype) Constraints in an Entity-Relationship Diagram
- How to avoid this circular relation
- Sql-server – Representing a many-to-one relationship in a database diagram
- The Relationship between Instagram users and user followers
- How to categorize entites by their age in an entity relational diagram