I’m trying to build a DB to track individual athlete scores over multiple seasons and competition categories. I already have a database of fixed athlete info (name, age, email, etc), but I’m not sure how to:
A) configure the record tracking DB
B) connect it with the individual athletes
Example of an individual athlete
2018 season for ‘Under 18’ in ‘Couples’
Round 1 score = 1
Round 2 = 2
Round 3 = 3
Total 1+2+3 = 6
Rank (for 2018 in ‘Under 18’, ‘Couples’) = #10
For the same athlete:
2019 season for ‘Under 21’ in ‘Singles’
Round 1 = 3
Round 2 = 4
Round 3 = 5
Total = 12
Rank (for 2019 in ‘Under 18’, ‘Couples’) = #5 Athlete Record Database
