User Account

All Pages

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.

Reviews

Write a Review

Database Management System Questions & Answers

  Examine a query written against the database

Examine a query written against the database. You will examine the entity/relationship diagram (ERD) and in writing explain what information the database is holding (not the specific data, but in words what the business application is and how that ..

  Create an action query that makes a table called westcoast

Create an action query that makes a table called WestCoast, with the following records. CA, WA, OR Create an action query to add the NV records to the newly created WestCoast table.

  Create a form for the product table

Create a form for the Product table. Create a report for the Product table. grade will be based on the quality of your design and presentation

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  Explaining database security relate to data integrity

In talking about database security, some aspects to regard as are Data Integrity, Confidentiality, and Malicious Activity. Illustrate how does database security relate to data integrity?

  How would you define a relational database

How would you define a relational database? What is "normalization" and why do we normalize DBs

  Describe how you created the conceptual and process

Describe how you created the conceptual and process view for all four (4) diagrams. In the description, be sure to provide a justification for each key decision in the design.

  Assignmentwrite a assignment to study and modify the

assignmentwrite a assignment to study and modify the postgresql source code with a focus on one of the core modules -

  Analyze how the data breach could have been prevented

Analyze how the data breach could have been prevented with better adherence to and compliance with regulatory requirements and guidelines, including management controls; include an explanation of the regulatory requirement (such as from FISMA, HIP..

  Provide an entity relationship diagram

Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards. Provide a logical and physical design of the database. Use relational database software application to d..

  Problem 1 produce a scatterplot of rent vs size square

problem 1. produce a scatterplot of rent vs. size square meters of the apartment for the rental data in

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd