Organizing

[Desitech]

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

[NeoPa]

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.