## Music_Bands

id | Name | Genre | Founding_Year | Country
--- | --- | --- | --- | ---
1 | The Jazz Connection | Jazz | 1985 | USA
2 | Blue Note Ensemble | Jazz | 1990 | Canada
3 | Guitar Legends | Rock | 1985 | UK
4 | Vocal Vibes | Rock | 1993 | Australia

## Albums

id | Title | Release_Date | Label | Genre
--- | --- | --- | --- | ---
|  |  |  | (→ Music_Bands.Name)
1 | First Impressions | 2000-06-15 | Warner | Jazz
2 | Melodic Memories | 2005-03-05 | Universal | Jazz
3 | Strumming Strings | 2002-02-20 | EMI | Rock
4 | Heavy Metal Beats | 2010-10-15 | Columbia | Rock

## Songs

id | Title | Length | Album_id
--- | --- | --- | ---
|  |  | (→ Albums.id)
1 | Night Flight | 3.5 | 1
2 | Dreamy Skies | 4.2 | 2
3 | Thunderous Riffs | 3.8 | 3
4 | Acoustic Journey | 4.1 | 4

## Concerts

id | Date | Venue | Ticket_Price | Band_id
--- | --- | --- | --- | ---
|  |  |  | (→ Music_Bands.id)
1 | 2021-12-30 | Madison Square Garden | 100.5 | 1
2 | 2022-01-15 | Wembley Arena | 75.3 | 2
3 | 2021-11-20 | Staples Center | 85.75 | 3
4 | 2022-02-20 | Sydney Opera House | 120.9 | 4

## Fans

id | First_name | Last_name | Age | Email | Favorite_band_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Music_Bands.id)
1 | John | Smith | 35 | johnsmith@email.com | 1
2 | Anna | Doe | 28 | annadoe@email.com | 2
3 | Peter | Jackson | 45 | pjackson@email.com | 3
4 | Emma | White | 32 | ewhite@email.com | 4

## Reviews

id | Rating | Review_text | Song_id
--- | --- | --- | ---
|  |  | (→ Songs.id)
1 | 4 | Great song! Love the melody. | 1
2 | 5 | Amazing guitar work! | 2
3 | 3 | Good song but not my favorite. | 3
4 | 5 | Awesome lyrics and music! | 4