## Manufacturers

id | name
--- | ---
1 | Bonners Music
2 | Fender
3 | Yamaha
4 | C. F. Martin & Co.
5 | Steinway & Sons

## Guitars

id | model_name | price | manufacturer_id
--- | --- | --- | ---
|  |  | (→ Manufacturers.id)
1 | Stratocaster | 699.99 | 1
2 | Telecaster | 799.99 | 1
3 | Les Paul | 1099.99 | 2
4 | Acoustic Guitar | 299.99 | 3
5 | Electric Acoustic | 499.99 | 3

## Pianos

id | model_name | price | manufacturer_id
--- | --- | --- | ---
|  |  | (→ Manufacturers.id)
1 | Grand Piano | 8999.99 | 1
2 | Upright Piano | 4999.99 | 1
3 | Digital Piano | 999.99 | 3
4 | Stage Piano | 1499.99 | 5
5 | Hybrid Piano | 1999.99 | 5

## Musicians

id | name
--- | ---
1 | John Doe
2 | Jane Smith
3 | Alice Johnson
4 | Bob Williams
5 | Charlie Brown

## Guitarists

id | musician_id | guitar_model_id
--- | --- | ---
| (→ Musicians.id) | (→ Guitars.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 4
4 | 4 | 5
5 | 5 | 3

## Pianists

id | musician_id | piano_model_id
--- | --- | ---
| (→ Musicians.id) | (→ Pianos.id)
1 | 1 | 1
2 | 2 | 3
3 | 3 | 5
4 | 4 | 2
5 | 5 | 4