| id | instrumentName |
|---|---|
| 1 | Guitar |
| 2 | Piano |
| id | singerName | country | foreignKey |
|---|---|---|---|
| (→ Instruments.id) | |||
| 1 | John Doe | USA | 1 |
| 2 | Jane Smith | Canada | 2 |
| id | singerName | bluegrassStyle | foreignKey |
|---|---|---|---|
| (→ Instruments.id) | |||
| 1 | Tom Brown | 1 | 1 |
| 2 | Emily White | 0 | 2 |
| id | albumTitle | releaseYear |
|---|---|---|
| 1 | My First Album | 2000 |
| 2 | The Best of Me | 2010 |
| id | trackNumber | title | duration |
|---|---|---|---|
| 1 | 1 | Track 1 | 3:00 |
| 2 | 2 | Track 2 | 3:30 |
| id | singerId | albumId |
|---|---|---|
| (→ CountrySingers.id) | (→ Albums.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 2 |
| 4 | 4 | 2 |