## 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