COM 320 – Systems Analysis and Design
Course Project
Developing or updating an information system is not only a technical challenge; in fact, it’s also a whole
business package. Therefore, it will be advantageous for you to search and evaluate the business,
technical, and soft skills (interpersonal and intrapersonal) needed to complete a productive information
system. As a part of the course requirements, you will perform a systems analysis and design on a
business or operation. You are encouraged to start thinking about your project from the first day of class.
Please note that this class is one of the most important classes in the CIS curriculum. Many of the skills
that you have acquired thus far will be applied here.
Regardless of your topic, you must complete the first three phases of the system development life cycle
(SDLC) process:
1. Analysis of the business case
2. Systems analysis
a. Requirements modeling
b. Data and procedures modeling
c. Object modeling
3. Systems design
a. Input design
b. Output design
c. User interface
Project Choices
Listed below are two possible approaches to the completion of the project. Once you choose an
approach for your project, you must send your project choice to the instructor by email no later than
Sunday 11:59 PM EST/EDT of Module 1. The project will utilize structure analysis as the preferred
methodology. The final outcome is expected to be submitted as a PDF file.
Project 1: Cloud computing has become a viable and competitive option to the client/server networking
model due to its lower cost, scalability, and agility. A local business in your town has asked you to
develop a full plan, an analysis to determine the requirement and a design to specify the input, output,
and processing prerequisites. Since you are a knowledgeable systems analyst, you have decided to take
the job. You understand all the benefits that come along with cloud computing. To assure a functional
development life cycle, you have also decided to point out any negative issues with cloud computing
such as security, untested new technologies, and training requirement. You are aware that it should take
no more than seven weeks to complete the first three phases of SDLC.
Project 2: A midsized business with 100 end-users has asked you to develop a new intranet with a
prioritizing requirement list. It is clear to you that the business cannot function without an intranet these
days. After the initial meeting with CFO and IT director, you were asked to start the job. They want you to
produce a preliminary investigation report stating the following:
1. The problem or the opportunity
2. Define the project scope and constraints
3. Problem fact findings
a. Analyze organization charts
b. Review documentation
c. Conduct a user survey
4. Study usability, cost, benefit, and schedule data
5. Evaluate feasibility
a. Operational
b. Technical
c. Economic
6. Present recommendation to management
You describe the system analysis phase activities by:
1. Listing and describing system requirements including inputs, outputs, processes, performance,
and controls
2. Using fact-finding techniques, including: interviews, documentation review, observation,
questionnaires, sampling, and research
3. Defining total cost of ownership (TCO)
Finally, you need to:
1. Design a successful interface design
2. Design effective source documents and forms
3. Describe output and input controls and security
Software required to complete the project include MS Word, MS Excel, PowerPoint, Visio (or similar
package), MS Project, and a statistical package. You may use trial versions of MS Project and Vizio.
When using Visio, MS Project, or similar software, ensure that you publish any work as either an
image file (.jpeg, .png, etc.) or a pdf before incorporating it into your course project. This is to
ensure that your instructor can view/grade your project.
Submit the Course Project to Chalk and Wire using the link in the Module 7 folder no later than Sunday
11:59 PM EST/EDT of Module 7. Students who do not submit the assignment to Chalk and Wire will
receive a zero. This is a key program assessment; the results are used to ensure students are meeting
program goals. Video and PDF instructions can be found on the course home page. PDF instructions are
also located in the Start Here folder.
CanFitPro
Capstone Project: CanFitPro
CanFitPro Fitness centre
110-225 Select Ave - Toronto, ON - M1X 0B5
Phone: 1 (800) 667-5622
1
CanFitPro
Table of Contents
1.0 Business Profile
4-7
1.1 Project’s Program
7
1.2 Constraints
7
1.3 Staff Organizational Chart
8-9
1.4 System Requirements for Accounting System and Web Page
10-11
1.5 Benefits Accounting and Web Base Data Systems
11-12
1.6 Time and Cost Estimates
12-14
1.7 Space Program
14-17
1.7 SWOT Analysis Phase
11-12
1.8 Preliminary Investigation
14
1.9 Feasibility Estimates
15-16
2.0 Overview of Proposed Computer System Function
16-17
2.1 Process Models
23-28
3.1 Statement of System Requirements
28- 30
3.2 Solution Candidates
30- 32
3.3 Software candidate weighted evaluation
3.4 Hardware/Software costs
33
34-35
2
CanFitPro
3.5 Revised Feasibility Analysis
35-40
3.6 Implementation Plan Time estimate
41
3.7 Security Plan
41-45
3.8 Risk Management Plan
45-46
3.9 Switchboard’s
46-49
3
CanFitPro
Business Profile and Business Processes
CanFitPro Mission
Canada nowadays is starting to be more aware of the importance of physical activity. The
number of unhealthy cases is increasing in Canada, obesity, and malnutrition is the top most
priority. This is becoming a major issue, according to the World Health Organization.
4
CanFitPro
Most Canadian are not as active as they could and getting themselves involve in the fitness
programs. Increasing intake of fast foods is found mostly in the younger generations (which
makes 70% of population) tend to make unhealthy decisions in their food choices.
So we shall focus on to change their lifestyle.
5
CanFitPro
CanFitPro Services
CanFitPro Future Goals
CanFitPro Web portal will allow customers to get themselves registered for online coaching
of the fitness program, online services will be rendered to the end-users, members from the
various location can get themselves registered for a selected fitness program and can avail all
the services which CanFitPro provides at the registered centre. Customers who are getting
themselves registered their personal information is consolidated at one place in the central
database of the CanFitPro.
Upgrades membership Formulas for the CanFitPro customers.
6
CanFitPro
CanFitPro Objective
Encourage people to maintain a healthy lifestyle.
Prevent the increasing amount of under nutrition.
Create an environment that would encourage incomers to be physically active.
Hold events that promote health and fitness.
7
CanFitPro
CanFitPro Project’s Program
CanFitPro Constraints
•
Experienced Web Designers, who have experience in mobile and web designing.
•
Interface to tackle day-to-day activities.
•
Technical Staff to look after the maintenance, software, and hardware up gradation.
•
Employees should be trained to gain basic computer skills.
•
Scheduling training for employees during working hours along with their day-to-day
activities.
8
CanFitPro
CanFitPro Staff Organizational Chart
9
CanFitPro
CanFitPro, System Requirements for Accounting System
•
The system should have a feature to make up the future dated appointments.
•
The system should have an advanced feature to generate progress reports on a daily basis
and monthly billing statements.
•
Member Information should be recorded at the central database and shall be accessible to
all respective departments.
•
A record of member information, training programs they have availed, and membership
they are undertaking and progress of the undertaken fitness program, such information
respective to each member should be up-to-date.
•
End users should bear good response time with least amount of latency involved in the
system response times.
•
DBA should be capable enough to retain daily backup’s process.
10
CanFitPro
CanFitPro, Benefits the Accounting and Web Base Data
Systems
Reduction in Cost
• Poor manual handoffs would be avoided in future when dealing with data between
departments in future.
• Data processing electronically will increase the individual productivity as manual work
will be reduced and all the activities can be automated such as scheduling the reports and
preparing the mailing lists.
Increased in generated revenue
• When the process gets automated, manual processes will be outdated and employees can
perform more activities simultaneously and will generate the value for the organization.
•
Reports depicting the outstanding balance and transaction for an individual.
Ability to Implement Changes
•
Data processing electronically can be easily monitored, stored and processed to various
levels of memberships and special services for the future.
11
CanFitPro
Improving the Customer Service Experience
• Manual errors would be reduced once the system get automated
•
Internal customers will benefit from schedules/reports produced accurately and in a timely
manner.
CanFitPro, Time and Cost Estimates
12
CanFitPro
13
CanFitPro
CanFitPro, Space Program
Distribution of zones
14
CanFitPro
15
CanFitPro
16
CanFitPro
CanFitPro, SWOT Analysis
17
CanFitPro
A SWOT analysis determines the strength, business goals of an organization, what all
weakness and how to eliminate them completely, what all opportunities are left with an
organization and how to take advantage out of them, what all threats which are pose to an
organization and possible measure to manage the possible risks involved.
CanFitPro Strengths
o CanFitPro provides customized reports related to undertaken program, online
platform for booking the fitness plan, online scheduling various process and
enrol into online coaching undertaken by a fitness instructor.
o CanFitPro has research oriented health and wellness program with effective
trained and experienced trainers.
18
CanFitPro
CanFitPro Opportunities
o CanFitPro can make use of online advertisement, promotion, Facebook
boosting and can achieved fame and promotion from existing fitness centre.
o CanFitPro can make future quantitative analysis.
CanFitPro Weakness
o CanFitPro technical instructor staff lack of experience and skills required up to
the market.
o Hug amount of Investment required for initial setup.
CanFitPro Threats
o DDOS attach on the website portal.
o CanFitPro can bear the competition with exiting firms.
19
CanFitPro
CanFitPro, Preliminary Investigation Process
CanFitPro Project Definition
CanFitPro main objective is to promote healthy lifestyle by ensuring physical activity and
generating awareness to maintain a healthy lifestyle. To ensure that proper nutrition level is
maintained for every single individual.
CanFitPro Project’s Objective
1. Maintain a healthy lifestyle for every single individual.
2. Maintaining a certain level of nutrition for every individual.
3. Encourage a physically activity among the people.
4. Yoga events, hold nutritious food events in order to promote health.
CanFitPro, feasibility Analysis Phase
CanFitPro Operational Feasibility
•
New proposed system would reduce the manual work done by the employees and
new system when installed will demand proper training to ensure the correct usage of
the system.
• Customers can avail better customer service and can access account records based
on roles.
20
CanFitPro
CanFitPro Technical Feasibility
•
New software systems has to be installed, hardware systems should be up to date,
communication network system should be capable enough to capture huge amount of
fibre data transferred over the network.
•
Web site should be under go maintenance, required enhanced features should be
brought to the market to develop Proof-of-concept.
CanFitPro Economic Feasibility
Total Cost of Ownership, Tangible Benefits and Intangible Benefits
•
If system is not in the market then employees have to be perform all task
manually, there is a risk of human errors to be involved. There might be a chance of
losing the data.
•
Would reduce the manual efforts to maintain the administrative tasks up to date.
•
New proposed system would reduce the manual efforts in maintaining the
customer’s personal information, daily, monthly reports related to fitness health
corresponding to the program undertaken by the customer.
CanFitPro Schedule Feasibility
•
Around 6 months would be sufficient amount of time to finish implementing the
system.
21
CanFitPro
CanFitPro, Proposed Computer System Functionality
Output
• Appointment list generation on daily basis.
•
Customizable Report generation to measure the progress and set up the
future goals for an individual health.
•
EFT generation reports, transaction processing reports, financial reports
and sales trends should be generated on monthly basis.
•
Customized training programs for an individual.
Inputs
•
Online sales generation events, registration, and account monitoring.
•
Online payments portal for transactions.
•
Reservation system portal to reserve an appointment in future and to avail various
services.
•
Keep record of member personal information, membership they are availing and
training programs undertaken by them.
Process
•
List of members should be generated either on daily basis or weekly basis to track
the customers who are not meeting up their goals and assign the respective counsellor
to take follow-up.
22
CanFitPro
Performance
•
System shall support 200 plus users.
•
Least amount of latency in the response time and maximum of 2 sec delay is
tolerable.
•
The system must be operational seven days a week.
Controls
•
Role based login security.
•
Facility Managers can add, update or delet the various other members.
•
The separate level of security roles for users.
•
Ensure backup capability
23
CanFitPro
Process Models
Daily client use
Member Training Records
Operations
Member Statements
Manager
(Corporate and Each
Facility)
MTD / YTD Report
Client Payments
Member Statements
Customer Information System
Facility Sales Trends
Customer Data
Promotional Sale Trends
Facility Revenues
Accounting
Sales &
Marketing
Promotional Sales
Member Payments
Figure1: DFD-0 Diagram
Daily client use
Member Training Records
Member Information
Operations
(Corporate and Each
Facility)
Client Payments
Member Statements
Member Records
Member Purchaces
Customer Data
Facility Revenues
Accounting
Promotional Sales
Member Payments
Figure2: DFD – 1 Diagram
24
Sales &
Marketing
CanFitPro
Figure3: DFD Diagram
Figure4: FDD Diagram
25
CanFitPro
Figure5: Use Case Diagram
Figure6: State transition diagram
26
CanFitPro
Figure7: Sequence diagram
27
CanFitPro
Figure8: Object Relation Pattern Diagram
28
CanFitPro
CanFitPro, Task List and Duration
CanFitPro, Task and their Predecessor Tasks
29
CanFitPro
CanFitPro, Pert Chart
30
CanFitPro
CanFitPro, Gantt chart Diagram
CanFitPro, System Requirements
System Requirements are such that configured a system to intake user input and
generate respective output.
• Record member information on daily basis
Online payments services portal
• Appointment list generation
31
CanFitPro
• Portal for online payment services and registration interfaces to record member
information.
• Role based security level to ensure safety of personal and accounting information of
the customers.
System should be such configured user may find easy to input personal bio-data
• Customer should get themselves registered using members registration form
• Portal to track accounts data, EFT generation, transaction history
• Customer program progress tracking and performance
Service Level Agreement
• System should be capable enough to handle at least 150 plus users.
•
Least latency should be involved in response time, response should be received with
maximum delay of 3 seconds
• System should provide support to the end-users 24 hours 7 days a week.
Security
•
Login security to all users, at the application level and at the operation level.
• Performing a delete operation should only be undertaken at administrator level.
• Role based security level must be provided at the operation level.
32
CanFitPro
Solution Candidates
Pre-packaged Software Systems
•
Collecting member Information through registration form
•
Customizable Reports generation capturing the progress achieved when
undertaken a specific program
•
Role based security level and entry of data at various managers’ levels
When Bundled as Commercial Software
•
Customizable Member Searching mechanism
•
Time specific bill preparation wrapper
•
Round Robin mechanism for class scheduling
•
Electronic billing and invoice generation mechanism
•
Real-time entries of member information
•
Customize reports generation mechanism and tracking of the progress when a
particular program is undertaken.
•
Support System 24/7
33
CanFitPro
In Development and Outsourcing
•
Keep record of customer’s personal information
•
Keep record of services which we provide, which instructor is undertaking which
program and services undertaken by the customers.
•
Track customer gyms visits, membership they are availing, exercises they
undertake, amount of the time spend by the customer and quality of exercise
performed by the customer.
• Track customer training programs and measures progress
•
Track Customer accounts data
•
Track payments made by the end-users and keep record of the transactions
•
Ability to generate reports
34
CanFitPro
Software candidate weighted evaluation
Feasibility Criteria
Operational Feasibility
Wt.
30%
Commercial Software
integration
In House development
& Outsourcing
Rate
Functionality.
A description of to what degree
the candidate would benefit
the organization and
how well the system would work.
Alow importsation of currents datat
bases into a more relible system
and ease daily operations
Allows for updating current
softeware and interfacing with
new Web interface allond with
4 the new design database
Political.
A description of how well received
this solution would be from both
user management, user, and
organization perspective.
System provides on site training
and support
System provides on site
3 training and support
Operational Score
Technical Feasibility
Rate
4
3
2.1
2.1
30%
Technology.
An assessment of the maturity,
availability (or ability to acquire),
and desirability of the computer
technology needed to support
this candidate.
Current suggested hardware
configuration will support the
software
Current suggested hardware
configuration will support the
3 software
5
Expertise.
An assessment of the technical
expertise needed to develop,
operate, and maintain the
candidate system.
Requires additional training to
develop reporting
Canned reports and
customized reports with limited
user knowledge. New Training
3 will be minimal
5
Technical Score
Economic Feasibility
1.8
30%
Cost to develop:
Payback period (discounted):
Net present value:
Expected LifeSpan
Detailed calculations:
Economic Score
Schedule Feasibility
An assessment of how long
the solution will take to
design and implement.
4
10000
7000
0
0
10000
7000
3
5
0.9
1.2
10%
Customization and implementation
4 weeks
Schedule Score
Ranking
3
3
Customization and
4 implementation 4 weeks
10
100%
Hardware/Software costs
35
4
0.4
0.4
5.2
6.7
CanFitPro
Revised Feasibility Analysis
Operational Feasibility
• When CanFitPro would be updated to proposed solutions then employees can
perform the daily activities online, can manage the activities and will reduce the
human errors.
•
Customer can generate progress report on daily or monthly basis and can measure
their progress against the program undertaken.
•
Intangible cost is involved where employees need to be trained to use the updated
system, to keep records of their activities on the new proposed system.
• On establishing this new system would reduce the work pressure to perform dayto-day activities, such those activities would get automated in the new environment.
Technical Feasibility
• Hardware with Intel core 7 and up to date software has to be installed as a set up
for the proposed system. All hardware and software need to be purchased for initial
installation of the proposed system. Later we need to integrate the system with day-today activities.
• Support has to be provided for any technical support. Training need to be provided
to the users to support their activities.
36
CanFitPro
•
Hiring should be initiated where candidates have prior knowledge related to the
technology and can easily cope up with the new proposed system.
Economic Feasibility
Total Cost of Ownership
•
Initial investing in training the users
• Updates of Hardware and software
• Support and maintenance
Tangible Benefits
•
CanFitPro can provide with the interface where customers can generate the reports
to measure their progress against the program undertaken and overdue payments.
• Insurance paperwork where it used to take a day or more can be done in short span.
Intangible Benefits
•
CanFitPro will initiate the job satisfaction among employee.
•
CanFitPro can easily make up the backup if any data corruption do take place as
database system is at one place will allow faster customer service.
•
Electronic files will reduce manual errors.
37
CanFitPro
Schedule Feasibility
•
Enough manpower is required to develop, employ, and train users
•
Employees will focus to accomplish daily tasks on the new system itself.
Implementation Plan Time estimate
38
CanFitPro
Security Plan:
Security Plan is initiated as a precautionary measure to avoid any miss-happenings in past
plans. DDOS attack on a business, shut down of a server for a day can lead to loss of
business. An overview of security plans consist of the security measures to avoid security risk
in future and undertaking prompt action. Indeed, planning to prevent any future threats.
Since we have limited time, resources, and running out of cash. Before developing the project
the team has weighed all the above mentioned constraints carefully and meet the cost,
comfort, and security constraints. Indeed, the management hierarchy has agreed that we need
to update the existing system to meet up the new goals and company to continue to grow.
Following people are authorized to view this document and are part of CannFitPro
Organization Chart:
39
CanFitPro
Members of the Project Team
People from sales, design and marketing also put initiate to give feedback about the plan.
Assessment Results
Skills and Knowledge
Each and every project members have gone through the security planning guidelines
and will ensure to educate each member of an organization.
Our Network and Systems
•
Desktops: 17
•
Laptop computers: 5
•
Printers: 3
•
Servers: 3
•
Routers: 7
40
CanFitPro
Security
•
Virus protection need to be covered with auto-updates.
•
Spam-filtering software, to detect the Malware introduction.
•
Encrypted Firewall to protect customer information
•
Windows 7 Professional systems should be up-to-date.
•
Frequent chaining passwords.
•
Computers must have logged off as a measure of physical security. Avoid writing
the passwords at some place.
•
Web browsing record must be undertaken in some logs file just for audit purpose.
•
Frequent Backups
•
Customer information
•
Records of our contracts with vendors
•
Sales orders
•
Financial information
Assets
41
CanFitPro
We believe the risks break down into four main categories:
•
Intruders such as viruses, worms, hijacking, involves High risk.
•
External threats such as rivals, disgruntled ex-employees involves High risk
•
Internal threats are of lower risk level when a member of staff may misuse his or
her privileges to disclose confidential information.
•
Accidents and disasters. Fires, floods are of Low risk
Priorities
1.
Intruder deterrence:
•
2.
Theft prevention:
•
3.
Laptop computer security, security locks for laptop
Disaster prevention:
•
4.
Firewall, Virus protection
Frequent backups, backup of users’ data and testing the backups.
Internal security and confidentiality:
•
Strong password, security for filing confidential documents
42
CanFitPro
Section 3: Security Plan
Action Items
1. Enable Windows Firewall on server side
2. Antivirus software installation
3. Security locks ups for laptops
4. Restore backup procedures.
5. Configure logs to keep records.
User Education
We expect to give up to two hours of user training about:
•
The importance of security
•
Encrypted laptop
•
Updating software
Project Time Line and Responsibilities
Firewall, virus protection, and strengthening the wireless network should be at the top
most priority.
43
CanFitPro
Section 4: Resources and Budget
Software and Hardware
•
Required antivirus software.
•
Firewall
• Regular backup
•
Security locks
Risk Management Plan
Department: IT Consultants
Product or Process: In-House Development and Outsourcing
Document Owner: Clinton
Project or Organization Role: IT Modifications for CanFitPro
44
CanFitPro
45
CanFitPro
46
CanFitPro
47
CanFitPro
Switchboards
Main Switchboard:
48
CanFitPro
Registration form:
Customer Registration Form
49
Purchase answer to see full
attachment