Genres

idname
1Pop
2Rock
3Jazz
4Country
5Hip Hop

Artists

artist_idartist_namegenre_id
(→ Genres.id)
1Artist A1
2Artist B2
3Artist C3
4Artist D4
5Artist E5

Pop_Songs

song_idtitleartist_id
(→ Artists.artist_id)
1Pop Song 11
2Pop Song 22
3Pop Song 33
4Pop Song 44
5Pop Song 55

Hip_Hop_Songs

song_idtitleartist_id
(→ Artists.artist_id)
1Hip Hop Song 11
2Hip Hop Song 22
3Hip Hop Song 33
4Hip Hop Song 44
5Hip Hop Song 55

Concerts

concert_idvenue_nameartist_idpop_song_idhip_hop_song_id
(→ Artists.artist_id)(→ Pop_Songs.song_id)(→ Hip_Hop_Songs.song_id)
1Madison Square Garden11None
2The O2 Arena22None
3Staples Center33None
4Barclays Center44None
5Prudential Center55None
6Madison Square Garden1None1
7The O2 Arena2None2
8Staples Center3None3
9Barclays Center4None4
10Prudential Center5None5

Venues

venue_idvenue_name
1Madison Square Garden
2The O2 Arena
3Staples Center
4Barclays Center
5Prudential Center