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

CHAPTER 1

INTRODUCTION

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: