Manufacturers

idname
1Bonners Music
2Yamaha

Musical_instruments

idinstrument_namemanufacturer_id
(→ Manufacturers.id)
1Guitar1
2Guitar2
3Piano1
4Piano2

Artists

idartist_name
1Artist A
2Artist B
3Artist C

Albums

idalbum_titlerelease_dategenre_idartist_id
(→ Genre.id)(→ Artists.id)
1Album 12021-01-011None
2Album 22021-02-022None
3Album 32021-03-033None

Songs

idsong_nameartist_idinstrument_id
(→ Artists.id)(→ Musical_instruments.id)
1Song 111
2Song 222
3Song 331
4Song 412

Album_Tracks

idtrack_numberalbum_idsong_id
(→ Albums.id)(→ Songs.id)
1111
2212
3323
4424

Genre

idgenre_type
1Genre 1
2Genre 2
3Genre 3