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.