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


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


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


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.


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.


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.


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


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


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


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


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


10.0 E-R Diagram 35

11.0 Workflow Diagram 37

12.0 Context Diagram 55

13.0 Top Level DFD 56


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


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




27.0 Adding, Viewing and Editing Form 71

28.0 Report on PNP Personal Data Sheet 72




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


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

first page softeng

Documents