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?
Jump to PostYou 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
Sounds pretty good to me
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!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.