Database design issue RSS

• • Reply
  

  Mech0z

  Member

  34 Points

  40 Posts

  Database design issue

  May 09, 2012 08:10 AM|LINK

  I have a RESTful MVC4 server that I want to have a database, the server has Users and Games

  So a User can participate in many Games, but Games can also have many Users playing them

  That gives me a many to many relation which I would like to avoid, I then tried to implement a weak entity, but I am not sure if thats the correct way to fix the issue?

  

  arcitecture Design

• • Reply
  

  ignatandrei

  All-Star

  134973 Points

  21638 Posts

  Moderator

  MVP

  Re: Database design issue

  May 09, 2012 08:12 AM|LINK

  Mech0z

  So a User can participate in many Games, but Games can also have many Users playing them

  So your database modelling is correct.

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  Mech0z

  Member

  34 Points

  40 Posts

  Re: Database design issue

  May 09, 2012 08:18 AM|LINK

  ignatandrei

  Mech0z

  So a User can participate in many Games, but Games can also have many Users playing them

  So your database modelling is correct.

  So using the weak entity is the right thing to do?

  • Edited by Mech0z on May 09, 2012 08:42 AM
• • Reply
  

  ignatandrei

  All-Star

  134973 Points

  21638 Posts

  Moderator

  MVP

  Re: Database design issue

  May 09, 2012 08:53 AM|LINK

  I describe as a "many to many"table.

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  Mech0z

  Member

  34 Points

  40 Posts

  Re: Database design issue

  May 09, 2012 08:58 AM|LINK

  Think I will use this http://en.wikipedia.org/wiki/Junction_table 

  • Edited by Mech0z on May 09, 2012 09:25 AM
  • Marked as answer by Mech0z on May 09, 2012 09:25 AM