educational course/tutorialoutlet.com educational course/tutorialoutlet.com | Page 66

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