SADM 7/ed – ESSS Case Study – Milestone 8: System Proposal SolutionPage: 8-1

MILESTONE 8 – THE SYSTEM PROPOSAL

Activity 1 – Candidate Matrix

T

his matrix could be could completed many ways. Very few students should come up with the same answer unless additional constraints are provided to them to narrow down their list of choices.

Students should have brainstormed and researched alternative candidate solutions and described the candidates in the candidate matrix. At least one of the solutions should include a software package (buy solution). While it may be difficult for them to find a single software package that supports most of the requirements for a new customer response system, it is highly likely that they can find a package that supports some functions.

The important thing for the students to realize is that a variation in one of the cells of the matrix constitutes a different candidate. Therefore, one could come up with several different candidates. The matrix appearing on the next pages is one example of a possible solution.

Instructor Notes:
Characteristics / Candidate 1 / Candidate 2 / Candidate 3
Description of System / COTS package Peoplesoft would be purchased and customized to satisfy ESSS required functionality. / Java web application written for employee-accessible functions (Employee Directory and Update Employee Profile). Java client-server application written for other functions. / Java web application written for all functions.
Portion of System Computerized
Brief description of that portion of the system that would be computerized in this candidate. / Entire Employee Self Service System. / Same as candidate 1. / Same as candidate 1.
Benefits
Brief description of the business benefits that would be realized for this candidate. / Fully supports user requirements.
This solution can be implemented quickly because it’s a purchased solution. (Some business processes might need to be changed to support software processes.) / Fully supports user requirements.
Present programming staff are more familiar with client-server applications, so this solution could probably be rolled out more quickly than candidate 3. / Fully supports user requirements.
This solution would be the most flexible for making all functions accessible from anywhere with just a browser.
Servers and Workstations
A description of the servers and workstations needed to support this candidate. / No additional servers or workstations. / Same as candidate 1. / Same as candidate 1.
Software Tools Needed
Software tools needed to design and build the candidate (e. g., database management system, emulators, operating systems, languages, etc.). Not generally applicable if applications software packages are to be purchased. / Java for customization
Oracle / Java
Oracle / Same as candidate 2.
Application Software
A description of the software to be purchased, built, accessed, or some combination of these techniques. / Package HR system solution from Peoplesoft software. / Custom solution. / Custom solution.
Method of Data Processing
Generally some combination of: on-line, batch, deferred batch, remote batch, and real-time. / Client/Server with Intranet interface / Client/Server
N-Tier Web Architecture / N-Tier Web Architecture
Output Devices and Implications
A description of output devices that would be used, special output requirements, (e.g. network, preprinted forms, etc.), and output considerations (e.g., timing constraints). / Existing LAN Printers / Same as candidate 1. / Same as candidate 1.
Input Devices and Implications
A description of Input methods to be used, input devices (e.g., keyboard, mouse, etc.), special input requirements, (e.g. new or revised forms from which data would be input), and input considerations (e.g., timing of actual inputs). / Keyboard and Mouse
Biometric device for security / Same as candidate 1. / Same as candidate 1.
Storage Devices and Implications
Brief description of what data would be stored, what data would be accessed from existing stores, what storage media would be used, how much storage capacity would be needed, and how data would be organized. / Oracle 10g DBMS (one for each site). / Same as candidate 1. / Same as candidate 1.

Activity 2 – Technical Memo

A

nswers will vary depending on what products are currently on the market and the student's analysis. Look for correct and thorough analysis of the solution alternatives and for an understanding of how each solution alternative would fit the user requirements.

Prepared by Gary B. Randolph for

Systems Analysis & Design Methods 7ed

by J. L. Whitten, L. D. Bentley, & K.C. DittmanCopyright Irwin/McGraw-Hill 2007