A team can have multiple players, a player may also have multiple teams

Table: Player
-------------
p_id       PK
p_name

Table: Team
-------------
t_id       PK
t_name

Table: Roster
-------------
r_id       PK
t_id       FK
p_id       FK