Create an er diagram that meets the above requirements

Assignment Help Database Management System

Reference no: EM13813207

In this assignment, you will develop an ER diagram for the given scenario. To complete this assignment, you will need MySQL Workbench. MySQL Workbench is available for free download at www.mysql.com under the Downloads (GA) tab.

Scenario

You have been hired by the sales department of ABC Manufacturing. Mark Harris, the sales manager has requested that you develop an ER model for his customer relationship management (CRM) system that he is proposing. The requirements for the database are:

The model must store mailing and contact information for all clients.

The clients may have multiple contacts.

Each of these contacts may have a different address.

The model must store short description of each e-mail, conversation, or mailing to each client.

The model must attach the client to the assigned sales person.

Harris believes four entities are required to accomplish the above tasks.

Tasks

Using your knowledge of database models and their design, accomplish the following tasks:

In MySQL Workbench 5.2, create an ER diagram that meets the above requirements. Include both Entity Classes and attributes that are necessary, given the above requirements. Save your ER model as an .mwb file.

Reference no: EM13813207

Questions Cloud

Question regarding the change management : For many companies, change is a constant thing. A company that can smoothly navigate organization change is one that is more nimble and better able to meet market demands for products. In this assignment, you will develop a change management plan ..

Arizona constitution affects : Arizona Constitution Affects

Write a paper describing the ilo history : Research the history of international labor standards. Are labor standards feasible? What are the advantages and disadvantages of standards. Write a short paper describing the ILO history and answering the questions about their standards.

Relationship between competition - justice was questionable : What if the argument for the relationship between competition and justice was questionable? Are there advantages to a monopoly?

Create an er diagram that meets the above requirements : In MySQL Workbench 5.2, create an ER diagram that meets the above requirements. Include both Entity Classes and attributes that are necessary, given the above requirements. Save your ER model as an .mwb file

What are some of the characteristics of the war : How did the war begin, and what are some of the characteristics of the war? What social problems did England encounter during this period.

Concept of federalism to shape american political behavior : Examine three to five factors that have allowed the concept of federalism to shape American political behavior

Describe a political behavior you have observed : Describe a political behavior you have observed. What caused the political behavior? How did it influence the organization in a positive or negative way? At least 200 words

What is the social problem the researchers are investigating : What is the social problem the researchers are investigating.

User Account

All Pages