Genre

idname
1Rock
2Pop
3Jazz
4Hip Hop

Instrument

idtype
1Guitar
2Piano
3Drums
4Violin

Singer

idfirst_namelast_namebirth_datedeath_date
1JohnHurt1923-06-082007-01-27
2BobSmith1960-07-01None
3AliceJohnson1975-01-10None
4TomWhite1980-02-05None
5EmilyGreen1992-03-15None

Album

idtitlerelease_dateGENRE_id
(→ Genre.id)
1None2000-01-011
2None2001-06-012
3None2002-11-013
4None2003-05-014
5None2004-10-015

Music

idtitlelengthGENRE_idMUSIC_TYPEINSTRUMENT_idALBUM_idSINGER_id
(→ Genre.id)(→ Instrument.id)(→ Album.id)(→ Singer.id)
1Blues Song03:001Single111
2Blues Song03:001Single222
3Folk Song03:002Single331
4Folk Song03:002Single443
5Country03:003Single554