Download - First Page Softeng
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyi
MANDALUYONG POLICE PERSONNEL INFORMATIONMANAGEMENT SYSTEM
A Student-Faculty Collaborative System Development Study Presented to the Faculty of Computer EngineeringCollege of Engineering and Industrial Technology
Rizal Technological UniversityMandaluyong City
In Partial Fulfillment of the Requirements for theDegree of Bachelor of Science in Computer Engineering
by:
John Barkham C. NeyalaMark Joseph G. Corton
Shemuel D. BedañaRuasunfi S. Valerio
Faculty Collaborator
Engr. Emelita C. Presbitero
March 2010
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyii
APPROVAL SHEET
This Student-Faculty Collaborative System Development Study entitled “MANDALUYONG POLICE PERSONNEL MANAGEMENT INFORMATION SYSTEM”, prepared and presented by John Barkham C. Neyala, Shemuel D. Bedaña, Mark Joseph G. Corton, Ruasunfi S. Valerio and in collaboration with Engr. Emelita Presbitero; in partial fulfillment to the requirements of the Degree of Bachelor of Science in Computer Engineering, has been examined and recommended for the acceptance and approval to Oral Examination.
___________________________ _____________________________ Engr. Julius U. Cabauatan Engr. Christopher L. Zaplan Instructor, CPE58L Adviser
____________________________Engr. Ronald N. Licsi
Head, Computer Department
Approved in partial fulfillment of the requirements for the Degree of Bachelor of Science in Computer Engineering by the Oral Examination Committee.
Panel of Examiners:
__________________________Engr. Edwin G. Purisima
Chairman
__________________________ __________________________ Engr. Liberty P. Lagrosa Prof. Aphril A. Alcalde
Member Member__________________________
NUP Jesus V. CardovillaClient
Accepted as partial fulfillment of the requirements in the subject Software Engineering with the grade of ________.
________________________________________Engr. Oscar C. Garrovillas
DEAN, College of Engineering and Industrial Technology
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyiii
DEDICATION
To Almighty God
To the dearly loved parents
To all the friends and acquaintances
To all the people who took part in the completion of this design project
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyiv
ACKNOWLEDGEMENT
This project study is not possible without the help of all the people
who contributed their support to the researchers. They would like to extend
their deepest appreciation to the following people:
To Engr. Julius U. Cabauatan, for his practical guidance and shared of
knowledge in documentary of this project study.
To Engr. Christopher L. Zaplan, for encouraging the researchers build
and finish the entire project. For his advice in strengthening the confidence
of the researchers.
And the Beloved Parents, for their financial support, love,
understanding, guidance on the right perception and values to the
researchers.
Above all, the Almighty God for the blessings and guidance for making
this project study successful.
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyv
THESIS ABSTRACT
TITLE: Mandaluyong Police Personnel
Management Information System
PROPONENTS
: Bedańa, Shemuel D.
Corton, Mark Joseph G.
Neyala, John Barkham C.
Valerio, Ruasunfi S.
SCHOOL Rizal Technological Universtiy
FACULTY COLLABORATOR : Engr. Emelita C. Presbitero
ADVISER : Engr. Christopher L. Zaplan
DATE : March 2010
The purpose of this project is to develop the old system used in
managing personnel records at Mandaluyong Police Station. Specifically, it
sought to answer the following problems: (1) How long does it take to record
the policemen’s profile in the current system? (2) How accurate is the
process in producing the personal data sheets and the profile records sorted
by gender, religion, blood type and status of appointment. (1) The main
objective of the study is to come up with a system that will manage
personnel information at the station with the following specified objectives;
To shortened the process in recording the policemen profiles. (2) To have a
fast and accurate output of the Personal Data Sheets and the profile records
sorted by gender, religion, blood type and status of appointment.
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyvi
The proponents make use of different instruments like interview and
documentary analysis and the spiral method of software development was
adapted in the course of the study.
The proponents establish two alternative solutions for the proposed
system’s (1) implementation in a stand-alone setting and (2) implementation
in a networked environment using client-server setting.
The two alternatives were subjected to different feasibility studies
namely; organization resource, technical, schedule and economic. For the
technical feasibility, alternative 1 is better than alternative 2, because of its
flexibility, for the economic feasibility; Organizational & Cultural feasibility
and recourses feasibility, Alternative 1 is more usable and reliable; it’s a tie
for Schedule feasibility. Based on the analysis from such studies made, the
potential benefits to the development of Administration office of
Mandaluyong police station, the proponents strongly recommends the
implementation of alternative 1 or the stand-alone setting for the procedures
inside the library.
The final output of this study is Mandaluyong Police Personnel
Information Management System which will be a better alternative to the
existing system, this will improve the transactions in the administration
office. The system was done using Visual Basic 6.0 language as front end
with Microsoft Access as back-end.
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyvii
TABLE OF CONTENTS
Cover Page i
Approval Sheet ii
Dedication iii
Acknowledgement iv
Thesis Abstract v
Table of Contents vi
List of Figures xi
List of Tables
Bibliography
xiii
iv
I. THE PROBLEM AND ITS BACKGROUND
Introduction 1
Statement of the Problem 1
System Design Paradigm 3
Objectives of the Study 4
Scope and Delimitation of the Study 4
Assumption 5
Design Methodology 6
Software Development 7
Definition of Terms 9
II. REVIEW OF RELATED LITERATURE AND STUDIES
Local Literature and Studies 10
Foreign Literature and Studies 14
Synthesis 23
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyviii
III. SYSTEM ANALYSIS
Business Analysis 24
Business Rules 25
Concept of Operation 27
Events Table 28
Dataflow Diagram 29
Process Description 32
ER Diagram 35
Workflow Diagram 37
Overall Analysis of the Present System 38
Conclusion Regarding The Existing System 39
Recommendation 39
IV. FEASIBILITY STUDIES
Alternative Courses of Action 40
Technical Feasibility 41
Economic Feasibility 42
Operational and Cultural Feasibility 47
Resource Feasibility 47
Schedule Feasibility 48
Conclusion and Recommendation 49
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyix
V. NEW SYSTEM
Concept of Operation 50
General Requirements 51
Events Table (New System) 53
Data Flow Diagram 55
Use Case Diagram 58
Use Case Description 59
Activity Diagram 60
System Sequence Diagram 62
User Interface 64
APPENDICES
APPENDIX A: APPROVED PROJECT PROPOSAL
APPENDIX B: ORGANIZATIONAL CHART
APPENDIX C: PERMIT TO CONDUCT STUDY
APPENDIX D: FUNCTIONAL DESCRIPTION
APPENDIX E: PROJECT PLAN
RESOURCE ALLOCATION PLAN
QUALITY ASSURANCE PLAN
COMMUNICATION PLAN
VALIDATION AND EVALUATION PLAN
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyx
RISK MANAGEMENT PLAN
MONITORING AND REPORTING PLAN
MAINTENANCE PLAN
WORK BREAKDOWN STRUCTURE
GANTT CHART
APPENDIX F: RESEARCH-MADE QUESTIONAIRE
APPENDIX G: INTERVIEW OUTLINE
APPENDIX H: INTERVIEW REPORT
APPENDIX I: EXISTING INPUT/OUTPUT
APPENDIX J: NEW SYSTEM INPUT/OUTPUT FORM
APPENDIX K: SYSTEM AND PROGRAM FLOWCHART
APPENDIX L: FILE AND DATABASE STRUCTURE
APPENDIX M: USER’S MANUAL
APPENDIX N: STRUCTURED WALKTHROUGH
APPENDIX O: PROGRAM LISTING
APPENDIX P: LETTER OF ACCEPTANCE
CURRICULUM VITAE
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyxi
LIST OF FIGURES
Figures Descriptions Page
1.0 System Paradigm 3
2.0 Spiral Methodology 7
3.0 Call Monitoring System 15
4.0 Call Recording Information 18
5.0 NetVizor Employee Network Monitoring Software 18
6.0 Ascendant NFM Network File Monitoring 21
7.0 Context Diagram 29
8.0 Top Level DFD 30
9.1 DFD Fragments 31
9.2 DFD Fragments 32
10.0 E-R Diagram 35
11.0 Workflow Diagram 37
12.0 Context Diagram 55
13.0 Top Level DFD 56
14.0 DFD Fragments 57
15.0 Use Case Diagram 60
16.0 Activity Diagram: Encoding of Personal Data 60
17.0 Activity Diagram: Update of Records 61
18.0 System Sequence Diagram 62
19.0 System Sequence Diagram 63
20.0 Log-in Screen 64
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyxii
21.0 Main Form 65
22.0 Adding, Viewing and Editing Form 66
23.0 Report on Personal Data Sheet 67
24.0 Report on Personal Data Sheet 68
25.0 Report on Personal Data Sheet 69
26.0 Report on Personal Data Sheet 70
27.0 Adding, Viewing and Editing Form 71
28.0 Report on PNP Personal Data Sheet 72
29.0 Report on PNP Personal Data Sheet 73
30.0 Report on PNP Personal Data Sheet 74
31.0 Report on PNP Personal Data Sheet 75
32.0 Form for Sorted Profiles 76
33.0 Sorted by Status Report 77
34.0 Sorted by Gender Report 78
35.0 Sorted by Blood Type Report 79
36.0 Sorted by Religion Report 80
37.0 Form for Changing Account Information 81
RIZAL TECHNOLOGICAL UNIVERSITY
College of Engineering and Industrial Technologyxiii
LIST OF TABLES
Table Description Page
1. Synthesis 23
2. Events Table 28
3. Development Cost of Alternative 1 44
4. Cost of Operation of Alternative Solutions (1year) 45
5. Alternative Solution 1 46
6. Events Table: New System 53