08-17-2017, 12:45 AM
THE DEVELOPMENT OF PRISON MANAGEMENT SYSTEM (PRMS)
[attachment=119]
INTRODUCTION
This chapter contains project background, problem statement, objective, scope,
project significance, expected output of the system and the conclusion of this chapter.
Project background describes briefly about the project that will be developed. The
problem statements will state the problems that encountered in the existing system or
current system. For the objective, it is about the aim for the development of the to-be
system in order to solve of the problem in the existing system while scope covers
the target users, function and the technology of the to-be system. Project significance
will describe the benefit and the important of the to-be system for the user. Meanwhile,
expected output will describe the final output of the to-be system. The conclusion
summarizes this chapter and gives an introduction of the next chapter.
Problem Statement
The following problems are identified to develop this system:
1. Limited usage of database trigger
The database triggers are not widely use in the current system. The usage of the
trigger is limited to important data, for example, trigger will be used to set a time
when DBA want to make a backup.
2. Limited usage of stored procedure
DBA has to ,open the database to run the stored procedure or function. It is hard
to do that because it wastes a lots of time.
3. Not using dynamic table structure
Usually, to create table for example, user is not required to give their own
parameter likes number of columns and have to know the syntax.
4. System administrator is not allow to give system and object privilege
Currently, system administrator cannot give a system or object privilege to other
user in the system and only DBA will do that.
Scope
The scope will explain the boundaries of this project and in order to develop a
system for users in Prisons Department Malaysia that enable them to manage the
prisoner registration and reports. Deliverables of the project will be a complete system
for users that will meet the objectives.