Create the erd for this solution using visio

Assignment Help Computer Engineering

Reference no: EM133359760

Case Study: 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.

Question:

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.

Reference no: EM133359760

Questions Cloud

Determine a strength and a weakness of thesaurus approach : We can also deal with the same problems with probabilistic or statistical methods (in particular with vector models). Determine a strength and a weakness

Main relationship between planning and control : The main relationship between planning and control is to. One of the four functions of management is planning, which means?

How many committees are needed to take the necessary steps : HS 4121 Texas Woman's University How many committees are needed to take the necessary steps of the peer review process? Especially for an organization like

Summarize the incident and consequences in your own words : Summarize the incident and consequences in your own words. Citation is not required. To make sure you meet the 100-word minimum requirement for the initial

Create the erd for this solution using visio : Create the ERD for this solution using VISIO. Add the appropriate attributes for each entity in VISIO. Identify the correct datatype for each attribute

What does the last mile problem mean in blockchain : What does the last mile problem mean in blockchain, and how do we resolve it?

Once the restructuring process has started : John is the CEO of an industrial company that is having many more sales than budgeted. Once the restructuring process has started, which is the next step?

What you have learned from the banas database : what you have learned from the Banas database "create a" songbook database. Each book has 10 songs. It has a publication date and a name. Each song has a name

Illustrate adam smiths invisible hand in the sense : Behavior of an individual and fulfillment of his own interest results in welfare of the society as well whether the individual intends or not

User Account

All Pages