Hospital Management System-out patient Detail

This Ppt gives u each n every information about out patient management system

1. Guided By:-Mr. Navin Pal
YOGIJICREATIONS
PVT. LTD.
Submitted By:-Jiten Pansara

2. 














PRESENTATIONOUTLINE
YOGIJICREATIONSPVT
LTD.

3. YOGIJICREATIONS
YogijiCreationsisaweb&graphicdesign,organizationprovidingworld-classIT
solutions.
YogijiCreationsprovidehighlycustomizedwebprogrammingsolutions,website
design,logodesign,flashdesign,websiteMaintainceandsoftwaredevelopmentof
supremequalityataffordableratesfromIndia.Ourclientsacrosstheworldareassured
ofaestheticandoriginaldesigns,fastturnaroundandpromptcustomer
support.Whetheryouownbusinessthatneedsawebsite,youcantrustYogiji
Creationstobuildwebsitethatperfectlysuitsyourbudget.YogijiCreationsisusingthe
experienceobtainedinyearsinmakingwebapplicationsasaoffersawiderangeof
servicestofulfillitsclientsbusinessneedsforthewebandnewmedia,intermsof
creatingverywelllookingwebdesignanduserfriendlywebapplicationdevelopment.
GODSPREADSLOVE,WESPREADSCREATIVITY
YOGIJICREATIONSPVT
LTD.

4. INTRODUCTION
Purpose
The software is for the automation of Out Patient Detail Management.
The Software includes:-
Maintaining Patient details.
Providing Prescription, Precautions and Diet advice.
Billing and Report generation.
Scope
It can be used in any Hospital or Dispensary for maintaining patient details and their
test results.
YOGIJICREATIONSPVT
LTD.

5. ABOUTPROJECT
OurprojectOutPatientManagementSystemincludesregistrationof
patients,storingtheirdetailsintothesystemandalsocomputerizedbilling.
Oursoftwarehasthefacilitytogiveauniqueidforeverypatientand
storesthedetailsofeverypatientandthestaffautomatically.Usercan
searchavailabilityofadoctorandthedetailsofapatientusingtheid.
TheOutPatientManagementSystemcanbeenteredusingausername
andpassword.Itisaccessibleeitherbyandoctororreceptionist.Only
theycanadddataintothedatabase.Thedatacanberetrievedeasily.The
interfaceisveryuser-friendly.Thedataarewellprotectedforpersonaluse
andmakesthedataprocessingveryfast.
YOGIJICREATIONSPVT
LTD.

6. EXISTINGSYSTEM
Existingsystemreferstothesystemthatisbeingfollowedtillnow.
Presentlyallthehospitalfunctionalitiesaredonemanually.Thatis
ifapatientwanttoconsultadoctorheneedtowaittheirtillhis
chancecalled.Thisisverydifficultprocess.
Out_Patientticketsaredistributeddirectly.Themaindisadvantage
istimeconsuming.
YOGIJICREATIONSPVT
LTD.

7. LIMITATIONSOFEXISTING
SYSTEM
Lack of security of data.
Time consuming.
Consumes large volume of paper work.
Manual work
No direct role for the higher officials.
To avoid all these limitations and make the system working more
accurately it needs to be computerized.
YOGIJICREATIONSPVT
LTD.

8. OBJECTIVESOFPROPOSED
SYSTEM
TheHospitalmanagementsystemsoftwareisuser-friendly
software.Themainobjectivesofthesystemiswhichshowsand
helpsyoutocollectmostoftheinformationaboutHospitalityand
MedicalServices.Thesystemisverysimpleindesignandto
implement.Thesystemrequiresverylowsystemresourcesand
thesystemwillworkinalmostallconfigurations.
Themainobjectivesoftheproposedsystemcanbeenumeratedas
follows:
Patientsareeasilyallocatedtothedoctors.
DoctorsSearchispossible.
Today’spatientlisthelpdoctorstosearchtheirpatients
YOGIJICREATIONSPVT
LTD.

9. Technologies to be used
This project will be a desktop application to be developed in C#.NET having
SQL-Server as backend.
Back-End(SQL-Server 2008)
Front-End(Microsoft Visual Studio 2008)
Overview
•Project is related to Hospital Management System.
•The project maintains two levels of users:-
Administrator Level-Doctor
User Level-Data Entry Operator
YOGIJICREATIONSPVT
LTD.

10. Providing billing details for patients.
Maintaining backup of data as per user requirements.
If user forgets his/her password then it can be retrieved by hint question.
User or Administrator can search a patient’s record by his/her name.
YOGIJICREATIONSPVT
LTD.

11. PROJECTREQUIREMENTS
Client side:-
1.Hardware Requirements:-
Processor : - Pentium Processor P_IV
RAM : - 256 MB and Above
Hard Disk : - 10 GB and Above
2. Software Requirements:
Operating System : - Windows xp, Vista, Seven
Database Server : - SQL server -2008
Language : - c#
YOGIJICREATIONSPVT
LTD.

12. User Characteristics:-
Every user should be:-
• Comfortable of working with computer.
• Operator should aware of medical terms.
• Operator should have basic knowledge of English too.
Benefits:-
•Easy to Operate.
•Speech Recognition is used which makes the interface user-friendly.
YOGIJICREATIONSPVT
LTD.

13. DATAFLOWDIAGRAM
Notations
Process
Data Flow
Source/Destination
Data Storage
DATAFLOWDIAGRAM
A data flow diagram(DFD) is a graphical representation of the "flow" of data through
an information system. DFDs can also be used for the visualization of data
processing (structured design).
YOGIJICREATIONSPVT
LTD.

14. Patient
Hospital
Management
System
Doctor
Receptionist
DFD: Level 0
Gives Details
Registration
Prescribes Test
Prescription
Prescription
Bill
Bill
Shows the system’s major processes, data flows, and data stores at a high
level of abstraction.
Appointment
Appointment
YOGIJICREATIONSPVT
LTD.

15. Prescription
Doctor
Receptionist
Enters
Gives Prescription
Request Prescription
Prescription_Db
DFD: Level 1.0
YOGIJICREATIONSPVT
LTD.

16. DFD: Level 2.0
Appointment
Receptionist
Save Appointment
Appointment_Db
Cancel Appointment
Message
YOGIJICREATIONSPVT
LTD.

17. Generate
Bill
Bill_Db
Receptionist
Save Appointment
Receptionist
Requesting Patient Id
Gives Bill
Gives PatientId
DFD: Level 3.0
YOGIJICREATIONSPVT
LTD.

18. Receptionist
Consultant
Doctor
Permanent
Patient
Add/Update/Dele
te Staff
Registration
Appointments
Login
Out Patient Management System
Prescription
Edit Profile
USECASEDIAGRAM
Patient
Information
Bill Details
YOGIJICREATIONSPVT
LTD.

19. SEQUENCEDIAGRAMS
A sequence diagramin Unified Modeling Language (UML) is a kind of interaction
diagram that shows how processes operate with one another and in what order.
Patient –Update Record
YOGIJICREATIONSPVT
LTD.

20. STATECHARTDIAGRAM
Diagnosis Patient
Gives Treatment
Prescribes Medicines & Gives
Diet Advice
Cures the Patient
State diagrams are used to give an abstract description of the behavior of a system.
This behavior is analyzed and represented in series of events, that could occur in one
or more possible states.
1.Doctor SCD
YOGIJICREATIONSPVT
LTD.

21. Enter Hospital
Undergo Diagnosis
Takes Treatment
Gets Cured
2. Patient SCD
Takes Appointment
YOGIJICREATIONSPVT
LTD.

22. Checks Details as Patient
Gives appointment
Gives Bill
Takes Bill Amount
2. Receptionist SCD
Checks availability of doctor
YOGIJICREATIONSPVT
LTD.

23. CLASSDIAGRAM
A class diagramin the Unified Modeling Language (UML) is a type of static structure
diagram that describes the structure of a system by showing the system's classes, their
attributes, operations(or)methods and the relationships between the classes.
YOGIJICREATIONSPVT
LTD.

24. E-R DIAGRAM
Notations
Entity
Relationship
Attribute
Identifier Attribute
A detailed, logical representation of the entities, associations and data
elements for an organization or business.
YOGIJICREATIONSPVT
LTD.

25. YOGIJICREATIONSPVT
LTD.
Patients
has
M
M
Consultant
Permanent
Doc_Patient Doctor
Treats Treats
1 M 1
Appointment
M
1
has
Prescription
1
Prescription Details has
1
M
Bill has1
1

26. DATATABLES
1. User_Info:-
Field Name Data Type Constraint
User_Id Int PK
User_Name Text
User_Pass Text
Hint_Question Text
Hint_Answer Text
User_Desi Text
YOGIJICREATIONSPVT
LTD.

27. 2.Patient_Detail Table:-
Field Name Data Type Constraint
Patient_Id Int PK
Registration_Date Date Time
Name Text
Address Text
City Text
Contact_No Bigint
Maritial_Status Text
Religion Text
Gender Text
Father_Husband_name Text
Age Int
Referred_To Text
YOGIJICREATIONSPVT
LTD.

28. Field Name Data Type Constraint
Doc_Id Int PK
First Name Text
Last Name Text
Address Text
Gender Text
Contact_No Bigint
License_No Bigint
DOB Date Time
Specialization Text
Category Text
Service_Charge Int
Picture image
3.Doctor_Details:-
YOGIJICREATIONSPVT
LTD.

29. YOGIJICREATIONSPVT
LTD.
Field Name Data Type Constraint
Prescription_Id Int PK
App_Id Int FK
Medicine_Code Bigint
Medicine_Name Text
Qty Int
Unit Int
Unit_In Text
Instructions Text
Date Date Time
5.Prescription Details:-
4.Doc_Patient Details:-
Field Name Data Type Constraint
Doctor_Id Int FK
Pateint_Id Int FK

30. YOGIJICREATIONSPVT
LTD.
Field Name Data Type Constraint
App_Id Int PK
Patient_Id Int FK
Doctor_Id Int FK
App_Date Date Time
App_Time Date Time
6.Appointment Details:-
7.Bill Details:-
Field Name Data Type Constraint
Bill_Id Int PK
App_Id Int FK
Tot_Amount Int

31. SCREEN-SHOTS
Splash Screen
YOGIJICREATIONSPVT
LTD.

32. MainMDI Form
YOGIJICREATIONSPVT
LTD.

33. MainMDI with validationForm
YOGIJICREATIONSPVT
LTD.

34. Receptionist Home Page
YOGIJICREATIONSPVT
LTD.

35. Doctor Home Page
YOGIJICREATIONSPVT
LTD.

36. Forgot Password Form
YOGIJICREATIONSPVT
LTD.

37. New_User Form
YOGIJICREATIONSPVT
LTD.

38. Patient_Registration Form
YOGIJICREATIONSPVT
LTD.

39. Patient_Registration Form
YOGIJICREATIONSPVT
LTD.

40. Change Password
YOGIJICREATIONSPVT
LTD.

41. Doctor Registration
YOGIJICREATIONSPVT
LTD.

42. Search Patient Form
YOGIJICREATIONSPVT
LTD.

43. Prescription Form
YOGIJICREATIONSPVT
LTD.

44. Edit Profile Form
YOGIJICREATIONSPVT
LTD.

45. Cancel Appointment
YOGIJICREATIONSPVT
LTD.

46. About Yogiji Creations
YOGIJICREATIONSPVT
LTD.

47. TEST-CASES
The Various test cases that were carried out
and the obtained results from the system are.
Test
No.
Description Test Data Expected
Result
Actual Result
1. Clickingthe login
Button in MDI form with
invalid username and
password.
Username=“ABC”
Password=“ABC”
A message box
shoulddisplay
which contains
invalid username
and password.
Pass
2. Clickingthe login
Button in MDI form with valid
username and password.
Username=“DocManishKhar
e”
Password=“meetmanishkhar
e”
Redirect to Doctor’s
HomePage.
Pass
TESTCASEFORLOGIN
YOGIJICREATIONSPVT
LTD.

48. Test
No.
Description Test Data Expected
Result
Actual Result
1. Clickingthe submit
Button without filling any
Details.
Username=“”
HintQuestion=“”
Hint Answer=“”
Proper error
messages should
display.
Pass
2. Clicking the submit Button
with filling correct details.
Username=“ResPratikMukte
”
HintQuestion=“Who is your
idol?”
Hint Answer=“Adnan Sami”
Passwordshould
be shown.
Pass
TESTCASEFORNEW
USER
TESTCASEFORFORGOT
PASSWORD
Test
No.
Description Test Data Expected
Result
Actual Result
1. On form load message
should be given using
Speech Recognition.
- Userid increments
automatically,there
is no need to insert
user id.
Pass
2. Delete button should be
disableuntil you select User
Id
- Disable Delete
Button
Pass
3. Clicking the submit button
Withoutentering any data.
User name=“”
Password=“”
Designation=“”
Hint Question=“”
Hint Answer=“”
Propermessages
should be shown for
mandatory fields.
Pass
YOGIJICREATIONSPVT
LTD.

49. The project Hospital Management System (HMS) is for computerizing the working in a
hospital. The software takes care of all the requirements of an average hospital and is capable
to provide easy and effective storage of information related to patients that come up to the
hospital.
It generates bill reports, prescription reports; provide prescription details diet advice, and
medicines prescribed to patient. It also provides billing facility.
The system also provides the facility of backup as per the requirement.
CONCLUSION
YOGIJICREATIONSPVT
LTD.

50. Thank you.
God Bless you.
YOGIJICREATIONSPVT
LTD.