Music Master

Schema for ASSIGNMENT 11

platz_brian_albums(

albumID int PRIMARY KEY,
albumTitle varchar(25),
artist_id int,
yearReleased int,
*coverArt varchar(30),
media int
)

platz_brian_artists(

artistID int PRIMARY KEY,
artistName varchar(25)
)

*platz_brian_album_songs(

albumID int,
songNumber int,
songTitle varchar(20),
songLength int
PRIMARY KEY albumID, songNumber )

platz_brian_media(

mediaType int PRIMARY KEY,
mediaString varchar(10)
)

* Note: platz_brian_album_songs would be used to hold songs for each album, but is not implemented in this project. The coverArt field of platz_brian_albums is not fully implemented, but would hold a path to a jpg or png file of the cover art for the album.