## 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