March Madness DB

[Jimmy Smits]

I have been trying to get a DB going to track a pool for march madness.
There are 63 winners in the bracket and 64 teams. I cant figure out how to
design the DB, I guess that is why I am here.

So far I have tried having a table called picks and another table for
participants.

In the picks table there is a column for participants name and picks
1,2,3...63
This doesnt seem that efficient to me. Not to mention the problems I am
having getting the data inserted from my website - but that is another
issue.

Can anyone suggest a good layout for this type of thing? one where I could
compare the game winners to a participants selections?

Thanks for reading.

 

[Chris2]

I have been trying to get a DB going to track a pool for march madness.
There are 63 winners in the bracket and 64 teams. I cant figure out how to
design the DB, I guess that is why I am here.

So far I have tried having a table called picks and another table for
participants.

In the picks table there is a column for participants name and picks
1,2,3...63
This doesnt seem that efficient to me. Not to mention the problems I am
having getting the data inserted from my website - but that is another
issue.

Can anyone suggest a good layout for this type of thing? one where I could
compare the game winners to a participants selections?

Thanks for reading.

60 Seconds of Googling produced (assuming you *are* talking about
Basketball, says the NASCAR fan):

http://www.wcsoftware.com/wcsoftware/


Sincerely,

Chris O.