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

Music

idtitlelengthMUSIC_TYPEINSTRUMENT_idALBUM_idSINGER_id
(→ Instrument.id)(→ Album.id)(→ Singer.id)
1Blues Song03:00Single111
2Blues Song03:00Single222
3Folk Song03:00Single331
4Folk Song03:00Single443
5Country03:00Single554

Album

idtitlerelease_date
1None2000-01-01
2None2001-06-01
3None2002-11-01
4None2003-05-01
5None2004-10-01