Hachimaki
3 months ago

Doubt on how to define Model for Team-Athletes-Sports relationsships

Posted 3 months ago by Hachimaki

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

thanks regards

Simon

Please sign in or create an account to participate in this conversation.