- Adding the AlbumName Field
Next we create a field to store the name of the album. The data type varcharstands for variable number of character and stores a string of up to 225 characters.
- Adding the AlbumArtist Field
This field also stores a variable number of characters and its string is limited to only 80 characters.
- Adding
the AlbumType Enumerated Type Field
The enumerated type ENUM is a string object that has set of values that are allowed. In our case, the allowed values are ‘L’ for Long Play (LP), ‘E’ for Extended Play (EP) and ‘M’ for a mix tape.