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 |