DESIGN AND IMPLEMENTATION OF PATIENT BOOKING AND CONSULTING SYSTEM (A CASE STUDY OF KHADIJA MEMORIAL HOSPITAL, KANO)


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.

.

DESIGN AND IMPLEMENTATION OF PATIENT BOOKING AND CONSULTING SYSTEM (A CASE STUDY OF KHADIJA MEMORIAL HOSPITAL, KANO)



TYPE IN YOUR TOPIC AND CLICK SEARCH.




TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.net is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.net" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.