ISY2001 Case Study: Analysis and Design of Student Registration System

This document presents a comprehensive case study on the system analysis and design of a student registration system for North Hill College. It begins with a justification for developing the system, highlighting the benefits of automation, reduced registration hassles, and improved security. A detailed business case outlines the context of the educational institution. The project scope encompasses key functions such as logging in, storing student information, course enrollment, and course updates. The document provides a thorough cost and schedule analysis, including a Gantt chart and a cost-benefit analysis that demonstrates the system's economic viability. Various diagrams, including use case, sequence, data flow (context and level 0), and ER diagrams, visually represent the system's functionality and data structure. Screen interfaces are also included. The project concludes with a bibliography of relevant sources.

Running head: SYSTEM ANALYSIS AND DESIGN
System analysis and design
Name of the Student:
Name of the University:
Author Note

1
SYSTEM ANALYSIS AND DESIGN
Table of Contents
Need for the development of the system.........................................................................................2
Business Case..................................................................................................................................2
Business Benefits of system implementation..................................................................................2
Project scope....................................................................................................................................3
Costs and schedule analysis.............................................................................................................3
Project schedule and total cost.....................................................................................................3
Cost benefit analysis....................................................................................................................5
Use case Diagram............................................................................................................................7
Sequence Diagram.......................................................................................................................8
Data flow diagram...........................................................................................................................9
Context Diagram..........................................................................................................................9
DFD Level 0..............................................................................................................................10
ER Diagram...................................................................................................................................11
Screen Interfaces............................................................................................................................13
Screen 1.....................................................................................................................................13
Screen 2.....................................................................................................................................14
Screen 3.....................................................................................................................................15
Gantt Chart.....................................................................................................................................16
Bibliography..................................................................................................................................17

2
SYSTEM ANALYSIS AND DESIGN
Need for the development of the system
The North Hill College is looking to develop the system for the registration of the
students. The system would be very beneficial in enrolling the students in the courses in the
college. The process would be performed with a great level of efficiency and hence, the need for
the development of an efficient system has been considered by the organization. The
requirements of the system that is to be developed has been gathered from the JAD sessions that
are conducted by me as IT manager.
Business Case
The North Hill College is looking to implement a new registration system that would be
helpful for the organization in boosting and improving their registration process. The
organization is typical educational institution that would be consisting of administrators and
registrars. A students support and service team are also present who would be able to support the
IT and academic departments of the organization.
Business Benefits of system implementation
The major benefits of the system implementation for the organization are:
 Development of new automated procedure replacing the old one.
 Reducing the hassles of registrations of a course for the students.
 Improving security constraints of the system.

3
SYSTEM ANALYSIS AND DESIGN
Project scope
The function of the system which are in scope of the project are:
 Logging into the system
 Storing the student’s information in the system
 Enrollment for a course by the students
 Students registration
 The details of the courses would be updated in the system.
Costs and schedule analysis
Project schedule and total cost
The schedule and the cost for the project has been provided below. The total cost for the
development for the system is $6,996.00.
Task Name Start Finish Resource Names Cost
Student Registration
system
Mon 10/12/09 Fri 12/18/09 $6,996.00
Project Initiation Mon 10/12/09 Fri 10/16/09 $600.00
Client Meeting Mon 10/12/09 Mon 10/12/09 Project Manager $120.00
JAD Sessions Tue 10/13/09 Wed 10/14/09 Project Manager $240.00
Project Approval Thu 10/15/09 Thu 10/15/09 Project Manager $120.00
Budget Allocation Fri 10/16/09 Fri 10/16/09 Project Manager $120.00

4
SYSTEM ANALYSIS AND DESIGN
Project Planning Mon 10/19/09 Mon 11/2/09 $2,004.00
Project Scheduling Mon 10/19/09 Mon 10/19/09 Project Manager $120.00
Software installations Thu 10/22/09 Mon 10/26/09 Software[1] $500.00
Hardware
procurement
Tue 10/27/09 Thu 10/29/09 Hardware[1] $1,000.00
system wire framing Fri 10/30/09 Mon 11/2/09
Software
Designer
$192.00
Project
Implementation
Tue 11/3/09 Thu 11/26/09 $1,656.00
Interface designing Tue 11/3/09 Tue 11/10/09
Software
Designer
$576.00
Database
Development
Wed 11/11/09 Thu 11/19/09 Database designer $560.00
Backend Integration Fri 11/20/09 Thu 11/26/09
Backend
Developer
$520.00
Project Testing Fri 11/27/09 Fri 12/11/09 $2,160.00
System testing Fri 11/27/09 Mon 11/30/09 Software Analyst $192.00
Debugging Tue 12/1/09 Thu 12/3/09 Software Analyst $288.00
System Upgrade Fri 12/4/09 Fri 12/11/09 Backend
Developer,
$1,680.00

5
SYSTEM ANALYSIS AND DESIGN
Database
designer,
Software
Designer
Project Closure Mon 12/14/09 Fri 12/18/09 $576.00
System
Documentation
Mon 12/14/09 Wed 12/16/09 Project Manager $360.00
Upload the project on
the domain
Thu 12/17/09 Thu 12/17/09
Software
Designer
$96.00
Project team sign off Fri 12/18/09 Fri 12/18/09 Project Manager $120.00
Cost benefit analysis
The cost benefit analysis for the system which is to be developed for the organization is
provided below:
Project Cost-
Benefit Analysis
Analysis Variables:
Discount Rate Used 3.00%
Annual Benefits
$
15,000.00

6
SYSTEM ANALYSIS AND DESIGN
Annual Operational
Costs
$
10,000.00
One-Time
Development Cost
$
6,996.00
Year of
Project
0 1 2 3 4 5 TOTALS
Economic Benefit $0.00
$
15,000.0
0
$
15,000.00
$
15,000.00
$
15,000.0
0
$
15,000.00
Discount Rate 1.0000 0.9709 0.9426 0.9151 0.8885 0.8626
PV of Benefits $0.00
$14,563.
11
$14,138.9
4
$13,727.1
2
$13,327.
31
$12,939.1
3
NPV of all
BENEFITS $0.00
$
14,563.1
1
$
28,702.05
$
42,429.17
$
55,756.4
8
$
68,695.61
$
68,695.61
One-Time COSTS
$
(6,996.0
0)
Recurring Costs $0.00 $ $ $ $ $

7
SYSTEM ANALYSIS AND DESIGN
(10,000.0
0)
(10,000.0
0)
(10,000.00
)
(10,000.0
0)
(10,000.00
)
Discount Rate 1.0000 0.9709 0.9426 0.9151 0.8885 0.8626
PV of Recurring
Costs $0.00
$
(9,708.74
)
$
(9,425.96
)
$
(9,151.42)
$
(8,884.87
)
$
(8,626.09)
NPV of all COSTS
$
(6,996.0
0)
$
(16,704.7
4)
$
(26,130.7
0)
$
(35,282.11
)
$
(44,166.9
8)
$
(52,793.07
)
$
(52,793.07
)
Overall NPV
$
15,902.54
Overall ROI
0.3012
Break-even
Analysis
Yearly NPV Cash
FLOW
$
(6,996.0
0)
$
4,854.37
$
4,712.98
$
4,575.71
$
4,442.44
$
4,313.04
Overall NPV Cash
FLOW
$
(6,996.0
$
(2,141.63
$
2,571.35
$
7,147.06
$
11,589.4
$
15,902.54

8
SYSTEM ANALYSIS AND DESIGN
0) ) 9
Use case Diagram
The use case diagram for the new registration process of the organization has been
described below:

9
SYSTEM ANALYSIS AND DESIGN
Sequence Diagram
The sequence diagram provided below has been used for the description of the process of
adding a course by the student. The main actors are the Student and administrator who would be
interacting with the system.
Data flow diagram
Context Diagram
The context diagram for the entire system which is developed for the North Hills College
has been provided here.

10
SYSTEM ANALYSIS AND DESIGN
DFD Level 0
The level 0 diagram has been provided below describing the students enrolment process.

11
SYSTEM ANALYSIS AND DESIGN
ER Diagram
The ER diagram for the new registration system has been provided below: