| 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 |
| 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 |
| 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 |
| 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 |
| id | First_name | Last_name | Age | 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 |
| 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 |