Database Answers Skiing in Villars, Switzerland

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Competition Results
Back to the Data Model
The Requirements have been established by Neil Harvey
The majority of the data is in a flat file format which I want to organise properly in a relational database.  

But Iíve continually come up against the problem in tennis and football where the competitors (be they clubs or players) play against each other.  

I came across your design schema yesterday and saw the one for a chess tournament, which I think will help solve my problem. 
 
I would like to understand how to establish the relationship between player_id in table Players and player_id_1 and player_id_2 in table Matches! 

Regards, Neil. 


Barry Williams
1st. December 2007
Principal Consultant
Database Answers.org

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map