CountrySinger
ID | Name | BirthDate | Genre | Instrument |
1 | John Doe | 1980-06-23 | Country Musician | Guitar |
2 | Jane Smith | 1975-08-01 | Country Musician | Banjo |
BluegrassSinger
ID | Name | BirthDate | AlbumCount | Instrument |
3 | Mike Brown | 1990-01-15 | 3 | Guitar |
4 | Emily Green | 1995-05-20 | 2 | Violin |
SongList
ID | Title | ReleaseYear | ArtistID |
| | | (→ CountrySinger.ID) |
1 | My First Single | 2021 | 1 |
2 | Another Great Track | 2022 | 2 |
3 | A Bluegrass Classic | 2020 | 3 |
4 | A New Tune | 2021 | 4 |
Concerts
ID | Date | Location | PerformerID |
| | | (→ CountrySinger.ID) |
1 | 2023-06-01 | New York City | 1 |
2 | 2023-07-05 | Los Angeles | 2 |
3 | 2023-08-10 | Nashville | 3 |
4 | 2023-09-15 | Chicago | 4 |
Fans
ID | FirstName | LastName | EmailAddress | FavoriteSingerID |
| | | | (→ CountrySinger.ID) |
1 | Alice Johnson | alice@example.com | None | 1 |
2 | Bob Williams | bob@example.com | None | 2 |
3 | Carol Miller | carol@example.com | None | 3 |
4 | David Wilson | david@example.com | None | 4 |
5 | Eva Taylor | eva@example.com | None | 1 |