Hello i'm trying to define a good Model to manage Teams, athletes and practiced sports. Here is the situation: One team can have multiple athletes and an athlete can play in different teams. So i setup a Many to Many relationship
An athlete can play different sports and a sport can be played by different athletes. So i setup a Many to Many relationship
This was easy.
Now the doubt:
Andrew plays soccer for the "A" Team
Andrew plays tennis for the "B" Team
John plays soccer for the "A" Team
John plays basket for the "C" Team
With the first relationships i'm not able to understand what team Andrew play soccer with.
So , can you help me on how defining the relationship between tables to manage that type of information? I am also available to modify the first three relationships between Team Sports Athletes tables