## Country

id | name
--- | ---
1 | USA
2 | UK
3 | Canada
4 | Australia
5 | Germany

## City

id | name | country_id
--- | --- | ---
|  | (→ Country.id)
1 | New York | 1
2 | London | 2
3 | Toronto | 3
4 | Melbourne | 4
5 | Berlin | 5

## Artist

id | name | city_id | country_id | genre
--- | --- | --- | --- | ---
|  | (→ City.id) | (→ Country.id) |
1 | Beyonce | 1 | 1 | Pop
2 | Adele | 2 | 2 | Jazz
3 | The Weeknd | 3 | 3 | R&B
4 | Dua Lipa | 4 | 4 | Electronic Dance Music
5 | David Bowie | 5 | 5 | Rock

## Concert

id | artist_name | artist_genre | concert_date | city_id | country_id
--- | --- | --- | --- | --- | ---
| (→ Artist.name) |  |  | (→ City.id) | (→ Country.id)
1 | Beyonce | Pop | 2022-07-01 | 1 | 1
2 | Adele | Jazz | 2022-08-15 | 2 | 2
3 | The Weeknd | R&B | 2022-09-01 | 3 | 3
4 | Dua Lipa | Electronic Dance Music | 2022-10-15 | 4 | 4
5 | David Bowie | Rock | 2022-11-01 | 5 | 5