Countries
id | name |
1 | Canada |
2 | United States |
3 | Australia |
4 | Spain |
5 | Japan |
SportsTeams
id | teamName | countryId |
| | (→ Countries.id) |
1 | Toronto Blue Jays | 1 |
2 | Los Angeles Dodgers | 2 |
3 | Melbourne Stars | 3 |
4 | Real Madrid | 4 |
5 | Yomiuri Giants | 5 |
BaseballTeams
id | teamName | countryId |
| | (→ Countries.id) |
1 | New York Yankees | 1 |
2 | San Francisco Giants | 2 |
3 | Adelaide Strikers | 3 |
4 | Barcelona | 4 |
5 | Hiroshima Toyo Carp | 5 |
BasketballTeams
id | teamName | countryId |
| | (→ Countries.id) |
1 | Golden State Warriors | 1 |
2 | Chicago Bulls | 2 |
3 | Perth Wildcats | 3 |
4 | FC Barcelona | 4 |
5 | Yokohama B-Corsairs | 5 |
Players
id | firstName | lastName | birthDate | sportType | teamId |
| | | | | (→ SportsTeams.id) |
1 | John | Doe | 1980-07-15 | Baseball | 1 |
2 | Jane | Smith | 1990-06-20 | Baseball | 2 |
3 | Alice | Brown | 1995-05-15 | Basketball | 3 |
4 | Bob | White | 1985-08-25 | Basketball | 4 |
5 | Tom | Green | 1992-09-05 | Baseball | 5 |