Help setting up a database

[IATAILG8ER]

View attachment Track and Field.pdf Hi, I am trying to set up a database for organizing Track and Field meets. I'm a newbie to a lot of the Access capabilities. I've attached a PDF of what I'm looking at doing for my Access tables. Some of the tables I think I have right. I don't know how to organize the meets, events, days. Should I have a table for each event? Can you look at my tables and give me advice on problems you can see? In the end I would like to enter the event results by race. Some races could have 10 or more heats. There are also field events that have different number of attempts depending on the meet. There are different track meets with different events each time and the order in which the events occur changes from meet to meet. Any help or advice you can give me would be great. Thanks!

CK

 

[statsman]

It would really depend on what you want the database to do.
Are you just keeping track of results or are you scheduling meets and setting up the order of events at the meets?

If you are just keeping records, you only have to do that. The track events require times and names. Do you really need the heat results? In swimming, if there are 4 heats to get to the final it's the top 8 times in the 4 heats. In track the first second third place etc. advance regardless of time.

In the field events, for high jump and pole vault you need the final height and the number of misses. If tied, the lowest number of misses wins.

In the other field events, you could keep track of only the longest attempt or or all the attempts.

You really have to have a talk with your principle and find out what level of stats they want to keep.