TABLE OF
CONTENT
CHAPTER
ONE
1.0
INTRODUCTION
1.1
BACKGROUND OF STUDY
1.2 STATEMENT
OF PROBLEM
1.3 THE
SIGNIFICANCE OF THE PROJECT
1.4 AIMS/OBJECTIVES
OF THE STUDY
1.5 SCOPE OF
STUDY
1.6 BLOCK DIAGRAM OVERVIEW
CHAPTER
TWO
2.1 WHAT IS
DATA WAREHOUSE?
2.2 WHAT ARE
THE FEATURES OF DATA WAREHOUSE
2.3 DESIGN
OF A DATA WAREHOUSE
2.3.1
NINE DECISIONS IN THE DESIGN OF A DATA
WAREHOUSE
2.4 CASES
AND CAUSES OF ACCIDENT
2.4.1 WHAT ARE THE FACTORS THAT CAUSES ACCIDENTS?
CHAPTER
THREE
3.1 FEASIBILITY
STUDIES
3.2 RESEARCH
METHODOLOGY
3.2.1 FACTS FINDING METHODS USED
3.3
DBMS ANALYSIS AND SELECTION
3.3.1 DATABASE MODELS
3.3
PROGRAMMING LANGUAGE ANALYSIS AND SELECTION
CHAPTER FOUR
4.0 SYSTEM
DESIGN AND IMPLEMENTATION
4.0.1 CREATING/ DESIGNING THE DATABASE
4.1 SYSTEM DESCRIPTION
4.1.2 THE SPLASH SCREEN
4.1.3 THE PASSWORD FORM
4.2 MAIN MENU DESIGN
4.3 SUB MENU DESIGN
4.3.1 SHORT CUT KEYS AND
DESCRIPTION
4.4 FLOWCHARTS
AND DESCRIPTIONS
4.4.1 THE NEW UPDATE OPERATION
4.4.2 THE QUERY OPERATION
4.5 THE
HELP MENU DESIGN
4.6 SYSTEM
TESTING INTEGRATION
4.6.2 TEST
PLAN
4.6.3 TEST
DATA
4.7 SYSTEM REQUIRMENT
4.7.1
SOFTWARE SPECIFICATION
4.8 HARDWARE SPECIFICATION
4.9 THE USER
MANUAL
4.9.1 INSTALLATION OF THE SOFTWARE
4.9.2 RUNNING
THE PROGRAM
4.9.3 ENTERING
NEW DATA
4.9.4 MAKING
QUERY
4.9.5 VIEW
DATABASE IN GRID
4.9.6 VIEW HELP
4.9.7 EXITING
THE PROGRAM
CHAPTER FIVE
SUMMARY, CONCLUSON AND RECOMMENDATIONS
5.1 SUMMARY
5.2 RECOMMENDATION
5.3 CONCLUSION
REFERENCES
CHAPTER ONE
1.1
INTRODUCTION
The dictionary defines
accident as “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
(Jacobs and Sayer, 1983; Mohan, 1997.)
Mohan,(1984) estimated that
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.
Udomah and
Edafiogho(1990),says that 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 (Asogwa,1978).
1.2
BACKGROUND
OF STUDY
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.3 STATEMENT OF 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 at this note is
the problem that the study of the project aims at repositioning to make things
be as it should.
1.4 THE SIGNIFICANCE OF THE PROJECT
It has
been said that “information is life” and from all aspects, no entity can exist
and survive the times when there is no proper way of getting robust information
for its up keeping. The study of this project is most significant in the area
of record keeping of the accident cases and causes which is a very good source
of data for computation in the National Population commission and in nation’s
budgeting. Also it will help in keeping record of the various frequent causes
of road accident so as to know the channel by which the government of the area
will go in order to put to stop those various causes of accident.
1.5 AIMS/OBJECTIVES OF THE STUDY
The very
aim/objective of this study is to develop an efficient way of record keeping using
the rubrics of database (set of integrated files) in the Federal Road Safety
Commission. This is most accomplished by developing a data warehouse- for
accident cases and causes.
1.6 SCOPE OF STUDY
As can be
deducted from the topic of this study – design and development of data
warehouse for accident cases and causes for road safety in Nigeria – the
researcher narrows her research towards developing the data warehouse for
accident cases and causes only, pinpointing the various causes most accident
that occurs on the Nigerian road, designing a database software that will help in making the recording keeping of
the cases and causes of accident which incorporates the common database
operations like querying for a particular set of field or range of certain
entities. The scope of the study encompasses the above mentioned featured which
are what the researcher deemed necessary to be part of the end product of her
research
Buyers has the right to create
dispute within seven (7) days of purchase for 100% refund request when
you experience issue with the file received.
Dispute can only be created when
you receive a corrupt file, a wrong file or irregularities in the table of
contents and content of the file you received.
ProjectShelve.com shall either
provide the appropriate file within 48hrs or
send refund excluding your bank transaction charges. Term and
Conditions are applied.
Buyers are expected to confirm
that the material you are paying for is available on our website
ProjectShelve.com and you have selected the right material, you have also gone
through the preliminary pages and it interests you before payment. DO NOT MAKE
BANK PAYMENT IF YOUR TOPIC IS NOT ON THE WEBSITE.
In case of payment for a
material not available on ProjectShelve.com, the management of
ProjectShelve.com has the right to keep your money until you send a topic that
is available on our website within 48 hours.
You cannot change topic after
receiving material of the topic you ordered and paid for.
Login To Comment