0

Hi

I am trying to implement a world cup 2010 database, but can't seem to find the best table structure. At the moment I have the following:

Team
TeadName PK

group A with fixtures

group B with fixtures

group C with fixtures

group D with fixtures

group E with fixtures

group F with fixtures

group G with fixtures

group H with fixtures

Round of 16 with fixtures

Quarter finals with fixtures

Semi Finals with fixtures

Finals with fixtures

Can someone help me?

4
Contributors
4
Replies
6
Views
6 Years
Discussion Span
Last Post by smantscheff
1

You need
1 table for all the teams (id_team, nationality, id_group)
1 table for the matches between teams (id_team_1, id_team_2, result),
various views for quarter to final matches depending on the match results of the group matches

0

2smartscheff -you are right but one more table to keep the record of players in a team is also required.....

1

2smartscheff -you are right but one more table to keep the record of players in a team is also required.....

@II: MIt all depends on what you want to store - the referee's names, the number of fans, the number of rule violations, the degree of the afterplay rioting and the second spend on the loo during the breaks...a database is a means of content organization. The content which you mention (players) seemed not to be of any concern to the original poster.
By the way, I just realized that this is an old and stale thread. Uggh!

Votes + Comments
lol :)
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.