jeudi 17 décembre 2015

How to design this database to avoid Circular Reference between 3 tables

I have 3 tables.

  • People
  • Post
  • Likes

When I design ER it has Circular Reference(cyclic dependency)..

 1:N

People --------< Post

 1:N

Post ----------< Likes

 1:M

People --------< Likes

Logic is

  • 1 people can have many posts.
  • 1 post has many likes.
  • 1 people can like many posts (created person cannot like his own post).

How can i remove this kind of cyclic design?? or my db design is wrong??

any suggestion.. thanks advance

Aucun commentaire:

Enregistrer un commentaire