CountrySinger

IDNameBirthDateGenreInstrument
1John Doe1980-06-23Country MusicianGuitar
2Jane Smith1975-08-01Country MusicianBanjo

BluegrassSinger

IDNameBirthDateAlbumCountInstrument
3Mike Brown1990-01-153Guitar
4Emily Green1995-05-202Violin

SongList

IDTitleReleaseYearArtistID
(→ CountrySinger.ID)
1My First Single20211
2Another Great Track20222
3A Bluegrass Classic20203
4A New Tune20214

Concerts

IDDateLocationPerformerID
(→ CountrySinger.ID)
12023-06-01New York City1
22023-07-05Los Angeles2
32023-08-10Nashville3
42023-09-15Chicago4

Fans

IDFirstNameLastNameEmailAddressFavoriteSingerID
(→ CountrySinger.ID)
1Alice Johnsonalice@example.comNone1
2Bob Williamsbob@example.comNone2
3Carol Millercarol@example.comNone3
4David Wilsondavid@example.comNone4
5Eva Tayloreva@example.comNone1