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 CONTENTTitle PageCertificationDedicationAcknowledgementTable of contentAbstractCHAPTER ONE1.0 INTRODUCTION1.1 Background of the Study1.2 Statement of the Problem1.3 Objectives of the Study1.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 TWO2.0 Literature Review2.1 Overview of Database Terminology2.2 Applications and Roles of Database2.3 General-purpose and Special-purpose Database management2.4 History of Database2.4.1 1960’s Navigational Database Management2.4.2 1970s, relational DBMS188.8.131.52 Integrated approach2.4.3 Late 1970s, SQL DBMS2.4.4 1980s, on the desktop2.4.5 1980s, object-oriented2.4.6 2000s, NoSQL and NewSQL2.5 Overview of Medical Care2.6 Healthcare Delivery2.6.1 Primary Healthcare2.6.2 Secondary care2.6.3 Tertiary Care2.6.4 Quaternary care2.6.5 Home and community care2.7 Healthcare Financing2.8 Health care administration and regulation2.9 Health Care in the United StatesCHAPTER THREE3.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 FOUR4.0 SYSTEM DESIGN, TESTING AND IMPLEMENTATION 4.1Specifications of the New System 4.2 Input Specification 4.3 Output Specification 4.4 Database Specification4.5 Main Menu Design4.6 Subsystem Design4.6.1 Login Subsystem4.6.2 Registration Subsystem4.6.3 Report Subsystem4.7 System Flowchart4.8 PROGRAM FLOWCHART4.9 Program Modules Specification 4.10 Choice of Programming Language CHAPTER FIVE5.0 RECOMMENDATION, SUMMARY AND CONCLUSIONS 5.1 Recommendation5.2 Summary 5.3 Conclusions REFERENCESAPPENDIXSOURCE CODECHAPTER ONEINTRODUCTION1.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..