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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 football scoring system
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Kingdom
7 Posts

Posted - 07/27/2014 :  16:41:30  Show Profile
Hi, I have been given the task of creating a football scoring system using sql server database. I then have to implement this into to create the web design.

The database is given me a real headache and i dont know what tables to create and what relationships should be put in place.

So the instructions I have been given are as follows

The league will have a maximum of 12 teams

Teams must play at least 6 games each

Each team will play at least 3 games as “Home” team and at least 3 games as “Away” team.

The league will be split in 3 “Groups” of 4 teams each.

Teams are only expected to play against other teams in the same group. Team allocation to groups should be random at the start of each championship.

The system will then produce a “Team Standing Table” for each “Group” showing the team standing, accumulated goals scored, accumulated goals against, won drawn and lost games, and points accumulated. Points are awarded as follow: 3 points per game won, 1 point per game drawn, 0 points per game lost.

Most Valuable Yak

15732 Posts

Posted - 07/28/2014 :  06:29:17  Show Profile  Visit robvolk's Homepage
Please do not cross post:
Go to Top of Page
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000