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 |