Prime Service is a large service company that provides maintenance and repair services for close to 1,200 commercial businesses in New York, New Jersey, and Connecticut.

Assignment Instructions

For this week’s assignment, you will propose (or illustrate) a database solution enabling service representatives to identify the most important customers so that they could receive priority service. You will use an APA-formatted, illustrative essay to share your proposal.

Scenario: Prime Service is a large service company that provides maintenance and repair services for close to 1,200 commercial businesses in New York, New Jersey, and Connecticut. Its customers include businesses of all sizes. Customers with service needs call into its customer service department with requests for repairing heating ducts, broken windows, leaky roofs, broken water pipes, and other problems. The company assigns each request a number and writes down the service request number, the identification number of the customer account, the date of the request, the type of equipment requiring repair, and a brief description of the problem. The service requests are handled on a first-come-first-served basis. After the service work has been completed, Prime calculates the cost of the work, enters the price on the service request form, and bills the client. This arrangement treats the most important and profitable clients—those with accounts of more than $70,000—no differently from its clients with small accounts. Management would like to find a way to provide its best customers with better service. It would also like to know which types of service problems occur most frequently so that it can make sure it has adequate resources to address them.

Goal: Prime Service has a small database with client account information—including identifiers, account numbers, previous transactions, and the name of service representatives. Create and illustrate a database solution that would enable Prime’s customer service representatives to identify the most important customers so that they could receive priority service.

As your solution requires a UML diagram, read the following sources to create it. Ensure to include these sources in your essay’s appendix.

  • Easy Guide to UML Class Diagrams
  • UML Class Diagram Relationships

In your paper, be sure to utilize the textbook and integrate at least five peer-reviewed sources along with their citations and references. Your paper must be APA formatted and include at least 1250 words. The cover page and references are not included in the number of words.

1250 words, delivery date and time is 3rd September 10 am.

find the cost of your paper

Is it likely that Goldman Sachs will be able to hire the best and brightest recruits unless they change the culture described?

ETHICS CASE Questionable Values Produce Resignation at Goldman Sachs Allegations of serious impropriety and perhaps illegality surrounding Goldman Sachs’s contribution to the 2008 financial crisis have been well publicized. Allegations….

Explain how Braintrust can link their compensation and evaluations to the company’s new objectives and innovation strategy.

Braintrust Toys is a toy maker that has as its mission, “Our purpose is to expand the minds of children 1 month–100 years old.” Currently they use a product development….

Analyze and discuss the five key elements of successful change management.

Overcoming barriers to change: A Corus case study Overview of the Case: Corus was formed in 1999 when the former British Steel plc merged with the Dutch company, Hoogovens. Corus….