DESIGN AND IMPLEMENTATION OF AN ICT ASSISTED DATABASE FOR SENIOR CITIZENS IN RIVERS STATE, NIGERIA


DESIGN AND IMPLEMENTATION OF AN ICT ASSISTED DATABASE FOR SENIOR CITIZENS IN RIVERS STATE, NIGERIA

ABSTRACT:            

The aim of this project is to develop a database for indigenes of rivers state that are above 60 years of age which will in turn help the government to conduct a free, adequate and sumptuous medical care for them. To replace the current inefficient manual system which include forecasting and approximation; To ensure credibility in free medical service for the old age through adequate database management system in the state; To help the rivers state government provide a free medical services for the people within the age of 60 and above through an error free database. The method of data collection for this study was interview method; this was done between the researcher and the Health officials. System of conducting indigenes registration was gathered from them and a well documented procedure for registration was ascertained. A search on online indigenes registration system was also carried out and a lot of information concerning the system in question was obtained. Some forms that are necessary and available were assessed. Also Internet downloads was made to obtain some text materials. At the end of this project work, I was able to design and develop software that can successfully handle an ICT assisted database for budgeting free medical care for indigenes of rivers state within the age of sixty years and above. This work also will serve as an aid for people who wish to research more on this topic. Other benefits are:Provision of facility for handling text electronically using powerful and sophisticated word processors to produce elegant and error free documents;In addition to storing the data, direct data capture was implemented. The systematic approaches used during each phase of the software development provide a clear insight that would be of immense help to anyone carrying out research works in this area.

TABLE OF CONTENT

Title Page

Certification

Dedication

Acknowledgement

Table of content

Abstract

CHAPTER ONE

1.0     INTRODUCTION

1.1    Background of the Study

1.2    Statement of the Problem

1.3    Objectives of the Study

1.4 Scope of the Study

1.5 Limitations

1.6 Significance of the Study

1.7 Project Report Organization

1.8 Definition of Terms

CHAPTER TWO

2.0    Literature Review

2.1    Overview of Database Terminology

2.2    Applications and Roles of Database

2.3    General-purpose and Special-purpose Database management

2.4    History of Database

2.4.1 1960’s Navigational Database Management

2.4.2    1970s, relational DBMS

2.4.2.1    Integrated approach

2.4.3    Late 1970s, SQL DBMS

2.4.4    1980s, on the desktop

2.4.5    1980s, object-oriented

2.4.6    2000s, NoSQL and NewSQL

2.5    Overview of Medical Care

2.6    Healthcare Delivery

2.6.1    Primary Healthcare

2.6.2    Secondary care

2.6.3    Tertiary Care

2.6.4    Quaternary care

2.6.5    Home and community care

2.7    Healthcare Financing

2.8    Health care administration and regulation

2.9    Health Care in the United States

CHAPTER THREE

3.0 System Analysis and methodology

3.1 Description and Analysis of the Existing System

3.2 Fact Finding Method / Methodology

3.2.1 Interview Method

3.2.2 Reference to Written Text

3.3 Present Procedures

3.4 Information Flow Diagram

3.5 Input, Process and Output Analysis

3.5.1 Input Analysis

3.5.2 Process Analysis

3.5.2 Output Analysis

3.6 Problems of the Current System

3.7 Justification for the New System

CHAPTER FOUR

4.0    SYSTEM DESIGN, TESTING AND IMPLEMENTATION

4.1Specifications of the New System

4.2 Input Specification

4.3 Output Specification

4.4    Database Specification

4.5    Main Menu Design

4.6    Subsystem Design

4.6.1    Login Subsystem

4.6.2    Registration Subsystem

4.6.3    Report Subsystem

4.7    System Flowchart

4.8    PROGRAM FLOWCHART

4.9 Program Modules Specification

4.10 Choice of Programming Language

CHAPTER FIVE

5.0 RECOMMENDATION, SUMMARY AND CONCLUSIONS

5.1 Recommendation

5.2 Summary

5.3 Conclusions

REFERENCES

APPENDIX

SOURCE CODE

CHAPTER ONE

INTRODUCTION

1.1    Background of the Study

    A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

Database management systems (DBMS) are specially designed software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known Database management include MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP HANA, dBASE, FoxPro, IBM DB2, LibreOffice Base and FileMaker Pro. A database is not generally portable across different Database management, but different Database management can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database.

There is a need to improve the mode of doing things in the government of a nation through the organization of a standard error free and fully monitored database so that the keeping of data in every sector and arms of the government will be easier. The mode of keeping files and folders in shelves is now getting uglier and outdated and should be replaced by the modern system which will involve only few computers and its operators and can handle almost everything in the state, with less effort and complete accuracy.

The issue of medical care is planned centrally by every government, and is aimed at every rightful citizen; most especially the old aged people who need constant care and medical treatment.

1.2    Statement of the Problem

    Calculating a budget to meet the citizens need is highly cumbersome, approximation and forecasting to meet the need of citizens has done a lot of harm and usually causes inadequacies in the distribution of basic services such as medical care and many more in Rivers state, Nigeria. The major problem of this study is the inadequate supply of free medical care to the old age people who are above 60 years in rivers state, this people are those who really need to be cared for unlike the youths who are still agile and still strong to take care of themselves.

1.3    Objectives of the Study

    The aim of this project is to develop a database for indigenes of rivers state that are above 60 years of age which will in turn help the government to conduct a free, adequate and sumptuous medical care for them.

⦁    To replace the current inefficient manual system which include forecasting and approximation.

⦁    To ensure credibility in free medical service for the old age through adequate database management system in the state.

⦁    To help the rivers state government provide a free medical services for the people within the age of 60 and above through an error free database.

1.4 Scope of the Study

The research work is designed to enable rivers state government to use electronic device to capture information of the people between the age of 60 years and above. The design will cover some security issues like authenticating the nationality of the people through integrating the national ID database to the medical registration process.

1.5 Limitations

During the design of this project work, much finance was required and owing to the financial meltdown globally, the research was limited by finance and hence concentrated on the available materials within the locality.

1.6 Significance of the Study

In view of the rapid development of computer technology in virtually all fields of operation and its use in relation to information management, it has become important to look into the development of an ICT assisted database to enable rivers state government to achieve the following:

(a) Conduct free and adequatemedical care service safely.

(b) Safeguard data and information in the system.

(c) Reduced workload in the process of budget making.

(d) Keep accurate record of the old age indigenes.

(e) Reaching different kind of people with their respective needs after budgeting.

(f) Eliminate fraudulent activities in the government services.

1.7 Project Report Organization

This project was covered under five stages:

CHAPTER 1; Deals with the introduction. The background of the project is discussed. The objectives of the project, its significance, scope, and constraints are pointed out.

CHAPTER 2; this chapter is a Review of database management system and also free medical service in some countries.

CHAPTER 3; Discusses system Investigation and Analysis. It deals with detailed investigation and analysis of the existing system and problem identification.

CHAPTER 4; Treats the system design and implementation

CHAPTER 5; the summary and conclusion of the project are finally treated in this chapter.

1.8 Definition of Terms

Information System: It is a collection of procedures, people, instructions and equipment to produce information in a useful form

Technology: It is study of techniques or process of mobilizing resources (such as information) for accomplishing objectives that benefit man and his environment

Computer Network: is a system that connects two or more computers together using a communication link.

Databases: A systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated. It is also called databank.

.


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.