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?

Sounds pretty good to me

commented: no need to dig dead threads and post this useless commnet. -3

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

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

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!

commented: lol :) +13