Design and Implementation of a Profited Database System for Government Establishment

Design and Implementation of a Profited Database System for Government Establishment

Project / Seminar Material
Reference ID: PS-5787-TM

DEDICATION

This research material titled “Design and Implementation of a Profited Database System for Government Establishment” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of a Profited Database System for Government Establishment” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES

CHAPTER ONE

INTRODUCTION

    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction
    • ⋮

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”

    Design and Implementation of a Profited Database System for Government Establishment

    CHAPTER ONE

    Introduction

    1.1 Background Of The Study

    As much as have to receive adequate welfare and entitlements the personnel database must be maintain effectively. The personnel database is the comprehensive information update of employees under a particular employee at a particular time. The maintenance and management of employee information has bee a big problem in the Nigerian society workers denied of their primary and secondary entitlements and the most sad aspect of inadequacy in the maintenance of employee information is the erupt of ghost workers syndrome, this has the greatest thing this laxity in personal database system has caused in the society. The problem of promotion is also on offspring of inadequate personnel database management; who to promote when there is necessity for promotion is always the problem faced by personnel officers in change of promotion exercise.

    Workers have suffered a lot under this error of ignorance and sheet wickedness in every activity work of life, the first thing to be observed is always information about the staff involved. This helps to give out desired incentives for the works, to help them put in their best in their work the non-payment of salary or in some cases, the delay in payment of salary is always caused by the problems associated with personnel database.

    This work researched into the operational activities of existing system of maintaining personnel database in Enugu state with a view to detecting and solving the problems making it not to work out smoothly.

    1.2 Statement Of The Problem

    The problem caused by poor management and maintenance of personnel database in Enugu state is numerous. Th procrastination in payment of workers salary is a work force badly. Because of the fact that act information of worker s in the state is not known the state faces the problem of how to provide incentives for its worker. A lot of public money is been diverted into private purses due to the problem of poor information management concerning personnel records.

    1.3 Purpose Of Study

    The main purpose of this study is to provide ever lasting solution to the current problems facing the Enugu state personnel database maintenance system through a well computerized design.

    1.4 Aim/Objectives Of Study

    The primary aim of this work is to make sure that personnel database management system of EnuguState is to serve the citizen better by producing a new computerized system that will tackle the problems currently facing it.

    The objectives include:

    1. To create a system that will maintain workers records randomly and give easy and tidy access to the stored record for easy information retrieval.
    2. To maintain a database that will support sorting and searching of records automatically
    3. To maintain an internecine database.

    1.5 Scope Of The Problem

    This study is carried out covering the totality of personnel database system in Enugu state in the areas of quick information retrieval automatic promotion list generation, ghost workers control and timely salary payment

    Assumptions

    If the new design is completely implemented the whole problems associated with the existing system will be all solved.

    1.6 Definition Of Terms

    Work force

    Is the personnel strength of the organization.

    Welfare

    Is the condition of comfort in an area of work.

    System

    Is a network of interrelated procedures combined to form a unit

    Policy

    Is a plan of actions, aims and ideas, sophisticated, having learnt the ways of the world and having lost natural simplicity.

    Implementation

    Carry an undertaking agreement promise into effect.

    Information age

    The current age of information technology around the globe.

    …

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of a Profited Database System for Government Establishment