System Analysis Report for ChemExec

BIT232 Systems Design & Development
Assessment 2
Design refinement
Systems Design & Implementation Report

SYSTEM ANALYSIS REPORT FOR CHEMEXEC
PREPARED BY:
SUBMITTED TO:

Executive Summary
After years of using a combination of computerized and manual methods to man its operations,
ChemExec needs to computerize its operations. The failure to do so in the past years has led to
cumbersomeness brought about by the growth of the company and increase in its operations.
This inefficiency has resulted into losses for the company. The proposed system is intended to
help streamline order processing, delivery, billing and other management tasks. The existing
system has health facility employees deliver orders via telephone at all hours of the day, and then
ChemExec does delivery of the orders in two cycles, every twelve hours. The systems for taking
orders, billing and inventory are not integrated or synchronized. The new system should allow
the company’s clients to place orders via a web portal, and the employees to be able to process
them efficiently. More than that, the system should be able to manage the employees of the
company, monitor ranks and schedule shifts. This should simplify records of who was in charge
of assembling cases, delivery and supervision of the same. The system should also automate
actions such as generating case manifests and billing information. This kind of improved
efficiency should help in the growth of revenue for the organization as it will be easier to track
sales due to ease of generating reports, and therefore aid decision making by the company
executives. The separate spreadsheet and database applications will be consolidated into one
database application with appropriate interfaces for its users. This report covers the logical
design of the system in addition to security plans, project management and implementation
strategies that will be used during the entire system development life cycle.

Table of contents
Table of Contents
Executive Summary.....................................................................................................................................3
Table of contents.........................................................................................................................................4
Task 1: Class Diagram.................................................................................................................................5
Task 2:.........................................................................................................................................................5
Task 3: Security...........................................................................................................................................7
Task 4: Database Schema............................................................................................................................9
Task 5: Implementation of the system.......................................................................................................11
Task 6: Project Management.....................................................................................................................11
Technical Risk factors...........................................................................................................................11
BIBLIOGRAPHY...........................................................................................................................................13