Hi i was wondering if anyone can please help me with the design of a tournament database.

I cant work out how to relate the tables together to get the database to function properly :S

the tables im referring to are

Team, Venue, Draw (fixtures), and match.

The problem i have is that the draw obviously consists of 2 teams, each with a unique identifier, team has a team_id attribute which is unique, i cant work out how to get say Man utd VS Arsenal using team_id and then teama, teamb attributes from the draw.

Then to which data has to be entered via a form text box for scores, whereby the winner etc is assigned points in a standings table.

as well Should i store the result attribute in the match table, or seperately.


sorry if this is confusing, it is to me too :S

if anyone has a dbase out there that does this and allows users to enter result data from predefined matches, could you please send me the schema or provide insight into this.

Thanx heaps!

MJ