COMPUTERIZED ACCIDENT DATABASE MANAGEMENT SYSTEM (A CASE STUDY OF FEDERAL ROAD SAFETY COMMISSION, UYO)

748

COMPUTERIZED ACCIDENT DATABASE MANAGEMENT SYSTEM (A CASE STUDY OF FEDERAL ROAD SAFETY COMMISSION, UYO)

ABSTRACT

This research work is focused on the development of a computerized accident database management system. The study was necessary because of the problems of the existing system which are: manual system of registering accident cases is inefficient, it is tedious to update accident case records in the manual system and reports of accident cases cannot be instantly retrieved because of the flat file organization. To overcome these problems, the objectives of this study are: to develop a system that can be used to register accident cases to database, to implement  a system that can be used to update accident case database records and to develop a system that can be used to obtain reports of accident cases for decision making. The software development methodology is Object Oriented Analysis and Design Methodology (OOADM). The programming technologies used is Visual BASIC 6.0 and the database used is Microsoft Access.

TABLE OF CONTENTS

Title Page             –        –        –        –        –        –        –        –        i 

Certification         –        –        –        –        –        –        –        –        –        ii

Dedication            –        –        –        –        –        –        –        –        iii

Acknowledgment –        –        –        –        –        –        –        –        iv

Abstract               –        –        –        –        –        –        –        –        v

Table of Contents –        –        –        –        –        –        –        –    vii-ix

List of Tables       –        –        –        –        –        –        –        –        x

List of Figures      –        –        –        –        –        –        –        –        xi

CHAPTER ONE: INTRODUCTION

1.0     Introduction         –        –        –        –        –        –        –        1

1.1     Background of the Study        –        –        –        –        –        –        1-3

1.2     Statement of the Problem                  –        –        –        –        –        3

1.3     Aim and Objectives of the Study                –        –        –        3-4

1.4     Significance of the Study         –        –        –        –        –        –        4

1.5     Scope of the Study        –        –        –        –        –        –        –        4

1.6     Organization of the Research  –        —       –        –        –        5

1.7     Definition of Terms       –        –        –        –        –        –        5

CHAPTER TWO: LITERATURE REVIEW

  •   Introduction  –        –        –                  –        –        –        –        6

2.1 The Need for Accidents Record Management –        –        –        6-8

2.2 Automated Accident Database Software Tool         –        –        –        8-10

2.3 Accidents Crash Data Management      –        –        –        –      10-11

  • Accidents Crash Record System Applications        –        –        –       11-13

2.5 How to Implement Accident Crash Record System –        –       13-14

2.6 Why Implement Accident Crash Data Collection Tools?  –      14-15

2.7 How a Crash Data Collection System Works          –        –        –      16-18

CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN

3.0 Introduction   –        –        –        –        –        –        –        –        19

3.1 Research Methodology      –        –        –        –        –        –        19

3.2 Analysis of the Existing System –        –        –        –        –        19

3.2.1 Advantages of the Existing System   –        –        –        20

3.2.2 Disadvantages of the Existing System        –        –        –        20

3.3 Analysis of the Proposed System         –        –        –        –        –        20

3.3.1 Advantages of the Proposed system  –        –        –        20

3.4 System Design         –        –        –        –        –        –        –        –        21

3.4.1 Input layout          –        –        –        –        –        –        –        –        21

3.4.2 Output Layout                                                 –   –        –        22

3.4.3 Algorithm                                                         –   –        –        23

3.4.4 Program Flowchart                                          –   –        –   24-28

3.4.5 Database Design   –        –                  –        –        –        –    29

3.4.6 System Architecture       –        –        –        –        –        –        29

3.4.7 Use Case/Class Diagram          –        –        –        –        –        –    30-31

CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION

4.0     Introduction                  –        –        –        –        –        –        –        32

4.1     System Design Diagram –        –        –        –        –        –        32

4.2     Choice of Programming Language              –        –        –        32

4.3     Analysis of Modules               –        –        –        –        –        33

4.4     Programming Environment     –        –        –        –        –        33

4.4.1 Hardware Requirements –        –        –        –        –        33

4.4.2 Software Requirements  –        –        –        –        –       33

4.5     System Implementation –        –        –        –        –        –        34

CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS

5.0     Introduction         –        –        –        –        –        –        –        –        35

5.1     Constraints of the Study         –        –        –        –        –        –        35

5.2     Summary                       –        –        –        –        –        –        35

5.3     Conclusion                     –        –        –        –        –        –        36

5.4     Recommendations         –        –        –        –        –        –        –        36

          References                      –        –        –        –        –        –        37

           Appendix A (Source Code)    –        –        –        –        –      

          Appendix B (Output)    –                                    

CHAPTER ONE
INTRODUCTION

1.0 Introduction

This chapter presents the introduction to the research work on computerized accident database management system, it also presents the background, statement of the problem, objectives of the study, significance of the study, organization of the research and definition of terms.

A computerized accident database management system is an automated system that is used to capture and save accident records to a database for easy updating and retrieval.

1.1 Background of the Study

An accident is an unexpected and undesirable event, a mishap, unforeseen and without apparent cause. The mounting toll of Road Traffic Accident (RTA) deaths in Nigeria has public health problem, which requires urgent attention since these deaths are preventable. The pattern of scold sustained in these fatalities has however been focused on RTA in this country, since the early seventies when concerned citizens advocated the setting up of road traffic marshals corps in the old western state of Nigeria. This metamorphosed into the traffic warden popularly called ‘yellow fever’ body in this country owed to the colour of their uniform. legislation in 1988 led to the setting up of Federal Road Safety commission (FRSC).The Federal Road Safety Commission (FRSC) was established by the government for the federal republic of Nigeria vide Decree 45 of 1988 as amended by Decree 35 of 1992, with effect from 18th February, 1988. The commission was charged with responsibilities for among others policy making, organization and administration of road safety in Nigeria. It is frequently stated in literature that many developing countries have insufficient data on accidents.

Only one-third of deaths from injuries were recorded in official statistics. Hospitals that record cases which reaches the hospital and may not be necessarily be the most severe. Police records in Nigeria, regrettably published statistics that may be unsatisfactory from the research standpoint because if incomplete reporting, inaccuracies, varying definitions of accident and injury. Research would be useful to find improved ways of record keeping and co-ordination of existing records which will provide useful data for health promotion activities. Today in Nigeria, death by accidents far exceed those by any communicable diseases in the country, road accident have been recognized as a major public health problem in Nigeria for some time. 

Observations have shown that cases of accident in Nigeria don’t have a record after it has occurred. With the manual process involved in handling the accident cases records, most of the patients spend their whole day in the hospital waiting to be attended to, at the end of which some do not even get medical attention. It is quite obvious that doctors and other medical staff needs a helper-someone or an aid that may be of help to them to remember cases of accident, what happened to the victims and the necessary approach to the conditions. 

It is also evident that the National Population Commission (NPC) also needs a better approach to record keeping of the population of the nation and also to measure the mortality rate and sorts of that which collectively helps in knowing the population status of a nation or a locality. This is essential because it is a factor which contributes to certain decision that may take place at any point in time. As a result of these factors, this project work has been designed to bring some sorts of improvements in the way record keeping of the accident cases should be made to ameliorate the situation of the manual way of record keeping.


1.2 Statement of the Problem

It is crystal clear that an efficient record keeping mechanism is needed in Federal Road Safety Commission (FRSC) to enable them take proper record of accident cases about a particular area which will at the long run help them also in knowing the various causes of the various accident incidences, how fatal it is, and how many individual (male, female, men, women, boys, girls, etc) that are involved and the various factors responsible to the accident occurrences. This has been lacking in the Federal Road Safety Commission of the nation and on this note, it is important that a computerized accident database management system is developed.  The following problems were identified:

  1. Manual system of registering accident cases is inefficient.
  2. It is tedious to update accident case records in the manual system.
  3. Reports of accident cases cannot be instantly retrieved because of the flat file organization.

1.3 Objectives of the Study 

The very aim/objective of this study is to develop a computerized accident database management system, an efficient way of record keeping using the rubrics of database (set of integrated files) in the Federal Road Safety Commission. The specific objectives are:

  1. To develop a system that can be used to register accident cases to database.
  2. To implement  a system that can be used to update accident case database records.
  3. To develop a system that can be used to obtain reports of accident cases for decision making.