Music_Genre

idGenre
1Blues
2Rock
3Pop
4Jazz
5Country

Singers

idSingerName
1John Hurt
2Eric Clapton
3Bob Dylan
4Adele
5Elvis Presley

Albums

idAlbumTitleReleaseYearMusic_Genre_id
(→ Music_Genre.id)
1The Blues Collection20011
2Layla and Other Assorted Love Songs19701
3Blood on the Tracks19753
42120114
5From Elvis Presley Boulevard, Memphis, Tennessee19565

Songs

idSongTitleDurationMusicSinger_idAlbum_id
(→ Singers.id)(→ Albums.id)
1Blues Song300186e16">Blues Music11
2Another Blues Song280186e16">Blues Music21
3Folk Song290186e16">Folk Music12
4Yet Another Folk Song270Folk Music32
5Love Story220Pop Music43

Performances

idPerformanceDateVenueSong_id
(→ Songs.id)
12021-08-15 20:00:00Madison Square Garden1
22021-08-16 20:00:00Wembley Stadium2
32021-08-17 20:00:00Staples Center3
42021-08-18 20:00:00O2 Arena4
52021-08-19 20:00:00Barclays Center5