Entity Relationship Diagram (ERD)
Artists
- ArtistID
- Name
- GenreID
- RecordLabelID
Albums
- AlbumID
- Title
- ReleaseYear
Songs
- SongID
- Title
- AlbumID
- GenreID
Playlists
- PlaylistID
- Name
- Description
Concerts
- ConcertID
- ArtistID
- Venue
- Date
Relationships:
- Artists.GenreID → Genres.GenreID
- Artists.RecordLabelID → RecordLabels.RecordLabelID
- Songs.AlbumID → Albums.AlbumID
- Songs.GenreID → Genres.GenreID
- Concerts.ArtistID → Artists.ArtistID
- AlbumArtists.AlbumID → Albums.AlbumID
- AlbumArtists.ArtistID → Artists.ArtistID
- PlaylistSongs.PlaylistID → Playlists.PlaylistID
- PlaylistSongs.SongID → Songs.SongID
Music Database Tables
Artists
| ArtistID |
Name |
GenreID |
RecordLabelID |
| 1 | The Beatles | 1 | 1 |
| 2 | Taylor Swift | 2 | 2 |
Albums
| AlbumID |
Title |
ReleaseYear |
| 1 | Abbey Road | 1969 |
| 2 | 1989 | 2014 |
Songs
| SongID |
Title |
AlbumID |
GenreID |
| 1 | Come Together | 1 | 1 |
| 2 | Blank Space | 2 | 2 |
Genres
Playlists
| PlaylistID |
Name |
Description |
| 1 | Favorites | Top songs of the year |
Record Labels
| RecordLabelID |
Name |
| 1 | Apple Records |
| 2 | Big Machine |
Concerts
| ConcertID |
ArtistID |
Venue |
Date |
| 1 | 1 | Madison Square Garden | 2023-07-15 |
AlbumArtists
PlaylistSongs