DESIGN AND DEVELOPMENT OF AN ONLINE DOCTOR APPOINTMENT SYSTEM
ABSTRACT
Online Doctor appointment System in hospital today necessitate a competent administration when handling patients, generating reports for cashier, patient details which serves as a key factor for the flow of business transactions in Farazy Hospital Ltd. Unfortunately the current Record Management System Leads to misplacement of during details, Patient details and doctor record of reports and insecurity to records. This research project is aimed at computerizing all the records about Patients, Hospital and Doctors. In order to achieve this goal, a through System Study and investigation was carried out and data was collected and analyzed about the current system using document and data flow diagrams. The concept of report production has been computerized hence, no more delay in report generation to the Hospital, Patient and Doctors. Errors made on hand held calculators and dealt out completely. The method used to develop the system include iterative water full model approach, dataflow, logical and entity relationship diagram where used to design the system and finally the language used SQL Server 2008, C# & ASP.Net.
TABLE OF CONTENTS
DECLARATIN …………….........................................................................................................................ii
DEDICATION ……………………………………………………………….……………………………iii
ACKNOWLEDGEMENT…………………………………………………………………………………iv
TABLE OF CONTENTS………………………………………………………………….………………..v
LIST OF TABLE……………………………………………………………………….………….………vi
LIST OF FIGURES……………………………………………………………………….………………vii
ABUSTRACT……………………………………………………………………………..……….……….x
LIST OF ABBREVIATION…………………………………………………………….....……………..xi
DEFINATION OF OPERATIONAL TERMS………………….………………………………………..xii
CHAPTER 1 INTRODUCTION…………………………………..…………………………....………..1
1.0 Introduction …………………………………………….……..…..……………………………………1
1.2 Objectives ………………………………………………..…..…………………………………………2
1.3 Justification of study Objectives ………………..………………… ………..…………………………3
1.4 Scope of Study …………………………………………………………………..…………………..4
CHAPTER 2 LITERATURE REVIEW……………………………..………………………………….5
2.1 Waiting Time………………………………………………………….……………………………..6
2.2 Patients’ Appointment System………………………………………………………………………7
2.2.1 Appointment Delay…………………………………………….………………………………….8
2.2.2 Managing Patients’ Appointment system………………………………………………………….9
2.3 Online Booking System………………………………………….…………………………………..9
2.4 Existing Hospital Appointment Schemes………………………..………………………………….10
CHAPTER 3 METHODOLOGY …………………………………..…………………………………..11
3.0 Methodology………………………………………………………………………………………….12
3.2 Justification of Methodology…………………………………………….………………………..13
3.3 Description of Methodology………………………………………..……………………………13
CHAPTER 4 ANALYSIS, DESIGN AND DEEVELOPMENT……………………………………14
4.0. Introduction……………………………………………………………...…………………………14
4.1 System Study…………………………………………………………..…………………………….14
4.2 System Analysis……………………………………………………..……………………………..14 4.2.1 Existing Online Doctor Appointment Systems………………..…………………………………14
4.2.2 Requirements Specifications…………………………………..………………………………….15
4.2.3 User Requirement…………………………………………….…………………………………..15
4.2.4 Functional and Non Functional Requirements………………….……………………………....15
4.2.5 System Requirement……………………………………………….……………………………..15
4.3. System Design………………………………………………..………..…………………………..16
4.1.3 Logical Model……………………………………………………………………………………..17
4.3.2 System Architecture………………………………………………..……………………………17
4.3.3 Entity Relationship Diagram………………………………………….…………………………17
4.3.4 Data Flow Diagram……………………………………………………………………………….18
4.4 Database Diagram…………………………………………………………………………………19
4.5 System Development…………………………………………………....………………………….20
4.5.1 Introducing Visual Studio .NET 2008……………………………….………………………….21
4.5.2 Introduction to the C# Language………………………………………………………………..22
4.5.3 Introduction to ASP.NET …………………………………………………………………………………..22
4.5.4 Introduction to SQL Server Management Studio………………………………………………….22
CHAPTER 5 RESULT……………………………………………….…………………………………23
5.5.1 System Interfaces…………………………………………..…………………………………….23
5.5.2 Login Form for the Different Users…………………….……………………………………….23
5.5.3 System Administration Home Page…………………….………………………………………..24
5.5.4 Patient Appointment Home Page……………………..…………………………………………..25
5.5.5 Doctor Registration Page…………………………………….……………….……………………………….26
CHAPTER 6 CONCLUSION………………………….……………………………………………….27
6.0 Introduction……………………………………..…………………………………………………27
6.1 Summary…………………………………………...…………………………………………………28
6.2 Limitations…………………………………………..……………………………………………………….28
6.3 Conclusions……………………………………………………………………………………………………28
6.4 Recommendations……………………………………………………….…………………………………29
REFERENCES………………………………………………………………….………………………30
CHAPTER 7 APPENDIX I………………………………………………….………………………. 31
APPENDIX II The Organizational Structure……………………………………………………………32
APPENDIX III Source Code of the System……………………………………………………………..33
LIST OF TABLES
Table: 4.0 Hardware Requirement………………………………………………………………………20
Table: 4.1 Software Requirements…………………………………………..……………………………20
LIST OF FIGURES
Fig: 3.0 Methodology…………………………………………………………………………………......23
Fig: 4.1.3 Logical Model………………………………………………………………………………..24
Fig: 4.3.2 System Architecture…………………………………………………..……………………..25
Fig: 4.3.3 Entity Relationship Diagram………………………………………………………………….26
Fig: 4.3.4 Data Flow Diagram…………………………………………………………………………….27
Fig: 4.4 Database Diagram…………………………………………………………………………….28
Fig: 4.5.1 Introducing Visual Studio .NET 2008………………………………………………………28
Fig: 4.5.2 Introduction to the C # Language…………………………………………………….…....29
Fig: 4.5.4 Connect to Server……………………………………………………………..…..…………30
Fig: 4.5.4 Query Interface………………………………………………………………………..…….31
LIST OF ABBREVIATIONS
Terminology Meaning
ODAS Online Doctor Appointment System
ERD Entity Relationship Diagram
DBD Database Diagram
DFD Data Flow Diagram
IT Information Technology
C# C Sharp
ASP Active Server Page
HTTP Hyper Text Transfer Protocol
SQL Structure Query Language
DBMS Database Management System
GUI Graphical User Interface
IDE Integrated Development Environment
CHAPTER 1
INTRODUCTION
1.0 Introduction
Aim of this project is to create doctor patient handling management system that will help doctors in their work and will also help patients to book doctor appointments and view medical progress. The system allows doctors to manage their booking slots online. Patients are allowed to book empty slots online and those slots are reserved in their name. The system manages the appointment data for multiple doctors of various date and times. Each time a user visits a doctor his/her medical entry is stored in the database by doctor. Next time a user logs in he may view his/her entire medical history as and when needed. At the same time a doctor may view patient’s previews medical history while the patient visits him. The system also consists of Blood donor module. This module allows for Blood donation registration as well as Blood group search. The module is designed to help urgent Blood requirements through easy/instant searches.
1.2 Objectives
⦁ To Create Web based online Doctor Appointment management system.
⦁ To manage all patients related information.
⦁ To provide emergency information in critical situation.
1.3 Justification of study
We implement this system for better user experience. This system is very easy to access. Also for establish real time communication, using modern and updated technology. So, user can see the update without reload or refresh. This system will compatible with user device such as pc, laptop, tab & smart phone. So user can easily access the system anytime anywhere. This system is very simple & user friendly so, any user can use this system easily.
1.4 Scope of Study
Scope of the project is very broad in terms of other online doctor appointment portal.
Few of them are:
⦁ Patient and doctor get SMS from the system.
⦁ There is huge collection of doctor information.
⦁ Anyone can get Blood on time.
CHAPTER 6
CONCLUSION
6.0 Introduction
This Chapter describes discuss the objectives of the system stipulated in earlier chapters, limitation of the system conclusion and recommendation of the System.
6.1 Summary
As discussed in the previous chapters the main problem that we addressed was dealing with patient, doctor and hospital document. It is the above situation that above us to techniques of developing this Online Doctor Appointment System to be used the Patient, Doctor and Hospital to enable them to handle details on policies efficiently and effectively. The Project has implemented most of the objectives stipulated in earlier chapter. The Online Doctor Appointment System offers a number of benefits to the user and can capture data, store, view, add and delete the records entered the data cal also be posted information to the database.
Problems Encountered during Data Collection: sensitive information released to us, few projects and books written about Online Doctor Appointment System.
Problem Encountered during System Design: Limited time to finish up to work, but we are finally finished to our system design the projects.
6.2 Limitations:
This section describes those services that are not provided by the system and those included the following. It is always connect to the Internet connection. It Support to Microsoft Windows Platform and not support to others platform as like MAC or Linux.
6.3 Conclusions
The core reason for the establishment of computerizing Online Doctor Appointment System is to enable the hospital administrators in a convenient, fair and timely manner. Therefore the IT used should support the core objective of the system if it is to remain relevant to the hospital. A lot still needs to be done in the IT department in order to make available technology effective. This may involve training of the hospital staffs on how to enter data in the right and relevant data in the system and the management to keep updating the hardware and software requirements of the system. IT and computer systems need to be kept being upgraded as more and more IT facilities software are introduced in to days IT market. The researcher acknowledges the fact this system does not handle all patient doctor and hospital. The researcher therefore suggests that for further research, the following can be researched on. The most cost effective way of handling all Hospital Patient management system process.
6.4 Recommendations
Thanking of all the members of hospital staff in the hospital to get accustomed to the system will be a priority. This being a new system the computerized Online Doctor Appointment System will replace their jobs.
.