ABSTRACT
Emergency Data Information System for Road Accident Victims(EDISRAV) is an online repository of personal emergency medical data and blood bank information, designed to facilitate collaboration between hospital accident emergency units and blood banks. This system perform two basic tasks: (1) It contains emergency medical data of registered members such as; blood groups and allergies. (2) It provides information about registered blood banks, and also provides access to their contents. This system is managed by an administrator who registers people, blood banks, and hospitals with the system. This information system aims at eliminating the stress and risk involved in running around for blood and test during emergency cases. This system was implemented with PHP and MYSQL. The Emergency Data Information System for Road Accident Victims(EDISRAV) will reduce deaths associated with excessive loss of blood in the cases of road accidents to the barest minimum if implemented in Nigeria.
TABLE OF CONTENTS
Certification Page i
Dedication ii
Acknowledgement iii
Abstract iv
Table of Contents v
List of Figures xi
List Tables xiii
CHAPTER ONE
INTRODUTION
1.1 Background 1
1.2 Statement of the problems 4
1.3 Aims/Objectives 5
1.4 Scope of the project 5
1.5 Project justification 6
1.6 Project Report Organization 6
1.7 Definition of Terms 6
CHAPTER TWO
LITERATURE REVIEW
2.1 Road accidents rate in Nigeria 9
2.2 Information System 13
2.2.1 Components of Information Systems 13
2.3 Emergency Management 14
2.4 Emergency Management Information System 15
CHAPTER THREE
METHODOLOGY AND SYSTEM ANALYSIS
3.1 Approach 19
3.2 Tools: 21
3.2.1 PHP 21
3.2.2 MYSQL 21
3.3 Information Gathering 22
3.4 Data Analysis 22
3.5 Limitations of the Existing System 22
3.6 Overview of the Envisaged System 22
CHAPTER FOUR
SYSTEM DESIGN
4.1 System architecture 24
4.2 Project modules 24
4.2.1 Blood Bank Module 25
4.2.2 Sign Up Module 25
4.2.3 Blood Purchases Module 26
4.2.4 Sales Module 27
4.2.5 Stock module 28
4.2.6 Setup Module 29
4.2.7 About EDISRAV module 29
4.3 Flowcharts of operation 30
4.4 Database design 38
4.4.1 Blood bank table 38
4.4.2 Members table 39
4.4.3 PIN table 40
4.4.4 Stock table 41
4.5.5 Users table 42
CHAPTER FIVE
SYSTEM IMPLEMENTATION AND TESTING
5.1 System Requirements 43
- System Modules Implementation 44
- Main Interface Module 44
5.2.2 EDISRAV Administrator’s Homepage 45
- About EDISRAV Module 46
5.2.4 Members’ Module 47
- Personal Data Module 49
- Blood Bank Module 50
5.2.7 Sign Up Module 51
- Purchases Module 52
- Sales Module 53
5.2.10 Stock Module 54
5.2.11 Setup Module 55
5.2.12 Individual Members’ Module 56
5.2.13 Blood Bank Officers’ Module 57
5.3 Test Plan 59
- Personal Data Module Test 59
- Blood Bank Module Test 60
5.3.3 Sign Up Module 60
5.3.4 Purchases Module 61
5.3.5 Blood Sales Module 61
5.3.6 Stock Module 62
5.3.7 Setup Module 62
5.3.8 Main Interface Test 63
- EDISRAV Homepage Module Test 63
5.4 System Performance Evaluation 65
- BEME(Bill of Engineering Measurement and Evaluation) 66
CHAPTER SIX
SUMMARY, RECOMMENDATION AND CONCLUSION
- Summary 67
6.2 Problems Encountered 67
6.3 Recommendation 68
6.4 Contribution to Knowledge 68
- Conclusion 68
BIBILIOGRAPHY
APPENDIXES
Appendix A: Source Code
Appendix B: User Guide
CHAPTER ONE
1.1 Background
The rate at which road accidents occur in Nigeria is alarming. This led to lost of lives and property. There have been reported cases of families that were wiped out by road accidents. This now posed a great challenge to the federal government of Nigeria.
In an attempt to reduce untimely deaths and destruction of lives properties resulting from road accidents, the Federal Government of Nigeria formally approved the establishment of the Federal Road Safety Commission in 1988. The main objectives of the FRSC is to enforce traffic laws and regulations. The government of the Federal Republic of Nigeria through the Federal Road Safety Corps (FRSC) embarked on road safety campaign programmes, proper placement of traffic signs, periodic review of highway code, construction and maintenance of roads, recruitment and training of traffic police and road wardens on the enforcement of road safety rules and regulations, and a host of others, to see that the lives of the citizens of this country were not wasted unnecessarily.
The statistics of road accidents in Nigeria before the establishment of the Federal Road Safety Commission, for the period of 24 years (1960 – 1984) is as shown in table 1 below:
Table 1: 1960 – 1984 Nigerian Road Accident Statistics
| YEAR | TOTAL CASES REPORTED | NO OF PERSONS KILLED | NO OF PERSONS INJURED |
| 1960 | 14,130 | 1,083 | 13,216 |
| 1961 | 15,963 | 1,313 | 10,614 |
| 1962 | 16,317 | 1,578 | 10,341 |
| 1963 | 19,835 | 1,532 | 7.771 |
| 1964 | 15,927 | 1,769 | 12,581 |
| 1965 | 16,904 | 1,918 | 12,024 |
| 1966 | 14,000 | 2,000 | 13,000 |
| 1967 | 13,000 | 2,400 | 10,000 |
| 1968 | 12,163 | 2,808 | 9,474 |
| 1969 | 12,998 | 2,347 | 8,804 |
| 1970 | 16,666 | 2,893 | 13,154 |
| 1971 | 17,745 | 3,206 | 14,592 |
| 1972 | 23,287 | 3,921 | 16,161 |
| 1973 | 24,844 | 4,537 | 18,154 |
| 1974 | 28,893 | 4,992 | 18,660 |
| 1975 | 32,651 | 5,552 | 20,132 |
| 1976 | 40,881 | 6,761 | 28,155 |
| 1977 | 35,351 | 8,000 | 30,023 |
| 1978 | 36,111 | 9,252 | 28,854 |
| 1979 | 29,271 | 8,022 | 21,203 |
| 1980 | 32,138 | 8,736 | 25,484 |
| 1981 | 33,777 | 10,202 | 26,337 |
| 1982 | 37,094 | 11,382 | 28,539 |
| 1983 | 32,109 | 10,462 | 26,866 |
| 1984 | 28,892 | 8,830 | 23,861 |
| 1960-1984 | 600,947 | 125,496 | 445,000 |
Source: Jacobs and Hands (1988). Accidents Rates in Developing Countries (Nigeria).
Despite the efforts of the federal government and the Road Safety Commission of Nigeria to reduce road accidents to the barest minimal, road accidents still claim the lives of Nigerians in large numbers every year.
The Sun News Publishing of Thursday, November 20, 2008 reported that the Corps Marshall of the Federal Road Safety Commission (FRSC), Mr. Osita Chidoka, revealed that about 4,800 people die in road accidents in Nigeria every year. Also, the FRCN Corps Marshal in a National Stakeholders’ Forum on Road Safety, recently, revealed that 7,737 road accidents were recorded in the country within the period of four months (December,2009 – March, 2010), which resulted to about 1,056 deaths.
It is therefore obvious that some of the people who were involved in road accidents would have survived if urgent attentions were given to them such as giving them the right type of blood and avoiding given them drugs they are allergic to .
Because of the above problems, and because there are very few blood banks in Nigeria, and they are manually operated, I deemed it necessary to embark on this project “Emergency Data Information System for Road Accident Victims”
1.2 Statement of the problems
Road accidents rate in Nigeria is very high. Unfortunately, most of the accident victims die as a result of excessive loss of blood from injuries sustained.
Though there are accident emergency units in our various government hospitals, these hospitals do not have efficient blood banks for blood transfusion. Even where there are, they are managed manually and the hospital management is always faced with compatibility problem of the blood group of the accident victims and what they have in stock.
It therefore becomes necessary to develop a database management information system for these accident emergency units and blood banks. This information system will facilitate collaboration amongst these units, give them access to compatible blood groups with that of the victims and, if need be, place order for a specific blood group for blood transfusion. This will go a long way in saving the lives of seriously injured accident victims in Nigeria.
1.3 Aims/Objectives
My aim of embarking on this project is to implement an information system that provides quick information on the available blood types in different blood banks registered with it, the blood bank locations, and also provide important client’s data such as blood groups and allergies, needed to save lives in cases of road accidents.
1.4 Scope of the project
The Emergency Data Information System for Road Accident Victims (EDISRAV) is an information system. So this project covers the design and implementation of an information system.
1.5 Project justification
The recent statement made by the Corps Marshall of the Federal Road Safety Commission (FRSC), Mr. Osita Chidoka, in a National Stakeholders’ Forum on Road Safety, revealing that 7,737 road accidents were recorded in the country within the period of four months (December,2009 – March, 2010), which resulted to about 1,056 deaths justifies this project because this project will help to save accident victims lives if implemented by the federal government.
1.6 Project Report Organization
This project report is made up of six chapters; chapter one is the introduction, chapter two is the literature review, chapter three is the methodology and system analysis, chapter four is the system design, chapter five is the implementation and testing, chapter five is summary, recommendation and conclusion.
1.7 Definition of Terms
(i) Database: A database is a structured collection of records or data that is stored in a computer system.
(ii) Web browser: A web browser is a client that connects to web servers and retrieve web pages for display.
(iii) Server: A server is a computer program that provides services to other computer programs(client), in the computer. The physical computer that runs a server program is also referred to as server
(iv) Client: A client is an application(in a system) that accesses a remote service on another computer system known called server.
(v) PHP: PHP stands for Hypertext Pre-processor.
Do you need help? Talk to us right now: (+234) 08060082010, 08107932631 (Call/WhatsApp). Email: [email protected].IF YOU CAN'T FIND YOUR TOPIC, CLICK HERE TO HIRE A WRITER»
