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.