This project was centered on health clinical database information system. The current process of keeping records of patients is being operated manually and due to this procedure numerous problem are been encountered. A design was taken to computerized the manual process in order to check this problem. The problems were identified after series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The new system was designed using Microsoft visual basic 6.0 programming language. This language was chosen because of its easy syntax and features for developing windows based applications.
CHAPTER ONE 1.0 INTRODUCTION 1.1 BACKGROUND OF STUDY
Integrated of documentation and knowledge based computerized services in information system is a tremendous means to help health professionals in their daily practice and to improve its quality.
Effort is continuously being made in designing and developing economically and reliable database system to satisfy a clinical database information system. This project is about the design and development of a clinical database system for medical management of the federal poly Nekede medical centre and shows how records and data can be handled and stored within the system.
The system will store patients’ records, drug inventory and dispensation as well as other relevant clinical information within the polytechnic community. The system will be used by the staff doctor, nurses, clerks, consultants, and other relevant authorities as the demand may be within the clinic. It will process data speedily and accurately, provide information when and where required.
The clinical database system will be used to store data, produce reports and handle management enquires. In clinics that are made up of doctors, nurses, patient and other personnel staff, an Information system is required to keep track of the day to day transaction of the clinic and to improve the communication skills. Also this system will help in highlighting risk/complex patients for consultant input alert of DNA; easily identify all patient taking certain medications; monitor frequency of major complication example peptic ulcer, check for known drug interaction; improve evidence based practice, record questions in clinic for later response from the team when not sure of correct reply.
Therefore, it is hoped that the design and development of a clinical database system would provide a flexible and reliable management of the polytechnic clinic. This program is carefully design to work in a standalone system or in a multi-user environment.
1.2 STATEMENT OF THE PROBLEM
It is observed that federal polytechnic Nekede medical centre most of its record on staff, students, patients, drug and inventory and dispensary are handled manually. The problems associated with the manual method include inaccurate data, poor quality of patient care and administrative inefficiency. The task involved in this design is as follows:
1.3 OBJECTIVES OF THE STUDY
The primary aim of this project is to design and develop a clinical database system for federal polytechnic Nekede clinic, which will achieve the following:
1.4 SCOPE OF THE STUDY
The scope of this project is mainly on patient’s record, the drug prescription, available drugs, the drug dispensed and the efficiency of the drug dispensed. The application of query in getting the desired reports on drug inventory in the pharmaceutical unit.
1.5 LIMITATION OF THE STUDY
The project is carried out, following the appropriate stage involved in design and development of clinical software. The stage are briefly discussed below
1.7 DEFINITION OF TERMS
History file: This is a master file that contains data antenatal form. E.g. Patients’ names, address, medical histories, diagnosis, sex, age, type of admission, drug treatment, data for admission and discharge.
1.8 DATA DICTIONARY
This contains the list of items used and their different meanings according to how it is applied in the project.DESIGN AND IMPLEMENTATION OF HEALTH CLINICAL DATABASE INFORMATION SYSTEM