## Genres

id | name
--- | ---
1 | Pop
2 | Rock
3 | Jazz
4 | Country
5 | Hip Hop

## Artists

artist_id | artist_name | genre_id
--- | --- | ---
|  | (→ Genres.id)
1 | Artist A | 1
2 | Artist B | 2
3 | Artist C | 3
4 | Artist D | 4
5 | Artist E | 5

## Pop_Songs

song_id | title | artist_id
--- | --- | ---
|  | (→ Artists.artist_id)
1 | Pop Song 1 | 1
2 | Pop Song 2 | 2
3 | Pop Song 3 | 3
4 | Pop Song 4 | 4
5 | Pop Song 5 | 5

## Hip_Hop_Songs

song_id | title | artist_id
--- | --- | ---
|  | (→ Artists.artist_id)
1 | Hip Hop Song 1 | 1
2 | Hip Hop Song 2 | 2
3 | Hip Hop Song 3 | 3
4 | Hip Hop Song 4 | 4
5 | Hip Hop Song 5 | 5

## Concerts

concert_id | venue_name | artist_id | pop_song_id | hip_hop_song_id
--- | --- | --- | --- | ---
|  | (→ Artists.artist_id) | (→ Pop_Songs.song_id) | (→ Hip_Hop_Songs.song_id)
1 | Madison Square Garden | 1 | 1 | None
2 | The O2 Arena | 2 | 2 | None
3 | Staples Center | 3 | 3 | None
4 | Barclays Center | 4 | 4 | None
5 | Prudential Center | 5 | 5 | None
6 | Madison Square Garden | 1 | None | 1
7 | The O2 Arena | 2 | None | 2
8 | Staples Center | 3 | None | 3
9 | Barclays Center | 4 | None | 4
10 | Prudential Center | 5 | None | 5

## Venues

venue_id | venue_name
--- | ---
1 | Madison Square Garden
2 | The O2 Arena
3 | Staples Center
4 | Barclays Center
5 | Prudential Center