DESIGN AND IMPLEMENTATION OF DATA WAREHOUSE FOR RECORDING ACCIDENT CASES


DESIGN AND IMPLEMENTATION OF DATA WAREHOUSE FOR RECORDING ACCIDENT CASES

TABLE OF CONTENTTitle PageCertificationDedicationAcknowledgementTable of contentAbstractCHAPTER ONE1.0     LITERATURE REVIEW                                                1.1     BACKGROUND OF STUDY                                        1.2     STATEMENT OF PROBLEM                                        1.3     THE SIGNIFICANCE OF STUDY                                1.4     AIM/OBJECTIVE OF STUDY                                       1.5     SCOPE OF STUDY                                                      1.6     BLOCK DIAGRAM OVERVIEW                                 CHAPTER TWO2.1       WHAT IS DATA WAREHOUSE                                 2.2       WHAT ARE THE FEATURES                                     2.3       DESIGN OF A DATA WAREHOUSE                           2.3.1    NINE DECISION IN THE DESIGN OF ADATA WAREHOUSE                                                             2.4      CASES AND CAUSES OF ACCIDENTS                                                          2.4.1   WHAT ARE THE FACTORS THATCAUSES ACCIDENT                                                   CHAPTER THREE3.1       FEASIBILITY STUDIES                                               3.2.1    FACTS FINDING METHODS USED                            3.3       DBMS ANALYSIS AND SELECTION                           3.3.1    DATABASE MODELS                                                3.4       PROGRAMMING LANGUAGE ANALYSISAND SELECTION                                                           CHAPTER FOUR4.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 DESCRIPTION                            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 REQUIRMENTS                                           4.7.1    SOFTWARE REQUIRMENT                                        4.8       HARDWARE    SPECIFICATION                                 4.9     THE USER MANUAL                                                    4.9.1    INSTALLATION OF THE SOFTWARE                          4.9.2   RUNNING OF 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 FIVE5.0   SUMMARY                                                                    5.1   RECOMMENDATION                                                     5.2   CONCLUSION                                                                         REFERENCES                                                                      APPENDIXCHAPTER ONE:     INTRODUTION1.0    BACKGROUND OF THE STUDYThe 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.1    BACKGROUND OF STUDYObservations 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 timeAs 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 PROBLEMIt 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.3 THE SIGNIFICANCE OF THE PROJECTIt 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.4 AIMS/OBJECTIVES OF THE STUDYThe 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.5 SCOPE OF STUDYAs 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 research1.6  BLOCK DIAGRAM OVERVIEW

.


TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.COM

Researchwap.com is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.com guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.com is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.com" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.