1

I'm building a blog project, which each user can follow other users. I'm still figuring out the design and creating the diagrams first. I know that the relationship between users and followers is many to many. Is this the correct approach for the ER design of the relationship?

enter image description here

1 Answer 1

3

The relationship between Instagram user and follower is many to many because:

One user can have multiple followers. One follower can have multiple "followed users".

Useful: Always name the entities (classes) as singular e.g. User & Follower

2
  • is the diagram correct?
    – camille
    May 1, 2020 at 6:10
  • Not Exactly. There should be one line between two entities for clear representation of a relationship. You can make three classes for many-to-many relationship. The third table will be "user_follower" with user_id and follower_id as the foreign keys. For further clarification, please refer to this visual-paradigm.com/guide/data-modeling/…
    – Hashir
    May 1, 2020 at 9:28

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.