DESIGN AND IMPLEMENTATION OF A COMPUTERIZED LOCAL GOVERNMENT ADMINISTRATION SYSTEM

0
551

ABSTRACT

The work presents a design of a Local Government Administration System.  A Local Government Administration System is concerned with the computerization of personnel records appraisal of personnel on order to achieve the aims and objectives of the organization local government.  With the local government administration system aid to create and maintain efficient records.  This will also help to fish out “ghost workers”

The design was implemented to facilitate the personnel auditing system for a local government administration.  It will be less time wasting and cheap to run.

ORGANIZATION OF WORK

This project work is primarily designed to give an insight to Local Government Administration system.

Chapter one talks about introduction to computerized Local Government Administration system, study of problem and objectives as well as definition of the scope.

Chapter two comprises the literature review. Chapter three gives the detailed information about the existing (old) system, while chapter four and five deals with the design and implantation of new system.

Chapter six document the project work, while chapter seven summaries,  conclusion and suggestions were made.

TABLE OF CONTENT

Title page                                                                                                       i          

Certification                                                                                                  ii

Approval                                                                                                       iii

Dedication                                                                                                     iv

Acknowledgement                                                                                       v

Abstract                                                                                                         vi

Organization of work                                                                                  vii

Table of content                                                                                           viii

CHAPTER ONE

1.0       Introduction                                                                                                  1

1.1       Statement of problem                                                                                  2

1.2       Aims and objectives                                                                                    2

1.3       Purpose of study                                                                                          3

1.4       Significant of study                                                                                     3

1.5       Scope/Delimitations                                                                            4

1.6       Limitations/Constraints                                                                              4

1.7       Assumption of study                                                                                   5

1.8       Definition of terms                                                                   5                     

CHAPTER TWO

2.0       Literature review                                                                                          6

CHAPTER THREE

3.0       Description and analysis of the existing system                                     9

3.1       Fact-finding method/ methodology                                                           9

3.2       Organisational Structure/Organogram                                                      10

3.3       Objectives of the existing system                                                             10

3.4       Input, Process, and Output Analysis                                                         11

            3.4.1   Input Analysis                                                                                  11

            3.4.2   Process Analysis                                                                              11

            3,4.3   Output Analysis                                                                               11

3.5       Information Flow diagram                                                                          12

3.6       Problems of the existing system                                                                12

3.7       Justification of the new system                                                                 13

CHAPTER FOUR

4.0       Design of the new system                                                                           14

4.1       Design Standard                                                                                           14

4.2       Output specification and design                                                                14

4.3       Input specification and design                                                                   14

4.3.1   File design                                                                                         15

4.4       Procedure chart                                                                                            16

4.5       Systems flowchart                                                                                        17

4.6       System requirements                                                                                   18

            4.6.1   Hardware Requirements                                                                 18

            4.6.2   Software Requirements                                                                   18

            4.6.3   Operational Requirements                                                              18

            4.6.4   Personnel Requirements                                                                 18

CHAPTER FIVE

5.0       Implementation                                                                                            19

5.1       Design Standard                                                                                           19

5.2       Program design                                                                                             20

5.2.1   Program Flowchart                                                                           20

5.2.2   Pseudo code                                                                                      24

5.3       Coding                                                                                                           25

5.4       Test Data/Test Run                                                                                      31

5.5       User Training – An overview                                                                     31

5.6       Cutover Process                                                                                           31

CHAPTER SIX

6.0       Documentation                                                                                             32

6.1       The user documentation                                                                             32

6.2       The programmer documentation                                                               32

CHAPTER SEVEN

7.0       Recommendations, Summary and Conclusion                                        33

7.1       Recommendation                                                                                         33

7.2       Summary                                                                                                       34

7.3       Conclusion                                                                                                    34

REFERENCES                                                                                                          35

BIBLIOGRAPHY

APPENDIX                                                                                                                36

SOURCE LISTING                                                                                                   36

LIST OF FIGURES                                                                                                   40

CHAPTER ONE

1.0              INTRODUCTION

Computerized local government council involves the use of computers to carry out the functions of local government. Every activities of local government are documented with help of computer system. Computerized local government council required people with computer knowledge.

 Local government is a collection of public bodies with authority over a subdivision of a significant area of a country’s territory. It is either the third tier in federal countries or the second and third tiers in unitary countries (regions, counties, municipalities, etc. The lowest tier of government in each state. Local authorities are usually elected. There may be more than one tier of local government in each country. Local governments are administrative offices that are smaller than a state. The term is used to contrast with offices at nation-state level, which are referred to as the central government, national government, or (where appropriate) federal government.

The location of homes, industrial plants, stores, schools, churches and others is of vital importance to a local community because it affects the quality and convenience of living and the costs of private and public services. Three patterns are interwoven in the geographic distribution of the community that are of primary concern. They are the:

  • Natural features
  • Economic and social life
  • Political structure

Each pattern influences the other two. Pronounced geographic features of the community often determine where certain functions may be located. Main transportation routes, notably railroads, often follow the path with the least grade. Steep slopes or marshes may hinder construction.

Economic and social patterns concern most people, who tend to live in neighborhoods with others similar to themselves. Retailers locate in a commercial area where they can better serve their customers. Manufacturers situate their plants where they can obtain the best overall advantages for transportation, raw materials and labor force.

The governmental pattern, a quilt work of conflicting and overlapping jurisdictions, establishes the framework for providing public services and facilities and land development regulations such as zoning, subdivision regulations and building codes. This structure, highly complex, includes cities, counties, special districts, and state and federal agencies. The typical urban community has at least five governments serving its people — county, city, school district, state and federal. Such a pattern usually does not coincide with the realities of the economic and social community. Communication among these governments in the same locality is usually minimal; the activities of one are often contradictory to those of another. All these work done in a local government can be enhance with the help of computer.

  1. STATEMENT OF THE PROBLEM

Local government works involves the use of ledger, proof sheets, balance books etc which are manual in recording and keeping of their information. One of the biggest difficulties faced by manual method are:

Handling records beset with problems. The record are not kept well and retrieval as `very difficult

Loss of records is always common to manual auditing as there is no computerized way of storing the information contained in these records

Calculation can sometime be wrong. In most cases, this has through oft many accounts and names which resulted to suspense account being opened and could not be closed unless as a charge or credit to profit and less account.

Sequel to these problem, local government need to be computerized.

SIGN AND IMPLEMENTATION OF A COMPUTERIZED LOCAL GOVERNMENT ADMINISTRATION SYSTEM