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

By

Author

Presented To

Department of Computer Science

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.

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 adequate medical 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