Prisoner Information Managment System
Prisoner Information Managment System
Prisoner Information Managment System
Declaration
We,undersigned,declere that thesis our original work, has not been presented for a
degree in
this or any other university, and all the source of martial used for the
thesis/project have been
acknowledged.
Name Id No Signature
1. Ayanaw Setegn 4647/07
---------------------------
2. Zerihun Alem 4703/07
---------------------------
3. Yemisrach Nehine 4698/07
---------------------------
4. Wubet Molla 4695/07
---------------------------
i
Web based Prisoner Information Management System
This project has been examined with our approval as the project examiner.
Examiner Name:
1. ____________________ signature______________
2. ____________________Signature______________
3. _____________________Signature_____________
ii
Web based Prisoner Information Management System
Acknowledgment
We would like to say thanks to almighty God for giving us strength to complete this
project. Then we
would like to thank our advisor Instructor Ayalneh Bitew for his constructive
opinion and willingness to
participate in each part of our project and his effective direction, assistance and
guidance for accomplish
this project. And also we wants thank Debre Markos prison administration for giving
information about
existing system in the organization.
iii
Web based Prisoner Information Management System
Abstract
This project developed web based prisoner information management system. In this
time the
overall activities of in Debre Markos prison use semi-automating way to
manipulating prisoner
information. There are repetitive and impairment activities occur in the
organization those are
difficult to integrate data from different individual prisoner records. Based on
the above problem
this project automates the existing system use well organized database.
The system enables registration, update and view of individual records of
prisoner and
visitor.
Generating reports and certificates based on the demand of the employer
Identify pre_charge.
Send request for transfer or appointment and approve request.
Assign police and lawyer
Generally this project is mainly focuses on the prisoner which is already judged by
the court, so
DMPIMS is concerns after having judged prisoner with its back ground detailed.
iv
Web based Prisoner Information Management System
Contents
List of
Table .............................................................................
................................................................... vii
List of
figures ...........................................................................
................................................................. viii
Abbreviations .....................................................................
........................................................................ ix
Chapter One:
Introduction ......................................................................
.................................................. 1
1.1.
Introduction ......................................................................
.................................................................. 1
1.2. Background of the
project ...........................................................................
....................................... 1
1.3. Statement of
Problem ...........................................................................
.............................................. 2
1.4. Overview of Proposed
system.............................................................................
............................. 3
1.5. Objective of the
Project............................................................................
.......................................... 3
1.5.1. General
objective .........................................................................
............................................... 3
1.5.2. Specific
objective .........................................................................
............................................... 3
1.6. Scope of the
project ...........................................................................
................................................ 3
1.7. Significance of
Project ...........................................................................
............................................ 4
1.8. System
requirement .......................................................................
.................................................... 5
1.8.2. Hardware
requirement........................................................................
......................................... 5
1.8.3. Programming
language ..........................................................................
..................................... 5
1.9. Methodology of the
Project............................................................................
.................................... 6
1.9. 1. Data collection
methodologies .....................................................................
.............................. 6
1.9.2. Analysis and Design
Methodology .......................................................................
...................... 6
1.9.3 .System Development
Model .............................................................................
.......................... 6
1.10. Feasibility study of the
project ...........................................................................
.............................. 7
1.10.1. Technical
Feasibility .......................................................................
.......................................... 7
1.10.2. Operational
Feasibility .......................................................................
....................................... 7
1.10.3. Economic
Feasibility........................................................................
......................................... 7
1.10.4. Legal
Feasibility........................................................................
................................................ 8
Chapter Two: System
analysis ..........................................................................
......................................... 9
2.1. Overview of existing
system ............................................................................
.................................. 9
2.2. System Requirement
Specification .....................................................................
............................. 10
2.2.1. Functional
requirement .......................................................................
...................................... 10
2.2.2. Non -functional
requirement .......................................................................
.............................. 11
2.2.3. Business
rule ..............................................................................
............................................... 12
v
Web based Prisoner Information Management System
Reference .........................................................................
.................................................................. 52
vi
Web based Prisoner Information Management System
List of Table
Table 1: use case identification
table .............................................................................
............................. 13
Table 2: Login Use case
description .......................................................................
.................................... 16
Table 3: create account use case
description .......................................................................
....................... 16
Table 4: Register prisoner use case
description .......................................................................
................... 17
Table 5: Update prisoners’ information use case
description .....................................................................
18
Table 6: Generate report use case
description .......................................................................
..................... 19
Table 7: Register Trainee use case
description .......................................................................
.................... 20
Table 8: Request transfer use case
description .......................................................................
.................... 21
Table 9: view request use case
description .......................................................................
.......................... 22
Table 10 :Prisoner class
description........................................................................
.................................... 34
Table 11: Use account class
description .......................................................................
.............................. 35
Table 12: Visitor class
description .......................................................................
....................................... 35
Table 13: Register Prisoner
table .............................................................................
................................... 36
Table 14: Register Trainee
table .............................................................................
.................................... 37
Table 15: prisoner lawyer
table..............................................................................
..................................... 38
vii
Web based Prisoner Information Management System
List of figures
Figure 1: use case
diagram ...........................................................................
................................. 15
Figure 2:Sequence diagram for login
page ..............................................................................
..... 24
Figure 3: Sequence diagram for create
account ...........................................................................
. 24
Figure 4: Sequence diagram for
registration ......................................................................
........... 25
Figure 5: Sequence diagram for send
request ...........................................................................
.... 26
Figure 6: Activity diagram for Login
page ..............................................................................
..... 27
Figure 7: Activity diagram for
registration ......................................................................
............. 28
Figure 8: Activity diagram for
updating ..........................................................................
............. 29
Figure 9: Analysis class
diagram ...........................................................................
....................... 31
Figure 10: Design class
diagram ...........................................................................
........................ 33
Figure 11: User interface for login
page ..............................................................................
......... 39
Figure 12: User interface for create
account ...........................................................................
...... 40
Figure 13: User interface for prisoner
registration ......................................................................
. 41
Figure 14: Deployment
Diagram ...........................................................................
....................... 42
Figure 15: System testing for identify
pre_charge .......................................................................
50
viii
Web based Prisoner Information Management System
Abbreviations
DMPIMS:-Debre Markos Prisoner Information Management System
ix
Web based Prisoner Information Management System
Vision
The main vision of Debre Markos prison is to be the popular one in emendation and
training
place in 2015 E.C throughout the region.
Mission
The mission of Debre Markos prison office is to enable prisoners’ to be productive
and peaceful
citizen who have been sent by court order by giving security, food and educational
training.
2
Web based Prisoner Information Management System
3
Web based Prisoner Information Management System
4
Web based Prisoner Information Management System
The details information of the prisoner stored in the database without any
error and
redundancy.
Avoid document missing from natural disaster.
Visio 2007: - This software is used for drawing the different diagrams we are going
to
develop our proposed system.
The project team chooses PHP as server side scripting language because PHP is:-
5
Web based Prisoner Information Management System
Open source.
6
Web based Prisoner Information Management System
subsequent release of the module adds function to the previous release. The process
continues till
the complete system is achieved.
7
Web based Prisoner Information Management System
8
Web based Prisoner Information Management System
Visitor, trainee, and generate report is done manually. This in turn will
result in poor
techniques handling the data.
Information Problem
Data are not easily accessible due to its integration which is placed in
different location.
Loss of data may occur.
Efficiency Problem
The efficiency of the existing system is not optimal, because Storing,
locating of data of
prisoners’ takes much more time.
9
Web based Prisoner Information Management System
Inspector
Office guard
Police Department/officer
Parole committee
Remission Manager
Training department
Prisoner release officer
Prisoners’
Visitors’
polices
10
Web based Prisoner Information Management System
Technical requirement
Security:-The system only permits authorized user to enter the system. Authorized
users are who
have username and passwords.
Usability: The system has an interactive and attractive GUI which eases users’
usage problem. It
needs simple training, because it is easy to use and adapt.
User Interface: The interface will be user friendly and can properly guide the user
how to use
the system and perform operations easily since every link name in the system
similar to the task
performed.
Performance: The system performs its task efficiently and effectively because the
team project
will uses advanced programming language, less number of iterations for a given task
and
optimized query to develop the system
11
Web based Prisoner Information Management System
BR1. All users who want to get the service from the system must be valid user
name and
password.
BR2. Age of prisoner to register must be greater than 18.
BR3. To get parole Prisoner fulfill conditional evaluation points must be greater
than or
equal to 75%.
BR4. Visitors whose age less than 9 are not registered in the system.
BR5. Should be allocating room for male and female separately.
Inspector
System administrator
Discipline officer
Registrar officer
Security manager.
Police
Training officer.
12
Web based Prisoner Information Management System
Prisoner lawyer
Use case identification
Use cases: is a symbol that describes a sequence of actions that provide
something of
measurable value to an actor and is drawn as a horizontal ellipse.
13
Web based Prisoner Information Management System
The boundary, which defines the system of interest in relation to the world
around it.
The actors, usually individuals involved with the system defined according
to their roles.
The use cases, which the specific roles are played by the actors within and
around the
system.
The relationships between and among the actors and the use cases.
14
Web based Prisoner Information Management System
Assign police
System admin
Register prisoner
Evaluate parol
information
point
<<Include>>
include
<<Include>>
<<Include>>
update user <<Include>>
information <<Include>>
<<Include>>
<<Include>><<Include>>
<<Include>>
<<Include>>
Room allocation
view appiontement
<<Include>>
<<include>>
Registrar officer
Security manager
<<Include>> infromation
information
<<include>>
include
<<Exclude>>
assign lawyer
Send request
<<Include>>
<<include>>
<<Include>> prisoner laywer
Generate Report
<<Include>>
<<Include>>
view response
Logout
veiw applicant
Training officer
Notify
Register trainee
Give certificate
Police
view notification
15
Web based Prisoner Information Management System
Post condition The user is authenticated and taken to his/her own user
interface.
16
Web based Prisoner Information Management System
Pre- conditions The system is in the create account state and has the
create account
screen displayed.
Alternative course of A1. If user misses the required field or entered wrong data,
the system
action notifies “the missed field or wrong data” and the process
continue
from step 3.
17
Web based Prisoner Information Management System
18
Web based Prisoner Information Management System
information.
7. The
system will
display
successfully
updated
message.
11. End
use case.
Alternative course of A1. If user misses the required field or entered wrong data,
the system
action notifies “the missed field or wrong data” and the process
continue
from step 3.
19
Web based Prisoner Information Management System
response
20
Web based Prisoner Information Management System
Alternative course of A1. If user not accept applicant click on reject button and
the system
action automatically send message for prisoner lawyer page.
Description: Prisoner Lawyer can send any request about prisoner based on
different
reason like for transfer one prison into another prison or
for appointment.
21
Web based Prisoner Information Management System
Alternative course A1.If the form is not filled with correct data’s the system will
loopback to
of action step 5 and messaged the prisoner what type of error has been
occurred.
Description: View any request that comes from prisoner lawyer page
22
Web based Prisoner Information Management System
o Approve
request
o Reject
request
8. The system
will send the
response.
9. The system
will display
successful
message.
System Login
User page
Controller
All users Home page interface
1.Open()
Actor
2.Click login link
3.Display()
6.Invalid
7.Display error
message
8.Valid
System
admin 1.Open()
8.Valid
9.Click creat account button
10.Check( )
24
Web based Prisoner Information Management System
Registrar
officer 1.Open()
8.Valid
9.Click register button
10.Check( )
14.Successfully registred
25
Web based Prisoner Information Management System
Prisoner
1.open()
6.Invalid
7.Display error message
8.Valid
9.Click send request button
26
Web based Prisoner Information Management System
No
If un and pw is
Correct?
Yes
Successfully login
27
Web based Prisoner Information Management System
Re-enter
No If the filled
form
is correct?
Yes
Successfully registerd
28
Web based Prisoner Information Management System
View
Re-enter
No If edit
The form
Is correct?
Yes
Updated successfully
29
Web based Prisoner Information Management System
30
Web based Prisoner Information Management System
Police
user
* send
+Notify()
systemadmin -uid
+view notifcation()
-Ufname
Notify
+Manage Account()
-Ulname
-polID
1
1 *
-edul_evel
-fname
-lname
registerar officer -phone_no
-sex
-message
-sex
-for
+Register()
+generate report() -role
Displine officer
+assign() -user_photo
+evaluate()
+view()
Evaluation point *
+login()
+view()
-Prisoner ID
Traning officer
-Goodbehivor:
1
use
view -Workaholice: 1
+approve() send
eval_point
1 +view()
+send request()
+post notice() 1 view
has 1 1 1
+view response()
+assign()
use
1 use
use *
Account Class
1use 1 1
1
-UId
send 1 -usename
Security Manager
use
1 1
-password
use assign
register -Role
1
+register vistore()
1
assign +generate report()
1
use
+assign() 1
1
1
* * +view()
prisoner
Request
view assign police
-PId -Pid
1
-policeId
-Pfname -request type
* *
-PID
-Pmname -To
-appontiment date register
*
-Plname -request date
-return date
Trainee
-natinality -request case
-region -traning type
Vistore
-zone -request date
-Vid
-woreda
-Pid
-kebele *
-fname
-entry date
-mname
-exit date
-lname
-appdate
-sex
-court name
-region
-crime type visit
-woreda
-photo
-kebele
*
* -date
31
Web based Prisoner Information Management System
32
Web based Prisoner Information Management System
Police
user
send
+Notify()
systemadmin -uid varchare(30)
+view notifcation()
-Ufname varechare(30)
Notify
+Manage Account()
-Ulname varchare(30)
1 -polID varechare(20)
1 -edul_evel varchare(30)
-fname varchare(20) *
-lname varchare(20)
registerar officer -phone_no varchare(20)
-sex vatchare(6)
-message varchare(200)
-sex varchare(20)
-for varchare(20)
+Register()
+generate report() -role varchare(20)
Displine officer
+approve() -Totale:int
*
1 +view()
1 +send request()
+post notice() 1 view
use has 1 1
+view response()
+assign()
1 use
use use
1
Account Class
1 1
1
-UId varchare(20)
register send -usename varchare(20)
Security Manager
1 1
use 1
use -password varchare(20)
assign
-Role varchare(20) 1
+register vistore()
1
assign +generate report()
use
+assign() 1
1
1
* * +view()
1 *
Request
view assign police
-Pid varchare(20)
-policeId varchare(20) 1
prisoner
-request type varchare(20)
-PID varchare(20)
-PId varchare(20) * -To varchare(20)
-appontiment date date
-Pfname varchare(20)
-return date date register
-request date varchare(20)
*
-Pmname varchare(20)
-request case varchare(20)
-Plname varchare(20)
-natinality varchare(20)
-region varchare(20)
Vistore
-zone varchare(20)
-Vid varchare(20)
-woreda varchare(20) *
-Pid varchare(20)
-kebele varchare(20) Trainee
-fname varchare(20)
-entry date date -traning type varchare(20)
-mname varchare(20)
-exit date date -request date date
-lname varchare(20)
-appdate date
-sex varchare(6)
-court name varchare(20)
-region varchare(20)
-crime type varchare(20) visit
-woreda varchare(20)
-photo longtext
-kebele varchare(20)
* -date date
*
33
Web based Prisoner Information Management System
Attribute Description
Data Type
PID To represent identification number for the Varchar
prisoner.
Fname To represent first name of the prisoners.
Varchar
Mname To represent middle name of the prisoners.
Varchar
Lname To represent last name of the prisoners.
Varchar
Sex To represent gender type of prisoners.
Varchar
Age To represent age of prisoners
Int
Nationality To represent nation of the prisoner.
Varchar
34
Web based Prisoner Information Management System
Attribute Description
Data Type
User ID To represent identification of user.
Varchar
Username To represent user name for user.
Varchar
Password To represent password for user.
Varchar
Role To represent select role for user.
Varchar
Status To represent active/inactive for user. int(1)
Attribute Description
Data Type
VID To represent identification of visitor.
Varchar
PID To represent identification for Varchar
prisoner.
Fname To represent first name for visitor. Varchar
Mname To represent middle name for visitor.
Varchar
Lname To represent last name for visitor.
Varchar
Sex To represent gender for visitor.
Varchar
Region To represent region for visitor.
Varchar
Zone To represent zone for visitor.
Varchar
Woreda To represent woreda for visitor.
Varchar
Kebele To represent kebele for visitor.
Varchar
Relation To represent relative for visitor.
Varchar
35
Web based Prisoner Information Management System
36
Web based Prisoner Information Management System
37
Web based Prisoner Information Management System
38
Web based Prisoner Information Management System
39
Web based Prisoner Information Management System
40
Web based Prisoner Information Management System
For this project the project team developed the following deployment diagrams:-
41
Web based Prisoner Information Management System
System admin
Register user information
Identify pre-charge
Registrar officer
Security
Give clerance
Release manager
Register Traniner
Give certificate
Traning officer
Register vistore
View report
Inspector
42
Web based Prisoner Information Management System
43
Web based Prisoner Information Management System
44
Web based Prisoner Information Management System
padding:48px;
height:160px;
margin-bottom:5px;
margin-left:180px;
margin-right:10px;
margin-top:-230px;
}
</style>
</head>
<body>
<div id="header">
<?php
include("header.php");
?>
</div>
<div id='cssmenu'>
<?php include("inc\hearderlogout.php"); ?>
</div>
<?php
include("security.php")
?>
<div class="date">
<div class="date">
<?php
require("inc/profile_date.php");
?>
</div>
<?php
if(isset($_SESSION['Username'])&& isset($_SESSION['Password']))
{
$police=$_SESSION['$police'];
//echo $police;
?>
<div id="section">
<fieldset style="height:230px; width:500px;
border:1px
solid #336699;
border-radius:20px; margin-top:-115px;
margin-left: 29px;" >
<br>
<form enctype="multipart/form-data" action="" method="POST">
PoliceID:
<select name="poid" style=" width: 60%; height:9%; border-radius:4px;font-
size:15px;box-sizing: border-box; border: 1px solid #060907; box-sizing: border-
box;
padding: 0px;">
45
Web based Prisoner Information Management System
<?php
$sql1="select * from usertable where role='police' and status='Active'and
policestatus='free'";
$sql1=mysqli_query($con,$sql1);
if($sql1)
{?>
{?>
{?>
<option value="">Select prisoner ID from requesttable</option>
<?php
while($row=mysqli_fetch_array($sql1))
{
?>
46
Web based Prisoner Information Management System
while($row1=mysqli_fetch_array($sql))
{
$pid=$row1['pid'];
?>
}
<option value="<?php echo $pid;?>">
<?php echo $pid;?>
</option>
<?php
}}?>
</select>
<br><br>
<input type="submit" value="Assgin" name="assgin"
style="width:72px;">
<input type="reset" value="Reset" style="width:72px; margin-left:-10px;"/>
</form>
<?php
if(isset($_POST["assgin"]))
{
$poid=$_POST["poid"];
$pid=$_POST["pid"];
//$Requesttype=$_POST["Requesttype"];
if($con)
{
$sql1="select * from prisoner where pid='$pid'
and
app='Court'";
$result=mysqli_query($con,$sql1) ;
if($result)
{
while($row1=mysqli_fetch_array($result))
{
$fnc=$row1['firstname'];
$lnc=$row1['middlename'];
$sexc=$row1['sex'];
$pcrimetypec=$row1['crimetype'];
$appc=$row1['app'];
$photoc=$row1['Photo'];
47
Web based Prisoner Information Management System
$result1=mysqli_query($con,$sql) ;
while($row=mysqli_fetch_array($result1))
{
$fn=$row['Pfname'];
$ln=$row['plname'];
$sex=$row['sex'];
$pcrimetype=$row['pcrimetype'];
$trasfer=$row['Requesttype'];
$photo=$row['photo'];
$sql3="insert into assign
police
values('$poid','$pid','$fn','$ln','$sex','$pcrimetype','$photo','','$trasfer','yes'
,'identity(1,1)')
";
$inserted=mysqli_query($con,$sql3);
if($inserted)
{
$sql="update usertable set policestatus='no free' where UserID='$poid'and
role='police'";
$update=mysqli_query($con,$sql);
if($update)
echo
"<div class='success'><img src='image/success.jpg'
style='height:19px;'/>
This police is assigned
successfully...</div>".mysqli_error($con);
else
echo "<div class='error'><img src='image/delete.jpg'
style='height:19px;'/>
48
Web based Prisoner Information Management System
not assigned</div>".mysqli_error($con);
}
}
}
else
echo "Connection Failed";
}
?>
</fieldset>
</div>
<?php
}
else
{
header("location:login.php");
}
?>
<div id="footer">
<?php
include("inc/foot.php");
?>
</div>
</div>
</div>
</body>
</div>
</html>
49
Web based Prisoner Information Management System
Chapter 5: Testing
Testing is the final phase of implementation. Testing is a process to show the
correctness of the
program. Testing is checking of the system workability in an attempt to discover
errors and
avoiding such errors from the system. In this the team members tested the entire
system as a
whole with all forms, code, modules.
3. Security testing: Security testing was done by trying to access the system that
is not
authorized. For example without the valid user name and password tester will try to
access the
system
50
Web based Prisoner Information Management System
6.2 Recommendations
Nowadays, the world is highly becoming a competitive world in technology. So,
Organizations
should have to divert their attention on using the recent technology to facilitate
their work
properly. This can be real if they are able to use recent information technology
(IT) to
successfully achieve their objective.
We are recommended Debre Markos prison to use the developed system in order to
facilitate the
work process and to reduce wastage time to manage all prisoner information in the
organization.
Finally, we would like to recommend some points on the usage and accessibility of
this system.
The organization should have adequate computer facilities for the
introduction of the new
system.
These systems need an educated person so every user’s should know about
how
computer works and take basic computer training skills.
51
Web based Prisoner Information Management System
Reference
1) https://chilot.files.wordpress.com/2011/01/reg-no-138-treatment-of-federal-
prisoners.pdf
2) https://www.ibm.com/support/knowledgecenter/...9.../cclassd.html
3) System analysis and design 5th edition.
4) https://www.smartdraw.com/use-case-diagram/
5) https://www.inflectra.com/ideas/topic/requirements-definition.aspx
6) https://www.w3schools.com/
52