DATA WAREHOUSE SYSTEM FOR ACCIDENT CASE RECORD
DATA WAREHOUSE SYSTEM FOR ACCIDENT CASE RECORD
ABSTRACT
This research work focused on the development of a data warehouse system for accident case record, using Federal Road Safety Commission in Ikot Ekpene as a case study. The research work was necessary because of the problems of the existing system such as  lack of proper record keeping of accident cases due to manual documentation, inability to easily manage accident case records, absence of a data warehouse application for monitoring trend of accident case for effective decision making. In view of solving these problems, the objectives of the research work are to implement a data warehouse application for registration of accident case record, to create a system that will facilitate easy management of registered accident case records in the data warehouse, to implement a system that can be used to monitor the trend of accident cases for decision making, to implement a system that will aid instant retrieval of reports of accident case records when needed. The significance of the research work are it will facilitate proper record keeping of accident case records and it will enable the management and staff of Federal Road Safety, Ikot Ekpene to operate professionally. Object Oriented Analysis and Design Methodology (OOADM) are used as the design methodology. The programming technologies used is HTML, CSS, PHP and MYSQL.
TABLE OF CONTENTS
Title Page – – – – – – – – i
Certification – – – – – – – – – ii
Approval Page – – – – – – – iii
Dedication – – – – – – – – iv
Acknowledgment – – – – – – – – v
Abstract – – – – – – – – vi
Table of Contents – – – – – – – – vii-ix
List of Figures – – – – – – – – – x
List of Tables – – – – – – – xi
CHAPTER ONE: INTRODUCTION
1.0 Introduction – – – – – – – 1
1.1 Background of the Study – – – – – – 1-3
1.2 Statement of Problem – – – – – 3
1.3 Aim and Objectives of the Study – – – 3
1.4 Significance of the Study – – – – – – 4
1.5 Scope of the Study – – – – – – – 4
1.6 Organization of the Research – – – – – 4-5
1.7 Definition of Terms – – – – – – 5
CHAPTER TWO: LITERATURE REVIEW
2.0 Introduction – – – – – – – 6
2.1 Theoretical Background – – – – – – 6-7
2.2 Data Warehouse Conceptual Architecture – – – 7-8
2.3 Approaches for Storing Data in Data Warehouse – – 8-9
2.4 Data Warehouse Design Methodologies – – – – 9-11
2.5 Benefits of Data Warehouse – – – – – – 12
2.6 Disadvantages of Data Warehouses – – – – 13
2.7 Rationale for Accident Record Management – – – 13-16
2.8 Accident Investigation and Lessons from Accidents – – 16-17
CHAPTER THREE: ANALYSIS AND DESIGN
3.0 Introduction – – – – – – – – 18
3.1 Research Methodology – – – – – 18
3.2 Analysis of the Existing System – – – – – 18-19
3.2.1 Disadvantages of the Existing System – – – 19
3.3 Analysis of the Proposed System- — – – 19
3.3.1 Advantages of the Proposed System – – – – 19
3.4 System Design – – – – – – – 20
3.4.1 Input Layout – – – – – – 20
3.4.2 Output Layout – – – – – – 21
3.4.3 Algorithm – – – — – – 21 3.4.4 Program Flowchart – – – – – 22-27
3.4.5 Database Design – – – – – – 28
3.4.6 System Architecture – – – – – 28
3.4.7 Use Case Model/Class Diagram – – – – 29-31
CHAPTER FOUR: IMPLEMENTATION AND DOCUMENTATION
4.0 Introduction – – – – – – – 32
4.1 System Design Diagram – – – – – – 32
4.2 Choice of Programming Language – – – 33
4.3 Analysis of Modules – – – – – 33
4.4 Programming Environment – – – – – 33
4.4.1 Hardware Requirements – – – – – 33-34
4.4.2 Software Requirements – – – – – 34
4.5 System Implementation – – – – – 34
4.6 Software Testing – – – – – – 34
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.0 Introduction – – – – – – – – 35
5.1 Constraints of the Study – – – – – – 35
5.2 Summary – – – – – – 35-36
5.3 Conclusion – – – – – – 36
5.4 Recommendations – – – – – – 36
References – – – – – – 37
Appendix (A) – – – – – – 38-47
Appendix (B) – – – – – – 48-52
CHAPTER ONE
INTRODUCTION
1.0 Introduction
This chapter presents the introduction, background of the study, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.
DATA WAREHOUSE SYSTEM FOR ACCIDENT CASE RECORD
