Sorry, perhaps it'd make more sense if in the WeightClass table GroupID was WeightClassGroupID and in the UserWeightClass table GroupID was UserWeightClassGroupID.

Each weight class (WeightClassID) has a TournamentBracket associated with...

Thank you for the replies. I'm familiar with data modeling, but not "ER speak"... maybe it's the same? Anyway, determining that part was where I was struggling, and...