Music_Bands

idNameGenreFounding_YearCountry
1The Jazz ConnectionJazz1985USA
2Blue Note EnsembleJazz1990Canada
3Guitar LegendsRock1985UK
4Vocal VibesRock1993Australia

Albums

idTitleRelease_DateLabelGenre
(→ Music_Bands.Name)
1First Impressions2000-06-15WarnerJazz
2Melodic Memories2005-03-05UniversalJazz
3Strumming Strings2002-02-20EMIRock
4Heavy Metal Beats2010-10-15ColumbiaRock

Songs

idTitleLengthAlbum_id
(→ Albums.id)
1Night Flight3.51
2Dreamy Skies4.22
3Thunderous Riffs3.83
4Acoustic Journey4.14

Concerts

idDateVenueTicket_PriceBand_id
(→ Music_Bands.id)
12021-12-30Madison Square Garden100.51
22022-01-15Wembley Arena75.32
32021-11-20Staples Center85.753
42022-02-20Sydney Opera House120.94

Fans

idFirst_nameLast_nameAgeEmailFavorite_band_id
(→ Music_Bands.id)
1JohnSmith35johnsmith@email.com1
2AnnaDoe28annadoe@email.com2
3PeterJackson45pjackson@email.com3
4EmmaWhite32ewhite@email.com4

Reviews

idRatingReview_textSong_id
(→ Songs.id)
14Great song! Love the melody.1
25Amazing guitar work!2
33Good song but not my favorite.3
45Awesome lyrics and music!4