CIS5200: System Analysis and Recommendations for AECC Consultants

This report presents a system analysis of Australian Education and Career Consultants (AECC), a consultancy firm with admission, VISA, and employment departments. It includes a To-Be diagram illustrating proposed improvements, a comparison between the As-Is and To-Be states, and an entity-relationship (ER) diagram. Data normalization is performed to enhance database efficiency. The report covers structural and behavioral testing methodologies, outlines a training plan for staff, and suggests a system changeover strategy. Key recommendations for management focus on database improvements, website enhancements, and increased reliance on technology. The goal is to optimize AECC's processes and services.

CIS5200
PROFESSIONAL SKILLS FOR SYSTEMS
ANALYSIS ASSIGNMENT 2
Semester- 2018
Student name- Lakshmi Harika Pakanati
Student ID -u1106177

Abstract
Day-By-Day the information technology is improving which ultimately benefit the organization all over
the world. The system analysis plays a major role in information technology sector. A report will be
designed which will contain information about system analysis of organization Australian Education and
career Consultants (AECC). The organization Australian Education and career Consultants (AECC) is a
consultancy firm which has three departments i.e. admission department, VISA department and
employment department. The system analysis will be carried to check the feasibility of the system.
1

Table of Contents
Abstract......................................................................................................................................................1
List of Figures............................................................................................................................................3
Introduction...............................................................................................................................................4
Time management plan.............................................................................................................................5
To-Be Diagram..........................................................................................................................................6
Comparison between To Be and As Is.....................................................................................................8
A brief note on impact on organization................................................................................................9
Recommendations of management.......................................................................................................9
ER diagram..............................................................................................................................................10
Data normalization..................................................................................................................................10
1NF Relation........................................................................................................................................10
2NF Relation........................................................................................................................................11
3NF Relations.......................................................................................................................................12
Testing......................................................................................................................................................15
Structural testing.................................................................................................................................15
Behavioral testing................................................................................................................................15
Training....................................................................................................................................................17
System changeover..................................................................................................................................19
Report to Top Management....................................................................................................................20
Conclusion................................................................................................................................................21
References................................................................................................................................................22
2

List of Figures
Figure 1To-Be process diagram...................................................................................................................6
Figure 2 ER diagram...................................................................................................................................9
3

Introduction
This assignment is based on system analysis of organization Australian Education and career Consultants
(AECC). This report will discuss organization requirements and improvements in organization. A To-Be
diagram will be made for the organization which will be used to define the improvements require for the
organization. The entity relationship diagram will also be made for the organization. The modeling will
be used for describing better workflow of the system. A database will also be created and data
normalization will also be performed for the database. The report will briefly discuss testing and training
methods for the organization Australian Education and career Consultants (AECC). And in last section, a
report to management will be attached.
4

Time management plan
A proper time management plan is highlighted in below section.
5

6

To-Be Diagram
The To-Be model is used to show the business system of Australian Education and career Consultants
(AECC) organization. The To-Be model is designed so that organization can improve the services and
can upgrade the process and services provided to its clients.
The To-be diagram is designed to depict the further improvements in the organization. The To-Be
diagram shows the organizational structure and organization requirements. The diagram is beneficial for
the organization and it ensures that it will be helpful for the organization Australian Education and career
Consultants (AECC).
7

Figure 1To-Be process diagram
8

Comparison between To Be and As Is
In this section, a comparison between To-Be diagram and As-Is diagram is done. The comparison is done
on the basis of diagram for organization Australian Education and career Consultants (AECC) ( How to
Develop As-Is and To-Be Business Process? 2016).
Table 1 Comparison of As-Is and To-Be diagram
AS-IS DIAGRAM TO- BE DIAGRAM
As-Is diagram only discussed the departments
Australian Education and career Consultants
(AECC) focuses on.
The To-Be diagram discusses other parts of the
system, both internal part and external part.
The As-Is diagram did not discuss student sign
up on Australian Education and career
Consultants (AECC).
From To-Be diagram it can be concluded that
student needs to first sign-up for using the
services.
The As-Is diagram did not discuss student sign in
for booking appointment.
From To-Be diagram it can be concluded that
student needs to first sign-in for using the
services.
From As-Is diagram it cannot be concluded that
how to book an appointment.
From To-Be diagram it can be concluded that
students have to book an appointment.
The As-Is diagram did not discuss online
payment.
The To-Be diagram shows that students need to
do online payment before getting consultancy
service.
The As-Is diagram shows that students need to
visit organization for using services.
The To-be diagram shows that the student did not
visit organization physically, they can opt for
online services.
The As-Is diagram gives information of three
departments, i.e., Employment, VISA, and
admissions.
The To-Be diagram also gives information of
three departments, i.e., Employment, VISA, and
admissions.
The As-Is diagram did not explain manager role. After receiving consultancy feedback, the To-Be
diagram explains manager role.
From As-Is diagram it can conclude that in
admission department, the student can alter
course or can change university or college.
Australian Education and career Consultants
(AECC) provides the facility of scholarship
and provide educational guidance.
From To-Be diagram it can conclude that in
admission department, the student can alter course
or can change university or college. Australian
Education and career Consultants (AECC)
provides the facility of scholarship and provide
educational guidance (A diagram is not a model:
The huge difference between them 2014).
9

A brief note on the impact on the organization
A proper system analysis is performed for the organization Australian Education and career Consultants
(AECC). The To-Be diagram is created to improve the system. The impacts on the organization after
implementation of To-Be model are described below:
a. A login and signup portal is implemented to track the users of the services provided by
organization Australian Education and career Consultants (AECC).
b. The student doesn’t need to visit the consultancy they can book an appointment online. It helps
the student to properly utilize time and doesn’t waste time by standing in a queue and waiting for
their turn. They can book their appointment in advance.
c. The option of online payment is also there which benefit the students and organization as well.
d. Now the system has a manager to manage the system of organization Australian Education and
career Consultants (AECC). The manager helps to organize the staff as well as management of all
the internal process of organization.
e. The manager also helps to focus on admission and VISA departments.
f. The economy of organization can be improved.
Recommendations for management
The recommendations always help to improve the system. The recommendations need to be implemented
for better functioning of the system.
1. The database of the organization needs to improve and some extra advanced features should add
to the database.
2. The website of organization Australian Education and career Consultants (AECC) need to
improved and make more user-interactive.
3. The organization should be more reliable on technology rather than pen paper system.
10

ER diagram
The ER diagram for organization AECC is shown below (Brandenburg 2016):
Figure 2 ER diagram
Data normalization
The data normalization is performed to remove the redundancy and inconsistency from the database.
1NF Relation
Student (Name_Student, Contact_Student, Address_Student, Qualification_Student, Email_Student,
Institution, VISA, Booking)
Attributes Type
Name_Student varchar
Contact_Student int
Address_Student varchar
Qualification_Student varchar
Email_Student varchar
Institution varchar
VISA int
Booking varchar
Employee (Employee_Name, Designation, Department)
Attribute Type
Employee_Name varchar
11