Track and Field Database RRS feed

  • Question

  • I'm a newbie in db design but have been asked to try to figure out a way to use access or sql server to track my daughters' track and fields team's stats.

    I haven't found a decent (free) app so I thought I'd try to do something, as simplistic as possible, to track these things.  Her team also holds meets, so would have to track multiple teams.

    So there would be meets.

    With meets, there would be teams.

    On teams there would be athletes.  Athletes would have personal information about themselves, and stats like events they've done with their times/distances input as well.

    Some of the useful reports the team will use are:  each athletes progress over time, teams performance over various meets, etc, etc.

    Does anyone know of a sql script that can be used to accomplish this?  I can write queries for the reports but creating the tables and associating them is where I'm having issues.

    Any help is appreciated.

    Thank you.

    Tuesday, December 22, 2015 8:28 PM


All replies