Duplicate Fields Problem in My Tables

An ID field that is used as a linking field is like an EmployeeID number.
You can move, change your name, go into a different departemnt, or whatever.
Through it all your payroll and other history is linked to your EmployeeID
only. Most likely they don't store your name and so forth every time you get
paid. They store just your EmployeeID, and link to the main Employee table
to display your name and other information as needed. Likewise player
information exists in the Players table only. Any other time you store the
Player information you store the single ID field.

Steve showed a table structure that is one way to proceed, given certain
assumptions (although I see no need for a Years table except as a lookup
table, and then only to store the four-digit year without a separate ID field)