Propose (or illustrate) a database solution enabling service representatives to identify the most important customers so that they could receive priority service.

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

Description of the how the software selection criteria (and which ones) were chosen for your company

Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final….

How can Layla use JavaScript custom objects to create the Customer List feature for the Web site?

Layla just got hired as the Web developer for a small business called Axe Grinders, which sells and repairs guitars and amps. The aging rock 'n' rollers who own Axe….

Critical analysis of networking requirements.

You have been appointed as a Network System Administrator by the SoftTech company in Sydney to allocate public IP Version 4 (IPv4) address into 3 different locations, “2 remote offices….