By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

Organizing

P: 56
I am getting ready to build a new Database for a Golf Tournament I have each year. I am having trouble organizing how I want to build my tables. I have many golfers that golf each year but usually are part of different teams. Some years they golf some they don't. I want to do history reporting. Like What years did they particiate. What championships did they win. Are there any templates for building tables and how to organize the information. Thanks
May 28 '09 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,709
Normalisation and Table structures
How to structure your tables
I don't know of any pre-made templates, but recommend you do your own design anyway. It's easier to work within a design you've created than the results of somebody else's understanding. The links will give some pointers on what to be looking at.

It seems clear you will need a table to hold player details. Other tables required would seem to be one for tournaments and one which links the two with a date. The date field will need to be part of the identifying index as well as the FKs for each of the other two tables.

Hopefully this will give you some things to consider. More than that is not a good idea, as you need to understand this part pretty well if you hope to proceed without too many problems.
May 28 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.