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 |