Define max number of entities in many-to-many



  • I want to design a database with a many-to-many relationship with entities students and teams. Each team can have many students and each student can participate in many teams. However each team can have max 10 students. What is the right way to do this?



  • Some things are best done by the application. The database can deal with the many-to-many, but the app should handle the "10" limit.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2