Click here to Skip to main content
15,889,315 members
Home / Discussions / C#
   

C#

 
GeneralID3 algortithm Pin
Member 7511392-May-04 22:52
Member 7511392-May-04 22:52 
GeneralRe: ID3 algortithm Pin
Heath Stewart3-May-04 2:06
protectorHeath Stewart3-May-04 2:06 
Generalexplorer structure Pin
cristina_tudor2-May-04 22:05
cristina_tudor2-May-04 22:05 
GeneralRe: explorer structure Pin
Colin Angus Mackay2-May-04 22:29
Colin Angus Mackay2-May-04 22:29 
GeneralDesign database....... Pin
god4k2-May-04 21:27
god4k2-May-04 21:27 
GeneralRe: Design database....... Pin
Colin Angus Mackay2-May-04 21:38
Colin Angus Mackay2-May-04 21:38 
GeneralRe: Design database....... Pin
god4k3-May-04 1:02
god4k3-May-04 1:02 
GeneralRe: Design database....... Pin
Colin Angus Mackay3-May-04 1:28
Colin Angus Mackay3-May-04 1:28 
Okay, I realise you mean structure, tables and relations. The number of objects you mention is quite large, also not every one is an expert on football (soccer) so you really need to explain the rules of how each of these objects relate to each other. The explanation will help you understand the relations better your self.

As a starting point:

A team has many players
A team plays in many tournaments
A tournament has many teams
A player can play for many teams (are you including international teams?)

From this small subset we can create a structure like:
+------------+     +------+     +--------+
|            |\   /|      |\   /|        |
| Tournament |-----| Team |-----| Player |
|            |/   \|      |/   \|        |
+------------+     +------+     +--------+

Now, most relational database systems don't accept a many-to-many joins directly so these m2m joins have to be expanded:
+------------+     +----------------+     +------+
|            |    /|                |\    |      |
| Tournament |-----| TournamentTeam |-----| Team |
|            |    \|                |/    |      |
+------------+     +----------------+     +------+

So the keys on your the above tables are:
Tournament: TournamentID
TournamentTeam: TournamentID, TeamID
Team: TeamID

The TournamentTeam Table contains a composite primary key (i.e. one that is made up of more than one field). It also contains two foreign keys TournamentID to link to the tournament table and TeamID to link to the Team table.

Does this help you get started?


"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

Coming soon: The Second EuroCPian Event


GeneralRe: Design database....... Pin
god4k3-May-04 17:19
god4k3-May-04 17:19 
Generalstatus bar color Pin
Dpriya2-May-04 20:56
Dpriya2-May-04 20:56 
GeneralRe: status bar color Pin
Heath Stewart3-May-04 2:00
protectorHeath Stewart3-May-04 2:00 
GeneralStoring Color To database Pin
sreejith ss nair2-May-04 20:49
sreejith ss nair2-May-04 20:49 
GeneralRe: Storing Color To database Pin
Colin Angus Mackay2-May-04 21:28
Colin Angus Mackay2-May-04 21:28 
GeneralRe: Storing Color To database Pin
Heath Stewart3-May-04 1:58
protectorHeath Stewart3-May-04 1:58 
GeneralListbox Hatch Pin
"joel"2-May-04 6:37
"joel"2-May-04 6:37 
GeneralRe: Listbox Hatch Pin
Heath Stewart2-May-04 6:46
protectorHeath Stewart2-May-04 6:46 
GeneralRe: Listbox Hatch Pin
"joel"2-May-04 20:27
"joel"2-May-04 20:27 
GeneralTextBox calculations on the fly. Pin
FredSP2-May-04 4:36
FredSP2-May-04 4:36 
GeneralRe: TextBox calculations on the fly. Pin
Dave Kreskowiak2-May-04 4:40
mveDave Kreskowiak2-May-04 4:40 
GeneralRe: TextBox calculations on the fly. Pin
FredSP2-May-04 16:49
FredSP2-May-04 16:49 
GeneralRe: TextBox calculations on the fly. Pin
Heath Stewart2-May-04 6:42
protectorHeath Stewart2-May-04 6:42 
GeneralRe: TextBox calculations on the fly. Pin
FredSP2-May-04 16:45
FredSP2-May-04 16:45 
GeneralRe: TextBox calculations on the fly. Pin
..Hubert..3-May-04 1:17
..Hubert..3-May-04 1:17 
GeneralRe: TextBox calculations on the fly. Pin
Heath Stewart3-May-04 1:52
protectorHeath Stewart3-May-04 1:52 
GeneralRe: TextBox calculations on the fly. Pin
..Hubert..4-May-04 7:51
..Hubert..4-May-04 7:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.