Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Table structure for Soccer league?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-11 : 09:21:24
Steve writes "Hello,
I am trying to provide a soccer league with online standings that they can access via a webpage.
But I am a little confused on how to structure the database so that is efficient and normalized.
In particular, how should I keep track of games, goals, who wins, who loses, etc. And should I just calculate team points and other stats dynamically when the web page is requested, or should I store these stats in a table?
I'm sure this type of database has been done a million times before but I can't sem to find any similar examples...if you know of any, could you point them out to me?

Thanks for the help!

Steve"
   

- Advertisement -