Melikealot Records has started a new business. To help them grow, they want you to develop a database for them that will capture their customers favorite songs. The shoppers would go online and via a list of music and its artist that will be displayed the users would select and add to their favorite song list. This will help the business to know what musicians to carry and material they should carry for each singer. At anytime the customers can add and delete from their list. For customers, Melikealot Records would like to know common demographic type information. That is First Name, Last Name, Address, City, State, ZIP. In addition, they would like to be able to filter the data based on Gender, Race, and Age. For the songs, the name of the song, the date recorded, the genre, and the record label where the song was recorded is suffice. For the musicians, their name is only needed. 1. Create the ERD for this solution using VISIO. 2. Add the appropriate attributes for each entity in VISIO. 3. Identify the correct datatype for each attribute and note them by the attribute name. 4. Apply the Primary Key to each entity by identifying the Key in VISIO for each entity.

1. Create the ERD for this solution using VISIO.

2. Add the appropriate attributes for each entity in VISIO.

3. Identify the correct datatype for each attribute and note them by the attribute name.

4. Apply the Primary Key to each entity by identifying the Key in VISIO for each entity.