CSIS 325CMS PROJECT – PHASE I INSTRUCTIONS FOR MORE CLASSES VISIT
www. tutorialoutlet. com
CSIS 325CMS PROJECT – PHASE I INSTRUCTIONS FOR MORE CLASSES VISIT
www. tutorialoutlet. com
CMS PROJECT – PHASE I INSTRUCTIONS Part A: Background Information: CMS Systems, Inc. is a company that provides information systems consulting services to companies in the telecom industry in the United States and the United Kingdom. Due to its success, CMS is hoping to expand its operations into other parts of Europe. Despite its large size, CMS currently uses a manual / spreadsheet-based process for maintaining employee and client data. Management has now decided to implement a company-wide database that will serve all of its operations. CMS currently employs 1,500 individuals( 900 in the US and 600 in the UK) who serve as systems analysts, developers, managers, testers, maintenance engineers, accountants, lawyers, and sales representatives. Each employee has a first name, last name, unique CMS ID, office location, email address, salary, title, level, and supervisor. CMS has more than 200 clients in the US and UK. Clients are identified by various names by CMS associates. As such, they represent a source of confusion for the company. The legal department refers to clients by their legal names, while the sales and consulting departments refer to them by a more common name. One example is British Telecom. CMS‘ s legal team uses its full legal name ― British Telecom, Ltd.,‖ while the sales force and consultants refer to it as ― BT.‖ The accounting department uses a mixture of legal and common names to identify clients. Thus, to avoid confusion, both legal and common names must be available to all users. Data that must be kept about clients include client names, an address( city, state, zip, country), and contact information