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

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