Country

idname
1USA
2UK
3Canada
4Australia
5Germany

City

idnamecountry_id
(→ Country.id)
1New York1
2London2
3Toronto3
4Melbourne4
5Berlin5

Artist

idnamecity_idcountry_idgenre
(→ City.id)(→ Country.id)
1Beyonce11Pop
2Adele22Jazz
3The Weeknd33R&B
4Dua Lipa44Electronic Dance Music
5David Bowie55Rock

Concert

idartist_nameartist_genreconcert_datecity_idcountry_id
(→ Artist.name)(→ City.id)(→ Country.id)
1BeyoncePop2022-07-0111
2AdeleJazz2022-08-1522
3The WeekndR&B2022-09-0133
4Dua LipaElectronic Dance Music2022-10-1544
5David BowieRock2022-11-0155