Manufacturers

idname
1Bonners Music
2Fender
3Yamaha
4C. F. Martin & Co.
5Steinway & Sons

Guitars

idmodel_namepricemanufacturer_id
(→ Manufacturers.id)
1Stratocaster699.991
2Telecaster799.991
3Les Paul1099.992
4Acoustic Guitar299.993
5Electric Acoustic499.993

Pianos

idmodel_namepricemanufacturer_id
(→ Manufacturers.id)
1Grand Piano8999.991
2Upright Piano4999.991
3Digital Piano999.993
4Stage Piano1499.995
5Hybrid Piano1999.995

Musicians

idname
1John Doe
2Jane Smith
3Alice Johnson
4Bob Williams
5Charlie Brown

Guitarists

idmusician_idguitar_model_id
(→ Musicians.id)(→ Guitars.id)
111
222
334
445
553

Pianists

idmusician_idpiano_model_id
(→ Musicians.id)(→ Pianos.id)
111
223
335
442
554