Countries

idname
1Canada
2USA
3Australia

SportsTypes

idtype_name
1Baseball Team
2Basketball Team
3Football Team
4Tennis Team
5Hockey Team

Teams

idteam_name
1Toronto Blue Jays
2Los Angeles Lakers
3Melbourne Stars
4New York Knicks
5Adelaide Strikers

CountryTeams

country_idsport_type_idteam_id
(→ Countries.id)(→ SportsTypes.id)(→ Teams.id)
123
134
235
326
317