DESIGN AND IMPLEMENTATION OF PATIENT BOOKING AND CONSULTING SYSTEM (A CASE STUDY OF KHADIJA MEMORIAL HOSPITAL, KANO)
ABSTRACT
Patient Booking and Consulting System is the use of information and telecommunication technologies to provide medical information and services at a distance. Due to shortages of medical experts, hospitals coupled with geographic isolation and lack of opportunities for these experts, the few available medical experts are often reluctant to serve in such poorer areas with lesser opportunities and advantages. As the result of this problems, design and implementation of a patient booking and consulting system is proposed and the aim of this project is to design and implement a patient booking and consulting system taking as a means whereby patient can book appointment and chat with physician(s) (doctor). The objectives of the proposed system is to study and analyze, design, implement, test and validate the proposed system. The method used to achieved the proposed system is the agile incremental development method for the SDLC, use case is used for the analysis of the system and activity diagram are used to design the new system, processing requirement, the input and the output specification. The proposed system run on a web browser using HTML, CSS, JavaScript at the front end while PHP was used for the validation and MySql is used to store and retrieved information from the database. The following objectives are achieved after the new system has been design and implemented, the system enable to book appointment and consult the doctor directly.
TABLE OF CONTENTS
DECLARATION ii
CERTIFICATION iii
DEDICATION iv
ACKNOWLEDGEMENT v
ABSTRACT vi
TABLE OF CONTENTS vii
LIST OF TABLES ix
LIST OF FIGURES x
CHAPTER ONE 1
1.0 INTRODUCTION 1
1.2 Statement of the Problem 2
1.3 Aim and Objectives of the Project 2
1.3.1 Aim of this project 2
1.3.2 Objectives 2
1.4 Significant of the Study 3
1.5 Scope and Limitation 3
1.5.1 Scope of the Study 3
1.5.2 Limitation of the Study 3
CHAPTER TWO 4
LITERATURE REVIEW 4
2.1 Introduction 4
2.2 Review of Related Work 4
CHAPTER THREE 9
SYSTEM ANALYSIS AND DESIGN 9
3.1 Introduction 9
3.2 Software Development Life Cycle 9
3.3 System Analysis 10
3.3.1 Requirement Elicitation 10
3.4 Description of the Existing System 10
3.5 Problems with the Existing System 11
3.6 Description of the Proposed System 11
3.7 System Requirements 11
3.7.1 Functional Requirement 11
3.7.2 Non Functional Requirement 12
3.7.3 Use Case 12
3.8 System Design 16
3.9 System Design Specification 16
3.9.1 Activity Diagram 16
3.10 Database Design 20
3.11 System Architecture 22
CHAPTER FOUR 24
SYSTEM IMPLEMENTATION AND TESTING 24
4.1 System Implementation 24
4.2 System Requirement 24
4.2.1 Software Requirement 24
4.2.2 Hardware Requirement 24
4.3 Description of the Implemented System 25
4.4 System Testing 29
4.3.1 Unit Testing 30
4.4.2 Integration Testing 31
CHAPTER FIVE 33
SUMMARY, CONCLUSION AND RECOMMENDATIONS 33
5.1 Summary 33
5.2 Conclusion 33
5.3 Recommendations 33
REFERENCES 35
LIST OF TABLES
Table 3.1: Database Structure for Admin 20
Table 3. 2: Database Structure for Patient 20
Table 3.3: Database Structure for Doctor 21
Table 3. 4: Database Structure for Booking Appointment 21
Table 3. 5: Database Structure for Chat 22
Table 4.1: Unit Testing 30
Table 4.2: Integrating Testing 31
LIST OF FIGURES
Figure 3.1 Incremental Development Model (Aggarwal & Singh, 2012) 10
Figure 3.2: Use Case Diagram 13
Figure 3.3: Activity Diagram for Patient Login Page 17
Figure 3.4: Activity Diagram for Doctor Login 18
Figure 3.5: Activity Diagram for Admin Page 19
Figure 3.6: System Structure 23
Figure 4.1: Patient Profile Creation Page 25
Figure 4.2: Login Page 25
Figure 4.3: Patient Dashboard 26
Figure 4.4: Patient Book Appointment Page 26
Figure 4.5: Doctor's Page 27
Figure 4.6: Doctor View Appointment Page 27
Figure 4. 7: Admin Page 28
Figure 4. 8: Add or Remove Physician Field Page 28
Figure 4. 9: Create Doctor Profile Page 29
CHAPTER ONE
1.0 INTRODUCTION
A patient booking system is the use of information and telecommunication technologies to provide medical information and services at a distance(Adewale O. S., 2004). Patient booking has existed long before the Internet, some authors observed that telemedicine was broadly conceived even when the term was used almost three decades ago. In many cases, no physician was involved, and interactivity was not a necessary aspect of the processing.
Consultation can be defined as the communication process between a patient and a physician on a medical issue. The medical consulting is a two-way encounter between a doctor and a patient. This may be initiated by a patient when they are ill or by a doctor when instituting preventive medicine or screening. The medical consulting is being done by the patient booking an appointment with the physician by physical appearance of the patient at the health center which at time lead to queue as many might also be waiting to be responded to by the physician(Ajayi, Akinrujomu, Daso, & Akinniyi, 2019).
Medical appointment can be seen as a means of patient booking and securing a particular time with the doctor either for medical checkup or for medical consulting. Online medical appointment scheduling helps to manage and effectively utilize the time spent at the health center in a way that the patient is assigned a time which is visible for both the patient and the doctor. Large waiting times at hospital outpatient clinics are a cause of dissatisfaction to patients, cause additional stress to hospital staff, increase the risk of contagion and add complications for patients with medical conditions. Reducing waiting times and surgeon idle time improves the quality of service and efficiency of a hospital (Ajayi, Akinrujomu, Daso, & Akinniyi, 2019).
Appointment booking system lies at the intersection of delivering efficient, dependable and timely access to health services. The conventional way of appointment booking is via fax, phone or email. But with the growing internet penetration, healthcare industry is moving towards the use of an online appointment booking system (Peter, Olusegun, & Oladipo, 2014).
The establishment and improvement of doctor-patient interaction system is a very important requirement, especially now when the technology is developing rapidly.
There are times when the patient misses to schedule an appointment with the doctor. This leads to delays in providing healthcare service by the practitioner. Now with a patient booking and consulting system, the patient can schedule appointments directly by logging in to the system.
1.2 Statement of the Problem
It has been observed that to receive medical treatment in most of our hospitals, the patients queue up for several hours from one unit of the hospital to another starting from obtaining a new hospital folder, or retrieving an old one before consulting a doctor, to the laboratory unit for lab test then to the pharmacy to get the prescribed drugs and so on. With the manual processes involved in handling the patient most of them waste the whole day in the hospital. Very often, patients leave their homes very early in the morning in order to be among the first group to see the doctor. Otherwise, they may end up wasting the whole day without due attention. This situation is discouraging to most patients and sometimes forces them to turn to non-professionals or even resort to self-medication for quick recovery. Therefore, there is the need to develop a patient booking and consulting system that will handle the give allow patient to book appointment online and chat with doctor at their comfort zone.
1.3 Aim and Objectives of the Project
1.3.1 Aim of this project
The aim of this project work is to design and implement a patient booking and consulting system, a system that will allow patient book appointment and consult the doctor directly.
1.3.2 Objectives
The followings are the objectives of this project
1. To study and analyze thecurrent requirements of patient booking and consulting system
2. To design and implement apatient booking and consulting system
3. To test and validate the proposed system
1.4 Significant of the Study
The study will help bridge the stress and time wasting involve in manual process of booking appointment and consultingof doctors. This study will also give the patient rest of mind, knowing that after the booking is successful, they will be able to consult the doctor to lay complain
1.5 Scope and Limitation
1.5.1 Scope of the Study
The scope of this project is todesign and implementapatient booking and consulting system, the system will enable patient to create account, loign, search for doctor, book appointment and consult the doctor.
1.5.2 Limitation of the Study
Because of time constraint this project work was unable to add video conferencing which is supposed to be part of the system. Therefore, thiswork will serve as a reference work toupcoming project for other students who will becarrying out a research on this topic to add video conferencing.
.