Countries

idname
1Canada
2United States
3Australia
4Spain
5Japan

SportsTeams

idteamNamecountryId
(→ Countries.id)
1Toronto Blue Jays1
2Los Angeles Dodgers2
3Melbourne Stars3
4Real Madrid4
5Yomiuri Giants5

BaseballTeams

idteamNamecountryId
(→ Countries.id)
1New York Yankees1
2San Francisco Giants2
3Adelaide Strikers3
4Barcelona4
5Hiroshima Toyo Carp5

BasketballTeams

idteamNamecountryId
(→ Countries.id)
1Golden State Warriors1
2Chicago Bulls2
3Perth Wildcats3
4FC Barcelona4
5Yokohama B-Corsairs5

Players

idfirstNamelastNamebirthDatesportTypeteamId
(→ SportsTeams.id)
1JohnDoe1980-07-15Baseball1
2JaneSmith1990-06-20Baseball2
3AliceBrown1995-05-15Basketball3
4BobWhite1985-08-25Basketball4
5TomGreen1992-09-05Baseball5