1 of 186

Hello Everyone !!!

HOSPITAL MANAGEMENT SYSTEM (H.M.S.)

Presentation

2 of 186

The Research Work And Written Stuff Done By the :-

  • Mihir
  • Dona
  • Animesh
  • Rahul
  • Shubham
  • Shreeju
  • Akshay
  • Chandrasai
  • Anusaranya
  • Aromal
  • Amirthavarshini

​

2

3 of 186

OBJECTIVES

  • This system provides the idea to the management about present condition and also supports management decision making system.
  • The objective of our system is to eliminate the chances of error that will occur in manually handling the system.
  • This system will minimize the paper work and reduces the work time and complexity of the user.
  • By using this system the data will be stored in organized manner.

​

3

4 of 186

Advantages

  • The system automates the manual procedure of managing hospital activities. Doctors can view their patients’ treatment records and details easily.
  • With the help of this system admin can easily see bed availability and immediately allot it whenever any patient arrives without manually looking for bed availability.
  • It even generates an instant bill thus eliminates the need of maintaining paper records for patient stay for each day.
  • Requires large database.
  • The admin has to manually keep updating the information by entering the details in the system.

4

Disadvantages

5 of 186

NEED FOR PROPOSED SYSTEM

  • Previously the management work was done manually.
  • It was a tedious job and also time consuming.
  • Therefore it was need to develop a computerized system which will reduce the job complexity, improve efficiency and should be economically feasible

1

6 of 186

GOALS

  • To increase the effectiveness of the management.
  • Generation of the report should be easy, up to date and flawless.
  • Reduce human errors and easy maintenance of the database.

​

7 of 186

StakeHolders Discused

  • Doctors/Lab experts
  • Medical / Non-Medical Staff
  • HR
  • Receptionist
  • Insurance Agent/ company
  • Finance Management
  • Inventory Management
  • Pharmacist
  • Patients/Visitors

​

7

  • Organ / Blood Bank
  • Interns
  • PR A.K.A Public Relation
  • Board Of Directors
  • External Organisation
  • Admin
  • Maintenance /Disaster Staff
  • Food Service

​

8 of 186

Doctors / labs

DOCTORS:-

  • SCHEDULING { There will be main doctor who will have keep schedule of other doctors / assistants }
  • ADDING NEW DOCTORS {There will be a section opened when there is hiring of new doctors}
  • DOCTORS WHICH ARE PRESENT WILL HAVE ACCESS TO PATIENT INFORMATION
  • DOCTORS CAN EDIT THOSE DETAILS OR ADD NEW DETAILS

​

LABS :-

  • SIMILAR POINTS AS OF DOCTORS
  • EXCEPT THEY DON’T GET ACCESS TO PATIENTS DETAILS
  • BUT THEY WILL BE HAVING SEPARATE LIST OF TEST EQUIPMENTS AND ALSO EDIT THOSE LIST

​

8

9 of 186

Medical Staff

  • Enter or Edit personal details

They can enter or edit their details that they provide to the hospital management.

  • Edit patient medical details

They can edit the medical status of the patients including the basic checkups that are done in timely basis.

  • Drug Management

They have to maintain the records of drugs used for the patients.

​

9

Nurse

Enter or Edit personal details

Edit patient medical details

Drug Management

10 of 186

Non-Medical Staff

  • Staff Details

Can Enter or Edit staff details .

  • Duty Allotment

Each staff member will be allotted with different duties

  • Daily Work Records

They have to maintain the records of daily work done.

10

Sanitary-Department

Staff Details

Duty Allotment

Daily Work Records

11 of 186

HR

  • A Hospital is a microcosmic community that operates like a small city, presenting the same issues with a stronger dynamic due to the human interaction factor.
  • HR Management plays a vital role in the Health car workplace in ensuring the delivery of health care services and facilitating optimal patient outcomes.

Examples of specific HR Management Functions Include:

​

  • Hiring
  • Physician and Nurse Recruitment
  • Employee orientation
  • Training and performance monitoring
  • Counselling
  • Claims Handling etc etc.

11

12 of 186

Receptionist

  • Creating Records And Updating Bills Of All Patients.
  • To Check the Availability Of Doctors And Other Staffs.
  • Transferring calls, Handling queries and complaints via phone, mail, etc.
  • Scheduling appointments and room availabilities for patients.
  • Assist in ordering, receiving and stocking of office supplies

12

13 of 186

Insurance Agent/ company�

  • Insurance module can record patients insurance details.
  • It includes the policy number,the insurance comapany,information about their policies.
  • Integration with heath insurances services improves the experiences of the patient and brings benefits to the institution.
  • It helps both the patient and hospital to handle many aspects of the insurance process successfully.

​

13

14 of 186

Finance Management

  • Financial managers evaluate the organizations’ effectiveness and overall financial health
  • When a Hospital has strong and organized financial management plans, they're able to provide efficient healthcare to all their patients.
  • The management has the ability to monitor different financial operations including expenses, profits, and losses, paying bills and taxes, in and outpatient billing.
  • The financial awareness helps to analyze business prospects quite clear and move in the right direction.

14

15 of 186

Inventory Management

  • Inventory Management has a vital role in the Healthcare Industry, especially when people’s lives are at stake.
  • The Inventory Management Software lets you know the detail information on medicines batches & stock. It is also very useful in maintaining the doctor’s equipment. 
  • With the help of software, any hospital or medical store can keep precise and updated stock records.
  • Especially for pharmaceuticals and surgical equipment. It is one of the most significant jobs for any hospital organization.
  • When it keeps tracking your assets efficiently then there is no fear of theft and stolen assets It also informs you about the condition of the surgical equipment for its maintenance.  

15

16 of 186

Pharmacist:�

  • Checks availability of medicines
  • checking expires of medicines
  • keeping medicine supplier information
  • ensuring that the medicines prescribed to patients are suitable
  • advising patients about medicines
  • ensuring that the supply of medicines is within the law

16

17 of 186

Patients/Visitors

  • The new users should complete his Registration. Username and password will be assigned.
  • Patient can requests or reserve his appointment in prior.
  • Patient can access and maintain personal Health Records.
  • Patient can view different test charges in prior or in advance.
  • Reports can be viewed online.
  • Visitor's are allowed to visit the patient.
  • Visitor's need to observe the visiting time for the area they are visiting.

17

18 of 186

Board Of Directors /CEO

  • Ensuring a formal and transparent nomination process for directors.
  • Monitoring the effectiveness of the governance practices under which the company operates and propose changes where needed
  • Monitoring the implementation and overall development of the corporate business strategy and corporate performance
  • Ensuring the integrity of the company’s accounting and financial reporting systems, including the independent audit.
  • Ensuring that appropriate systems of internal control are in place, in particular, systems for monitoring risk, financial and accounting control, and compliance with laws and regulation.

​

​

18

19 of 186

PR A.K.A Public Relation

  • Manages NUMBER OF COMPLAINTS RECEIVED - Less the number of complaints received , better is the Public Relations.
  • Patient Satisfaction Survey - A survey questionnaire with options is provide to the patients.
  • Manages Media Relations: Working with mass media in seeking publicity or responding to their interests in the hospital.
  • Publicity: Disseminating planned messages through selected media to sponsor the hospital

19

20 of 186

Organ ,Blood Donation Bank

  • Blood bank is an institute from where blood is, stored entirely or as its components (plasma, blood cells and platelets) which is then transfused to the needy patients suffering with deficiency of blood or blood components.
  • Organ Banks are banks which recover, process, storage and distributing an organ as well as body tissue and bone for transplantation.

​

20

21 of 186

External Organisation

  • Government
  • NGOs
  • Health Inspectors From WHO

21

22 of 186

Interns

  • They can access the database which are categorized By disease (not by patients' profile)
  • These Database Helps them to educate themselves by reviewing clinical cases of a given disease, also can use for referencing a patients case with similar cases.
  • Have Access To Patients Records.
  • Can View their remarks given by the doctors they are under supervision.

22

23 of 186

Admin

  • Managing the client care/patient care experience
  • Managing health informatics, including recordkeeping
  • Overseeing the financial health of the department or organization
  • Managing human capital, including policies for hiring, performance reviews, staff schedules, etc.

​

23

24 of 186

Project Timeline

  • Planning => 10 Days
  • Analysis => 15 Days
  • UI / UX Design => 25 Days
  • Coding => 90 Days
  • Testing => 25 Days
  • Implementation => 15 Days
  • Total Days => 180 Days i.e. 6 Months

​

24

25 of 186

25

Grey bar shows actual timing

26 of 186

Modules and Units

27 of 186

Registration Module:

  1. Allows the employee to register only if the employee no /Registration no. is valid(All employees and external organization)
  2. User sets username and password.
  3. Set security key.
  4. Validation of all credentials
  5. User will be added to the database.

28 of 186

Login Module

  1. User can login using the registered username and password.
  2. Validation of the credentials.
  3. If the user enters invalid username or password more than a defined number of times simultaneously then that account will be locked .
  4. The account can be unlocked only by the admin
  5. Automatic expiring of user passwords in specific time intervals.
  6. Change of password can be performed by the user with security key.

29 of 186

Appointment module:

  1. Description
  2. Appointment
  3. Appointment fields
  4. Appointment status
  5. Creating and Updating appointments
  6. Scheduled reminders
  7. OSGI Service API(if needed)Configuration

30 of 186

Profile Module:

  1. Details about person(I'd proof)
  2. Registration of patient and doctors
  3. Records of patients and doctors
  4. Updating profile
  5. Altering Personal info.

31 of 186

Pharmacy Management Module:

  1. Ordering Medicines
  2. Checking if the product is safe
  3. Notifying before Expiry date
  4. Locking all medicine if they are expired
  5. Disposing waste

32 of 186

Salary module:

  1. Notification for Salary date
  2. Providing Salary on date through transferring money in their account
  3. Decrementing Salary in case of Fine
  4. Incrementing salary as bonus
  5. Rewarding employee
  6. Cancelling transaction

​

​

​

33 of 186

External Source Management Module:

1)Registration for Guest Users and External Organizations

2)View Doctors and Patients Details

3)Rating and Feedback Unit

4)Show Providing Services Unit

5)Donation Unit

34 of 186

Canteen Module

​

  1. Checks the availability of food item
  2. Refilling the stock
  3. Prepare menu
  4. Take orders
  5. Cancel order
  6. Giving Fine
  7. Bill payment

​

35 of 186

Loan Module:

  1. Loan payment
  2. Long term or short term loan
  3. Penalty
  4. Check Balance

36 of 186

Insurance module:

  1. Insurance cancellation
  2. Insurance expired
  3. Insurance details / information
  4. Automatic reminders

37 of 186

Hospital services Module:

1)login

2)Check doctor availability

3)Allotting the room for emergency patient

4)maintaining record of patient

5)Ward bed availability

6)view personal detail(staff)

7) Ambulance service

8) Ward Cleanliness

9)Stock refill

10) Query/FAQ section

​

​

38 of 186

Report Management Module�

1)Maintaining records (Medical staff, database, admin,Receptionist,)

2)To check daily records of patients (medical, database, Receptionist)

3)View medical reports of patients(Doctors)

4)View old records of patients(Interns, External Organization)

5)Sending reports to patients via apps(Patient, Doctors)

6)View Doctor records(External Organization)

7)Add, update and retrieval of reports(Lab expert)

​

39 of 186

On demand/Request Modules�

1)Check details of extra services provided (Medical staff)

2) Availability of rooms(Medical staff)

3)Booking Medicines from Inventory management (Medical staff)

4)Order Stocks, order confirmation(Caterer, DB, Dealer)

5)Providing Insurance, money(Finance company)

6) Contacting healthcare providers for medication related issues(Pharmacist/Super User)

7)Checks availability of medicines(Pharmacist)

8)Lookout for suitable blood/organ donors(Blood/organ donation)

9)Serving the staff needs(HR)

10)Order/request medicines through app(patients)

​

40 of 186

HOSPITAL ARRANGEMENT MODULE:�

1) Placing meetings

2) Organizing events

3) Placing medical camps

4) Arranging appointment with other companies

5) Handling resources of hospital

41 of 186

SECURITY MANAGEMENT MODULE:�

1) The Information Security

2) System Vulnerability and Abuse

3) Security Threats (Malicious Software, Hacking etc.) and counter measure.

4) Definition of Cyber Crime and Types.

5) Antivirus

6) Firewalls

7) Anti-Spyware

8) Security Audit

9) Discussion on Overview of IT-ACT 2000.

42 of 186

Feedback Management Module:

  1. Feedback on Doctor Service (Patient, External Organization)
  2. Hospital Feedback form (Patient, Visitor, External Organization)
  3. Rating on hospital services (5 stars) (Everyone)
  4. Rating on Software Quality (5 stars) (All app users)
  5. View Submitted Feedback form (Admin, Doctor, staff)
  6. External Survey (Everyone)

43 of 186

Operation Module:

  1. View Patient Report
  2. Patient Medical history(Doctor, Nurse)
  3. Book Appointment(Patient, Doctor)
  4. Check Availability of Room and Doctor (Receptionist, Nurse)
  5. Check Operation Equipment (medical staff)
  6. Check Blood availability (Nurse, medical staff)
  7. Virtual reality (Doctor)
  8. Online meet for external surgeon (Doctor)
  9. Update on Doctor profile
  10. Update on Patient profile(Doctor)
  11. Medicines Prescription (Doctor, Nurse, patient, Pharmacy)

44 of 186

Equipment Management Module:

  1. Equipment Details (Maintenance staff, Equipment Dealers)
  2. Reminder for Routine Checkup of device (Maintenance staff)
  3. Request for Equipment Repairs (Maintenance staff)
  4. Paying for Equipment (Finance staff)
  5. Update new Equipment in market (Inventory staff)
  6. Payment History (Finance staff, Maintenance staff, Equipment Dealer)

​

​

45 of 186

Bill Module

  1. Patient bill
  2. Insurance/Mediclaim
  3. Pharma bill
  4. Exchange of records on time with reception
  5. NGO
  6. Social service by hospital (free surgery / medical camps)
  7. On time exchange of information with admin and finance
  8. Sponsorship
  9. Instalment
  10. Concession

46 of 186

Research Module:

  1. Drug research and development
  2. Getting license
  3. Proper measure during extraordinary occurrences
  4. Passing out information
  5. Vaccine research and development
  6. Updating records
  7. Alerting World

47 of 186

Waste Management Module

  1. Waste identification using color code
  2. Separation of waste
  3. Waste treatment and disposal
  4. Details of the waste (nurse, pharmacy)
  5. Idea about Waste minimization
  6. Supervision and monitoring on waste management

​

​

​

​

​

48 of 186

Management Module:

  1. Allocation of Doctors to patient(receptionist)
  2. Allocation of Date and Time of Surgery (Doctor, Receptionist)
  3. Managing Time Table (Admin, hr)
  4. Maintaining Employees Attendance (Admin)
  5. Providing Rules and Regulation (Admin)
  6. To check if the rules are followed properly (Admin)
  7. To manage Events in the hospital (Pr, Admin)
  8. To manage old details of hospital
  9. To manage old patients record
  10. To bring back the hospital to same position after any disaster happened

​

49 of 186

Campaign Module:

1)Participation in Campaign Unit

2)Internship and Trainings Unit

3)Ongoing Campaigns Unit

4)Completed Campaigns with Feedbacks and Ratings Unit

5)Scheduled Campaigns Unit

50 of 186

Modules

51 of 186

Modules for Doctor

  1. Login
  2. Appointment
  3. Diet Prescription
  4. Med prescription
  5. Salary
  6. Personal info
  7. View patient details
  8. View medical reports

​

52 of 186

Modules for Patients

  1. Registration
  2. Bill payment
  3. Appointment cancellations
  4. Receiving Medical test Reports
  5. Feedback
  6. Apply for insurance

​

53 of 186

Modules for Receptionist

  1. Login
  2. Salary
  3. Registration
  4. Reports
  5. Confirming appointment
  6. Medicines

​

54 of 186

Modules for Medical staff

  1. Login
  2. Patients Details
  3. Update/Track the health of the patients
  4. Sending the patients details to the doctor
  5. Giving the Feedback of the patients to the doctor
  6. View the salary

​

55 of 186

Modules for Non-Medical staff

  1. Log in
  2. Salary
  3. Updates Medical equipment
  4. Stock

​

56 of 186

Modules for HR

1) Performance management

2) Leave management

3)Salary, loan management

4) Recruitment

5)Administration

6) Project tracking

​

57 of 186

Modules for Blood/Organ donation

1) Physical examination

2)Donor/organ registration

3)Validation

4) Monitoring

​

58 of 186

Modules for Food service

1. Login

2. Personal info

3.salary

4.view patient diet prescription

5.stock

6.purchase

7.Menu

​

59 of 186

Modules for Lab Expert

1.Login

2.Personal info

3.Salary

4.View patient details

5.Add medical reports

6.View test prescription

7.Appointment

​

60 of 186

Modules for Public Relation

  1. Community relations
  2. Employee relations
  3. Public affairs
  4. Manages social media
  5. Crisis management

​

61 of 186

Modules for External Organization

1. Login

2. View Patients details

3. Feedback on Progress of health care

4. View Doctors details

5. Remark on Doctor

6. Rating services

7. Providing services

​

62 of 186

Modules for Finance Manager

1. View Patients Bill details

2. Patients Bill payment

3. Concession in Bill

4. Contact with bank

​

63 of 186

Modules for BOD

1.Login

2.Modification of records

3.Arranging meetings

4.Payment

5.Opportunities for new talent

​

64 of 186

Modules for Public Relation

  1. Community relations
  2. Employee relations
  3. Public affairs
  4. Manages social media
  5. Crisis management

​

65 of 186

Modules for Disaster Management

1. login

2. drill records

3. hospital insurance records

​

66 of 186

Databases

67 of 186

Report Management

NAME

DATATYPE

NULL/NOT NULL

KEY

P_id

VARCHAR(5)

NOT NULL

PRIMARY KEY

Name

VARCHAR2(30)

NOT NULL

 

Phone no

INT(10)

NOT NULL

 

Medicine

VARCHAR (20)

NULL

 

Staff_id

VARCHAR(10)

NOT NULL

 

Disease, symptoms

VARCHAR(30)

NOT NULL

 

Age

VARCHAR(2)

NOT NULL

 

Important_detail

VARCHAR(50)

NULL

​

JoinOnDate

Datetime

NULL

 

DischargeDate

Datetime

NULL

 

68 of 186

On Demand/Request

NAME

DATATYPE

NULL/NOT NULL

KEY

Demand_id

INT

NOT NULL

PRIMARY KEY

Demand_to

VARCHAR (20)

NOT NULL

 

Demand_from

VARCHAR(20)

NOT NULL

 

Demand _price

INT

NOT NULL

 

Stock_name

VARCHAR(20)

NOT NULL

 

Quantity

INT

NOT NULL

 

Expiry_date

DATE

NOT NULL

 

Company_name

VARCHAR(20)

NOT NULL

 

Phone_no

INT(10)

NOT NULL

 

Location-id

INT(10)

NOT NULL

PRIMARY KEY

69 of 186

Registration : Patient

Field

Data Type

Null/Not Null

Key

User ID

VARCHAR2(20)

NOT NULL

Primary Key

Password

VARCHAR2(20)

​

NOT NULL

​

​

Patient Name

VARCHAR2(25)

​

NOT NULL

​

​

Contact Address

VARCHAR2(40)

​

NOT NULL

​

​

Contact No

VARCHAR2(20)

​

NOT NULL

​

​

Aadhar No

VARCHAR2(20)

​

NOT NULL

​

Unique

70 of 186

Field

Data Type

Null/Not Null

Key

Age

INT(2)

NOT NULL

​

Blood Group

VARCHAR2(5)

NOT NULL

​

Gender

Enum

NOT NULL

​

maritual_status

Enum

Not Null

​

DOB

DATE

NOT NULL

​

Insurance No

VARCHAR2(30)

NOT NULL

Unique

71 of 186

Employee

Field

Data Type

Null/Not Null

Key

Employee ID

VARCHAR2(20)

NOT NULL

Primary Key

Password

VARCHAR2(20)

NOT NULL

​

Name

VARCHAR2(25)

NOT NULL

​

Contact Address

VARCHAR2(40)

NOT NULL

​

Contact No

VARCHAR2(20)

NOT NULL

​

Aadhar No

VARCHAR2(20)

NOT NULL

Unique

Age

INT(2)

NOT NULL

​

Blood Group

Enum

NOT NULL

​

Gender

Enum

NOT NULL

​

DOB

DATE

NOT NULL

​

Department

VARCHAR2(30)

NOT NULL

​

Specialization

VARCHAR2(30)

NOT NULL

​

72 of 186

External Organization

Field

Data Type

Null/Not Null

Key

Registration ID

VARCHAR2(20)

NOT NULL

Primary Key

Password

VARCHAR2(20)

NOT NULL

​

Organization Name

VARCHAR2(25)

NOT NULL

​

Contact Address

VARCHAR2(40)

NOT NULL

​

Contact No

VARCHAR2(20)

NOT NULL

​

73 of 186

Salary:

74 of 186

Pharmacy

75 of 186

External source:

NAME

DATATYPE

NULL/NOT NULL

KEY

Name

Varchar2(30)

Not Null

 

Phone Number

Int(10)

Not Null

 

Adhaar No.

Int(10)

Not Null

Primary Key

Email

Varchar2(30)

Not Null

 

Organisation Name

Varchar2(30)

Null

 

Donation

Enum

Not Null

​

Login ID

Int(10)

Null

Primary Key

76 of 186

Donation Unit:

NAME

DATATYPE

NULL/NOT NULL

KEY

Login ID

Int(10)

Not Null

Primary Key

Donation Amount

Int(10)

Null

 

Donation_Item

Varchar2(30)

Null

​

Adhaar No.

Int(10)

Not Null

 

Email

Varchar2(30)

Not Null

 

Organisation Name

Varchar2(30)

Null

 

Bank Name

Varchar2(30)

Not Null

 

Account No

Int(15)

Not Null

 

77 of 186

Campaign:

NAME

DATATYPE

NULL/NOT NULL

KEY

Name

Varchar2(30)

Not Null

 

Phone Number

Int(10)

Not Null

 

Adhaar No.

Int(10)

Not Null

 

Email

Varchar2(30)

Not Null

 

Login ID

Int(10)

Not Null

Primary Key

Campaign ID

Int(10)

Not Null

 

78 of 186

Loan Management:

Field

Type

Attribute

Null

Default

Id

Int(9)

 

No

none

Loan_amt

Int(9)

 

No

none

Loan_period

Varchar(50)

 

No

 

Loan_owner

Varchar(150)

 

No

none

Pay_back_amt

Int(9)

 

No

0

Loan_date

Date

 

No

none

Paid_amt

Int(9)

 

No

none

Approved_status

Varchar(20)

 

No

Pending

Client_status

Varchar(90)

 

No

 

Paid_status

Int(5)

 

No

none

79 of 186

Equipment

Field

Data Type

Null/ Not Null

Key

Staff_ID

Varchar2(10)

Not null

​

Staff_fname

Varchar2(100)

Not Null

​

Staff_lname

Varchar2(100)

Not null

​

Phone_no

Number

Not Null

​

Ward_no

Varchar2(20)

Not Null

​

Date

Date

Not Null

​

Equipment_id

Varchar(20)

Not Null

Primary key

Equipment_name

Varchar2(50)

Not Null

​

Quality

Enum

Not Null

​

Durability

Varchar2(50)

Not Null

​

80 of 186

Equipment

Status

Enum

Not null

​

Available_date

Date

Null

​

Best_till

Date

Not null

​

Reason

Varchar2(100)

null

​

Comment

Varchar2(100)

Null

​

81 of 186

Feedback/Rating

NAME

DATATYPE

NULL/NOT NULL

KEY

Login ID

Int(10)

Not Null

Primary Key

Feedback

Varchar2(100)

Not Null

 

Ratings

Int(10)

Not Null

 

Email

Varchar2(30)

Not Null

 

Organisation Name

Varchar2(30)

Null

 

Role

Enum

Not Null

​

82 of 186

Hospital Arrangement

Field

Datatype

Null/Not Null

Key

Meeting_no

number

Not null

Primary Key

Meeting_room

Varchar2(5)

Not null

​

Organizar_name

Varchar2(50)

Not null

​

Organization_name

Varchar2(50)

Not null

​

Members

​

Varchar2(50)

Not null

​

No_of_Present

Number

Not null

​

External_guests

Varchar2(50)

Not null

​

83 of 186

Security Management:

Field

Datatype

Null/Not Null

Key

Cam_Id

number

Not null

Primary Key

Cam_no

number

Not null

​

Security_name

Varchar2(50)

Not null

​

Date&Time

​

Timestamp

Not null

​

Description

Varchar2(100)

null

​

Confirm_gaurd_name

Varchar2(50)

Not null

​

84 of 186

Operation Management Module

Field

Data Type

Null/ Not Null

key

Patient_ID

Varchar2(20)

Not Null

​

Patient_Appointment _No

Int

Not Null

​

Patient_FName

Varchar2(50)

Not Null

​

Patient_LName

Varchar2(50)

Not Null

 

Patient_Email

Varchar2(50)

Null

​

Alternative_Email

Varchar2(50)

Null

​

Surgeon_Name

Varchar2(50)

Not Null

​

Surgeon_Id

Varchar2(20)

Not Null

​

Guardian_Name

Varchar2(20)

Null

​

Center

Varchar(20)

Not Null

​

Patient_Phone_no

Int

Not Null

​

Guardian_Phone

Int

Null

​

Patient_DOB

Date

Not Null

​

Age

Int

Not Null

​

Gender

Enum

Not Null

​

Weight

number

Not Null

​

Height

Number

Not Null

​

85 of 186

Operation Management

Blood Group

Enum

Not Null

​

Operation_Date_Time

Date and Time

Not Null

​

Operation_Duration

Time

Not Null

​

Surgery_name

Varchar2(30)

Null

 

Symptoms_B_O

Varchar2(100)

Null

 

Symptoms_W_O

Varchar2(100)

Null

 

Symptoms_A_O

Varchar2(100)

Null

 

Surgery_Status

Varchar2(100)

Not Null

 

Prescription

Va[rcahr2(100)

E

 

Scan_of_xyz

Blob

Null

 

Comments

Varchar2(100)

Null

 

Surgery_Video

bLOB

Null

 

Guardian_Signature

Blob

Not Null

 

Surgeon_Signature

Blob

Not Null

 

86 of 186

Forms

87 of 186

Click Here to view Forms��https://docs.google.com/spreadsheets/d/1Slv0nrdJgOmjSIpdpvXI-3QkJlY0vecjxd8NJwm2fj0/edit?usp=sharing

88 of 186

Report Form

88

89 of 186

Event Table

90 of 186

Board Of directors

90

Event

Activity

Source

Trigger

Response

Destination

Login

Login as bod

bod/ceo

validate/invalid

Login successfully, �invalid credentials/details

bod/ceo

update

updating records

employees

record updated

updated successfully

employees

delete

deleting records

employees

record deleted

deleted successfully

employees

transaction

checking transaction record,�updating,deleting

trader

updated and deleted� successfully

updated successfully,�deleted successfully

trader, dealer,trust organization,emoloyees

interns

giving internship

Graduated� students

checking CV

internship granted/denied

graduated �students

admission

providing admission

students

checking percentage,�rank

admission successfully,� admission denied

students

fired

firing an employee

employee

giving validate reason

providing resignation letter/�employee fired

employee

meeting

placing meeting

employees

checking availability

meeting placed/ canceled

employees

appointment

arranging appointment

other companies,�client,dealers

checking availability

appointment arranged/cancelled

other companies,�client,dealers

​

​

​

​

​

​

91 of 186

Medical / Non Medical Staff

91

EVENT

SOURCE

TRIGGER

ACTIVITY

RESPONSE

DESTINATION

room service

​

Medical Staff

enter the service required

​

confirmation of room service

​

room service completed

​

Medical staff,database,

Admin , Receptionist

​

maintain records

​

Medical Staff

​

details or query updated

​

incoming outgoing

​

update successful

​

Medical staff,database,

Receptionist , Admin

​

transportation

​

Medical/ Non – Medical Staff

provides the Ambulance facilities

​

picks & drops thepatients

provided Ambulanceservices

​

Medical/Non – Medical staff,database,

Receptionist

, Admin

check-in Patients

Medical Staff

​

present/absent

​

Patients

checked in/out

​

Patients check-in/out time

​

Medical staff,database,

Admin , Receptionist

​

check daily reports

​

Medical Staff

​

check detail

Health report of patients

will check for reports on a daily basis

​

reports checked

​

Medical staff,Doctor,database,

Admin , Receptionist

​

92 of 186

Medical / Non Medical Staff

92

EVENT

SOURCE

TRIGGER

ACTIVITY

RESPONSE

DESTINATION

login

Medical

login through existing acc

will ask for details

login successful

medical,database

sign-up

Medical

insert new customer

will ask to fill new user registration form

new user will be added

Medical,database

add patients details

Medical

enter the Patients details

Patients details of room

updated successfully

Medical,database,Reciptionists

extra services

Medical

details of extra services provided

will check for extra requirements

service found

Medical,database

Add Foregin patients details

Medical

enter the Foregin Patients details

Foregin Patients details of room

updated successfully

Medical,database,Reciptionists

93 of 186

93

EVENT

SOURCE

TRIGGER

ACTIVITY

RESPONSE

DESTINATION

adding food items

Medical

shows Canteen menu

provide food

food provided

Medical,database

choosing room category

Medical

fill the room requirements

availability

room has been chosen

Medical,database

room service

Medical

enter the service required

confirmation of room service

room service completed

Medical,database, Reciptionists

login(Medical)

Medical

validate/verify

username, password details

login successful

Medical,database,HR

login(Non-Medical)

Non-Medical

validate/verify

username, password details

login successful

Non-Medical,database,HR

maintain records

Medical

details or query updated

incoming outgoing

update successful

Medical,database,HR

logout

Medical

validate/verify

username, password

logout successful

Medical,database

check-in attendees(Medical)

Medical

present/absent

attendees checked in/out

attendee’s check-in/out time

Medical,database,HR

check-in attendees(Non-Medical)

Non-Medical

present/absent

attendees checked in/out

attendee’s check-in/out time

Non-Medical,database,HR

Transportation i.e

Ambulance Service

Non-Medical

provides the Ambulance facilities

picks & drops the

Patients

provided Ambulanceservices

Non-Medical,database,Doctor

94 of 186

94

EVENT

SOURCE

TRIGGER

ACTIVITY

REPONSE

DESTINATION

add/update/show details at reception

Medical

select/update room and Patients details

will check for all rooms, Patients and booking details.

check-in/out done successfully

Medical,database,Receptiont

check daily reports

Medical

check detail of Patients

will check for reports on a daily basis

reports checked

Medical,database,Receptiont

booking Medicines from Inventory Management

Medical

books the medicines required

Medicines will be collected

collection successful

staff,database,Inventory Management

Emergency(Critical)

Medical

insert query

call doctor for support

Calls Doctor

staff,database,Doctor

95 of 186

Doctors/ lab expert

95

Event

Trigger

Source

Activity

Response

Destination

Login

Validate/verify

Doctor

Username,password details

login confirmation

Doctor

Add Personal Details

Insert Details

Doctor

add details

Added successfully

Doctor ,HR,Admin

Edit Personal Details

Update Details

Doctor

Update Details

Update cofirmation

Doctor ,HR,Admin

View patient details

Retrieval of patient details

Doctor

Displays the details of mentioned patient

Patient details

Doctor

view medical reports of patient

Retrieval of medical reports of patients

Doctor

Displays the medical reports of mentioned patient

patient medical reports

Doctor

Add prescription

Add new presccription

Doctor

Adds the new prescription

Added successfully

Doctor,patient,nurse

Edit prescription

Edit previous prescription

Doctor

updates the prescription

change confirmation

Doctor,patient,nurse

Set appointment Timings

Sets appointments

Doctor

Apointment timings will be set

Update cofirmation

Doctor,nurse,admin

View salary

Retrieval of salary details

Doctor

Displays the details of salary

Salary Details

Doctor

Add Diet Prescription

Add new presccription

Doctor

Adds the new prescription

Added successfully

Doctor,patient,nurse,catering

Edit Diet prescription

Edit previous prescription

Doctor

updates the prescription

change confirmation

Doctor,patient,nurse,catering

Add Test Prescriptions

Add new presccription

Doctor

Adds the new prescription

Added successfully

Doctor,patient,nurse,Lab Experts

Edit Diet prescription

Edit previous prescription

Doctor

updates the prescription

change confirmation

Doctor,patient,nurse,Lab Experts

96 of 186

96

Event

Trigger

Source

Activity

Response

Destination

Login

Validate/verify

Lab Expert

Username, password details

login confirmation

Lab Expert

View salary

Retrieval of salary details

Lab Expert

Displays the details of salary

Salary Details

Lab Expert

Add Personal Details

Insert Details

Lab Expert

add details

Added successfully

Lab Experts ,HR,Admin

Edit Personal Details

Update Details

Lab Expert

Update Details

Update cofirmation

Lab Experts ,HR,Admin

View patient details

Retrieval of patient details

Lab Expert

Displays the details of mentioned patient

Patient details

Lab Expert

Add medical reports of patient

Add medical reports of patients

Lab Expert

Update the medical reports of mentioned patient

Update confirmation

Lab Expert,Doctor,nurse,patient

View Test Prescription

Retrieval of Prescription details

Lab Expert

Displays the Test Prescription

Test Prescription

Lab Expert

Set appointment Timings

Sets appointments

Lab Expert

Apointment timings will be set

Update cofirmation

Lab Expert,patient

97 of 186

97

Event

Trigger

Source

Activity

Response

Destination

Login

Validate/verify

Caterer

Username,password details

login confirmation

Caterer

View salary

Retrieval of salary details

Caterer

Displays the details of salary

Salary Details

Caterer

Add Personal Details

Insert Details

Caterer

add details

Added successfully

Caterer ,HR,Admin

Edit Personal Details

Update Details

Caterer

Update Details

Update cofirmation

Caterer ,HR,Admin

View Patient Diet Prescription

Retrieval of Patient Diet Prescription

Caterer

Displays the Patient Diet Prescription

Patient Diet Presc

Caterer

Add Stock

Insert Stock

Caterer

Adds stock

Added successfully

Caterer,DB

Order Requirements

order Stock

Caterer

Order Stock

Order Confirmation

Caterer,DB,Dealer

Add to Menu

Add menu

Caterer

Adds to Menu

Added successfully

Caterer

Edit Menu

Update Menu

Caterer

UpdateMenu

Update cofirmation

Caterer

98 of 186

Finance Managers

Sr No

Event

Trigger

Source

Activity

Response

Destination

1

Views Client Bill

Bill Amount view

Finance Manager(LIC,StarHealth)

Viewing Bill Details

Total medical fees

Finance Company

2

Provides Insurance/Money

connecting bank/finance company

Finance Manager

Transfering money from bank to hospital

Amount paid successfully

Finance Company,Bank,patient,Hospital Department

3

Views Patient Bill

Bill Amount view

Government

Viewing Bill Details

Total medical fees

Government

4

Provides Money

Money payment

Government

Paying money to hospital

Amount paid successfully

Government,Patient,Hospital Department

5

Views Patient Bill

Bill Amount view

Political Health care Member

Viewing Bill Details

Total medical fees

Political health care manager

6

Provides Money

Money payment

Political Health care Member

Paying money to hospital

Amount paid successfully

Political health care manager,Patient,Hospital Department,Bank,Gov

7

Views Patient Bill

Bill Amount view

Trustee

Viewing Bill Details

Total medical fees

Trustee

8

Provides Money

Money payment

Trustee

Paying money to hospital according to budget

XYZ Amount is paid

Trustee, Patient,Hospital Department(cash counter)

9

Provides Money

Money payment

Trustee

Paying Bill fully

Amount paid successfully

Trustee, Patient,Hospital Department(cash counter)

10

View Patient Bill

Bill Amount view

Guardian/Family

Viewing Bill Details

Total medical fees

Guardian/Family

11

Bill Payment

Money payment

Guardian/Family

Transfering money from bank to hospital

Amount paid successfully

Guardian/Family,Patient,Hospital Department,Bank

12

Concession in bill

Concession bill Payment

Government

Request for Concession in bill payment

Concession provided successfully

Government,Patient,Hospital Department

99 of 186

Interns

Sr No

Event

Trigger

Source

Activity

Response

Destination

1

Take Admission

Admission form

Interns

Filling Details in form

Successfully filled details

Interns and Admin

2

Interns Pay Full Fees

Fess Payment

Interns

Paying Fees through digitally/ manually

Fees payed successfully

Interns and Admin

3

Interns Pay Installment Fees

Installment Fess Payment

Interns

Paying Installment Fees through digitally/ manually

xyz% Fess Payed successfully

Interns and Admin

4

Views Old Patient Records

Old data of patients (selective)

Interns

Viewing and analaysing old patients data

Viewing old data for interns

Interns

5

View their own progress

View Interns progress detail

Interns

Viewing Their own progress

Interns Progress Detail

Interns

6

Pay Fine

Fine Payment

Interns

Paying Fine

Fine Payed Successfully

Interns and Admin

7

Receive Reward

Reward for Interns

Interns

Receiving Reward from Hospital

Granted Reward from Hospital

Interns and Admin

8

Update Personal details

Personal details updation

Interns

Updating personal details

Details Updated Successfully

Interns, Doctor and Admin

9

Admit patients in hospital

Adding patients

Interns

Adding patients in hospital

Patient added successfully

Interns, Doctor,Patient and Admin

10

Admit Patients data through camp

Adding Patients through camp

Interns

Adding patients Details through camp

Patient added successfully

Interns, Doctor and Admin

11

Updating patients detail(camp)

Update patients detail(camp)

Interns

Updating Patients /details

Patients detail added successfully

Internsa,Doctor and Admin

12

Payed Interns update details

Personal details updation

Payed Interns

Updating personal details

Details Updated Successfully

Payed Interns, Doctor and Admin

13

Views Old Patient Records

Old data of patients (selective)

Payed Interns

Viewing and analaysing old patients data

Old Patient details for Interns

Payed Interns

14

View their own progress

View Payed InternsProgress detail

Payed Interns

Viewing Their own progress

Payed Interns Progress Detail

Payed Interns

15

Pay Fine

Fine Payment

Payed Interns

Paying Fine

Fine Payed Successfully

Payed Interns and Admin

16

Receive Reward

Reward for payed Interns

Payed Interns

Receiving Reward from Hospital

Granted Reward from Hospital

Payed Interns and Admin

17

Recieveing Salary

view salary

Payed Interns

check their salary updates

Salary granted/not granted yet

Payed Interns and Admin

18

Interns Admit as patient

bill payment

Interns

Bill payment

concession in bill

Interns and Admin

19

Payed Interns Admit as patient

bill payment

Payed Interns

Bill payment

concession in bill

Payed Interns and Admin

20

Apply for job

Job Application Form

Interns

Send Request for seeking job

Job request sent

Interns, Admin and chief Doctors

21

Adding patients details through camp

Admitting patients through camp

Payed Interns

Adding patients Details through camp

Patients detail added successfully

Payed Interns, Doctor and Admin

22

Resigning From Hospital

Block Payed Interns

Payed Interns

Resigning job from the hospital

You are no more working here thankyou for service

Payed Interns and Admin

100 of 186

External Organization

100

Sr No.

Event

Trigger

Source

Activity

Response

Destination

1

Login

Login as guest user

Organiser

To have access of data

New user added

Organiser and Admin

2

View Patients Details

View old records of patients

Organiser

To view Patients Records

Patients Record

Organiser

3

Give

Ratings of Services

Rating on the bases of 5 stars

Organiser

​

To give rating on bases of hospital services

Thanks for Rating

Everyone

(Website, App)

4

Remarks on Services

Remarks on hospital service

Organiser

​

To give remark of hospital’s Services

Remarks added successfully

Everyone

5

View Doctor Details

View Doctors records

Organiser

​

To view Doctor Details

Doctors Record

Everyone

6

Remark on Doctor

Remarks on Doctor

Organiser

​

To give remark on doctor’s performance

Remarks added successfully

Everyone

101 of 186

Pharmacist

Event

Activity

Source

Trigger

Response

Destination

Log in

Log in as Pharmacist

Pharmacist

/SuperUser

Validate

Login

Successful

Pharmacist

/SuperUser

/Database

Services And Logistics 24/7

Manages Pharmacy-related services and logistics 24/7

Pharmacist

Shows Logistics

Info

Your Services

SuperUser,

Database

HealthCare Providers

Contacting all healthcare provider for medication-related issues

SuperUser

Shows HealthCare

Issues

HealthCare

Issues

SuperUser,

Database

Statistics

Providing adequate statistics on medication consumptions

SuperUser

Shows Stats

Your Statistics

SuperUser,

Database

Medication Budgets

Planning for Medication budgets

SuperUser

Plan New Budget

Plan Budgets

SuperUser,

Database

102 of 186

Events

Activity

Source

Trigger

Response

Destination

Trainings

Conducting pharmacy-related training for under- and postgraduates

SuperUser

Shows On-Going Trainings

Trainings

On-going

SuperUser,

Database

Research Activities

Supervising pharmacy-related research activities

SuperUser

Shows Activities

Activities

SuperUser,

Database

Availability

Checks availability of medicines

Pharmacist

Shows Availability

Availability

SuperUser,

Database

Expiry

checking expires of medicines

Pharmacist

Shows Expiry

Expiry Meds

SuperUser,

Database

Suppliers

Keeping medicine supplier information

Pharmacist

Shows All Suppliers

Suppliers as

Follows

SuperUser,

Database

Stocks

Updating Stocks of Medicines

Pharmacist

Shows Stocks

Your Stocks

SuperUser,

Database

Discard

Discarding Expired Medicines For Recycle

Pharmacist

Show Discard

Items

Discard List

SuperUser,

Database

103 of 186

Event

Activity

Source

Trigger

Response

Destination

Log in

Log in as Insurance agent

​

Insurance agent

/SuperUser

Validate

Login

Successful

Insurance agent

/SuperUser

/Database

​

Services 24/7

Manages services for 24/7

​

Insurance agent

Shows Logistics

Info

Your Services

SuperUser,

Database

HealthCare Insurance Providers

Contacting all healthcare provider for insurance-related issues

​

SuperUser

Shows Insurance

related quey

insurance agenda

SuperUser,

Database

Statistics

Providing on insurance details regarding availability of patient details

SuperUser

Shows Stats

Your Statistics

SuperUser,

Database

Insurance Budgets

Planning for Medication insurance budget

SuperUser

Plan Insurance Budget

Plan Insurance Budgets

SuperUser,

Database

104 of 186

Blood / Organ Donation

104

EVENT

SOURCE

TRIGGER

ACTIVITY

RESPONSE

DESTINATION

ORGAN

DONATION

ORGAN DONOR

TO FILL UP AN INTENT FORM TO DONATE ORGAN

MAKING PROCEDURES FOR ORGAN TRANSPLANTATION TO RECIPIENT

CHECK WHETHER THE ORGAN TRANSPLANT IS SUCCESFULL

OR NOT

RECIPIENT/

NOTTO/ROTTO.

ORGAN DONATION

ORGAN RECIPIENT

LOOKOUT FOR POTENTIAL ORGAN DONORS

TRANSPLANTING AND LOOKING IF ORGAN IS

SUITABLE

FOR

RECIPIENT

MONITORING THE

PROGRESS

OF RECIPIENT

RECIPIENT

BLOOD DONATION

BLOOD DONOR

VOLUNTARY

BLOOD

TRANSFUSION

DONATING BLOOD

FOR TRANSFUSION

OR STORAGE IN A

BLOOD BANK

TO SEE WHETHER BLOOD IS SUITABLE TO ANY PATIENT

BLOODBANK

BLOOD

DONATION

BLOODBANK/RECIPIENT

TO SEARCH FOR SUITABLE BLOOD GROUP

TRANSFER OF BLOOD TO PATIENT IN NEED FROM BLOODBANK OR DONOR

MONITORING THE PATIENT

PATIENT

105 of 186

HR

105

EVENT

SOURCE

TRIGGER

ACTIVITY

RESPONSE

DESTINATION

Employee orientation

HR

Introducing new hires to their jobs,responsibilities and workspace.

Provide different orientation for the new employees

New hiring have been recorded.

HR,

employee

Training and performance monitoring

HR

Provide training programs through best practices so as to improve their overall performance.

Assessment of employee training needs

Designing, creating and implementing the program

 

Training and performance monitoring have been implemented.

HR, Staffs

Counselling

HR

Interact and provide counselling to the patient and the family members.

Provide counselling and therapy .

Counselling session have been carried out.

HR,

counselling team ,patient and family members

Claims and Handling

HR

Manages the organization,billing, filing, updating and processing of medical claims related to patient diagnoses, treatments and medications.

Maintaining patient records, interacting with health insurance agencies and assuring medical facilities

Claims and files have been maintened.

HR, Insurance agencies ,patients.

Maintaining budget and profit.

HR

Maintaining use of finanacial resources prudently by meeting patient and community needs.

 

The budgets have been maintained

HR Stockholders ,Owners

Serving the staff needs

 

Ensures the benefits of employees and monitors their performance evaluation.

To track employee requests for vacation and extended leave

The staff needs are ensured

HR,Staffs

Department is sufficiently staffed.

HR

Keeps the staff level appropriate according to the needs and patients count

Find immediate replacements and maintain contact with medical staffing agencies or on-call staffers.

The staffs are sufficiently staffed according to the needs

HR,non-medical and medical staffs ,patients.

106 of 186

106

Decision -Making

HR

Making decisions for the benefits of hospital.

Providing career planning and promotions

The decisions and planning are maintained

HR,other heads

Feedbacks from Staff-members

HR

Regular feedbacks to be taken to analyse the problems faced by the employees and take appropriate actions

Providing opporunity for employees to give feedbacks and suggestions.

Feedbacks and programs have been taken

HR ,employee

Risk Management

HR

Enforcing labor and wage laws regarding pay and break periods.

Ensuring that employees understand, and adhere to the organization's policies and procedures

Maintaining an employementeligibility verification form on each employee

HR ,employees

Ensures Credentials are updated

HR

To keep up with the license renewal times of staff members.

Ensures that certificates are maintained according to education qualification

The credentials are updated

HR, employee

107 of 186

107

SOURCE

TRIGGER

EVENT

RESPONSE

DESTINATION

Patient

New patient will have to register

Patient registration

Check registered successfully or not Also check whether already registered customer

Reception(App), Patients

Patient

After treatment

Patient bill payment

Check Payment status

Reception (App) Patients ; Bank

Patient

Patient can cancel the appointment

Appointment cancellation

Appointment cancellations

Patient ; Reception ;

Patient

Patient can reschedule his appointment

Rescheduling Appointment

Need to check availability of that specific doctor

Patient ; Reception

Patient

App will give them an appointment reminder

Appointment reminders

Through app

Patient ; Reception

Patients

108 of 186

108

Patient

Patient can enquire about doctors proficiency

Doctor enquiry

Patient gets to know Doctor's proficiency

Patient

Doctor

Patient

Patient will get to know what they cost for

Treatment Details

Will be given the appropriate details

Patient ; Reception

Doctors Nurse

Patient

Patient will receive information about their respective reports

Report sending (eg diabetes)

Can be notified through app

App

Patient

Patient

Patient can give feedback after their treatment

Feedback

Feedback is accepted

Patient

Reception

Patient

Patient can order medicine through app

Ordering Medicines

Lookup for medicine

Patient nurse

Staff member

Patient

Can check the availability of their desired Doctor

Check Doctor’s Schedule

Give that specific doctors working timings

Reception

Doctors

Patient

Patient can apply for insurance after bill

Apply for insurance

Check for proper documents

Reception

Insurance agent

Patient

109 of 186

Event

Activity

Source

Trigger

Response

Destination

Log in

Log in as PR

​

PR

/SuperUser

Validate

Login

Successful

PR

/SuperUser

/Database

​

Social influence

Manages social media,media 24/7

​

PR

Shows the fame of hospital via media and social media

stats of the popularity,unpopularity of hospital

SuperUser,

Database

Survey

Contacting all patient,staff etc.

​

SuperUser

Shows HealthCare

Issues

responses about hospital management

SuperUser,

Database

Complaints

taking responses from mdical and non medical staff aout the management

SuperUser

Shows complaint

if complaint occur,it will contact HR

SuperUser,

Database

HR

Planning for Medication budgets

SuperUser

shows fixed complaints

it wil fix everything if any complaint occur

SuperUser,

Database

110 of 186

Use Case Diagram

111 of 186

Health Insurance Use Case Diagram

Log In

Insurance provider

Services

Discard

Expired Insurance

client(patient)details

Insurance agent

Log in as SuperUser

Stats

Budgets

patient query

112 of 186

Doctor/lab use case diagram

112

113 of 186

Pharmacist Use Case Diagram

Log In

Stocks

Services & Logistics

Research

Discard

Expired

Suppliers

Pharmacist

Log in as SuperUser

Stats

Trainings

Budgets

HealthCare Providers

114 of 186

Donor Use Case Diagram

114

115 of 186

Medical/Non-Medical Use Case Diagram

115

116 of 186

Patient Use Case Diagram

Log In

registration

bill payment

reminders

doctor

Enquiry

insurance

Patient

appointment

Stats

resheduling

doctors

​

117 of 186

Finance Use case diagram

118 of 186

Interns Use case Diagram

119 of 186

External Organization Use Case Diagram

119

120 of 186

HR Use Case Diagram

120

121 of 186

Food service

121

122 of 186

Use Case Diagram

Log In

HR

Staff

social media - mobile platform

social imfluence

Survey

PR

Complaints

Doctors

Patient

Media

​

123 of 186

Board Of Directors

123

124 of 186

State Diagram

125 of 186

Login and Registration

126 of 186

Interns State Diagram

127 of 186

External Organization Donation

128 of 186

Equipment Management Module

129 of 186

Operation Management

130 of 186

Feedback State Diagram

131 of 186

On Demand

132 of 186

On Demand (Pharmacy)

133 of 186

Report Management

134 of 186

Report Management

135 of 186

BOD

136 of 186

Maintenance Management

137 of 186

Appointment

138 of 186

Canteen State Diagram

139 of 186

Loan

140 of 186

Insurance

141 of 186

Waste Management

142 of 186

Hospital Service

143 of 186

Sequence Diagram

144 of 186

144

145 of 186

145

Donor Sequence Diagram

​

​

146 of 186

146

Patients Sequence diagram

147 of 186

147

Doctor

148 of 186

Receptionist Sequence Diagram

149 of 186

Medical/Nonmedical

149

150 of 186

Function Point Analysis

151 of 186

Login:

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

2

3*2

6

Outputs

Simple

2

4*2

8

Average

1

5*1

5

Files

-

-

-

-

Inquiries

-

-

-

-

Interface

Simple

1

5*1

5

Total count: 24

152 of 186

Registration

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

22

3*22

66

Outputs

Simple

24

4*24

96

Files

Average

2

10*2

20

Inquiries

-

-

-

-

Interface

Simple

1

5*1

5

Total Count: 187

153 of 186

Profile Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

25

3*25

75

Average

5

4*5

20

Outputs

Simple

4

4*4

16

Files

Simple

7

7*7

49

Inquiries

Simple

5

3*5

15

Average

3

4*3

12

Interface

Simple

4

5*4

20

Total Count: 207

154 of 186

Appointment Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

30

3*30

90

Average

5

5*4

20

Outputs

Simple

3

4*3

12

Files

Simple

3

7*3

21

Inquiries

Simple

10

3*10

30

Average

4

4*4

16

Interface

Simple

2

5*2

10

Total Count: 199

155 of 186

Report Management:

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

7

3*7

21

Average

1

4*1

4

Outputs

Simple

6

4*6

24

Average

3

5*3

15

Files

Simple

2

7*2

14

Inquiries

Simple

1

3*1

3

Interface

Simple

3

5*3

15

Total Count: 92

156 of 186

Hospital Services

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

11

3*11

33

Average

2

4*2

8

Outputs

Simple

2

4*2

8

Files

Simple

1

7*1

7

Inquiries

Average

2

4*2

8

Interface

Simple

1

5*1

5

Total Count: 69

157 of 186

On Demand/Request Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

12

3*12

36

Average

3

4*3

12

Outputs

Simple

3

4*3

12

Average

1

5*1

5

Files

Simple

1

7*1

7

Complex

1

15*1

15

Inquiries

Average

1

4*1

4

Interface

Simple

3

5*3

15

Average

2

7*2

14

Total Count: 120

158 of 186

Waste Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

10

3*10

30

Average

10

4*10

40

Outputs

Simple

5

4*5

20

Complex

5

7*5

35

Files

Simple

5

7*5

35

Inquiries

Simple

6

3*6

18

Complex

5

6*5

30

Interface

Average

3

7*3

21

Total Count: 229

159 of 186

Maintenance Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

30

3*30

90

Average

20

4*20

80

Outputs

Simple

20

4*20

80

Average

10

5*10

50

Files

Average

15

10*15

150

Complex

5

15*5

75

Inquiries

Simple

10

3*10

30

Average

5

4*5

20

Interface

Average

3

7*3

21

Total Count: 596

160 of 186

Campaign Module:

160

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

25

25*3

75

Average

5

4*5

20

Outputs

Simple

5

4*5

20

Files

Complex

5

7*5

35

Inquiries

Simple

5

3*5

15

Average

3

4*3

12

Interface

Simple

2

5*2

10

Total count = 187

161 of 186

External Organization

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

30

3*30

90

Average

5

4*5

20

Outputs

Simple

6

4*6

24

Files

Simple

1

7*1

7

Inquiries

Simple

10

3*10

30

Average

4

4*4

16

Interface

Simple

2

5*2

10

Total Count: 197

162 of 186

Feedback:

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

8

3*8

24

Outputs

Simple

5

​

4*5

20

Complex

1

7*1

7

Files

-

-

-

-

Inquiries

Simple

2

3*2

6

Interface

Simple

1

1*5

5

Total Count: 62

163 of 186

Operation Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

30

3*30

90

Outputs

Average

5

5*5

25

Files

Average

5

10*5

50

Complex

1

15*1

15

Inquiries

Simple

2

3*3

9

Interface

Average

3

7*3

21

Total Count: 210

164 of 186

Equipment management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

15

3*15

45

Outputs

Simple

6

4*6

24

Files

Simple

1

7*1

7

Inquiries

Simple

3

3*3

9

Average

3

4*3

12

Interface

Simple

2

5*2

10

Complex

1

10*1

10

Total Count: 117

165 of 186

Canteen Management:

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

17

3*17

51

Outputs

Simple

2

4*2

8

Average

3

5*3

15

Files

Simple

1

7*1

7

Inquiries

Average

3

4*3

12

Interface

Simple

1

5*1

5

Total Count: 98

166 of 186

Loan Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

43

3*45

135

Outputs

Simple

2

4*2

8

Files

Simple

5

7*5

35

Inquiries

Simple

5

3*5

15

Interface

Simple

2

5*2

10

Total Count: 203

167 of 186

Insurance Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

15

3*15

54

Average

2

4*2

8

Outputs

Simple

2

4*2

8

Files

Average

5

10*5

50

Inquiries

Simple

5

3*5

15

Interface

Simple

2

5*2

10

Total Count: 145

168 of 186

Pharmacy Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

5

5*3

15

Average

4

4*5

20

Outputs

Simple

5

4*5

20

Average

5

5*5

25

Files

Average

5

7*5

35

Complex

3

10*3

30

Inquiries

Simple

15

3*15

45

Complex

5

6*5

30

Interface

Simple

3

5*3

15

Total Count: 235

169 of 186

Salary Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

15

3*15

45

Average

5

4*5

20

Outputs

Simple

5

4*5

20

Average

5

5*5

25

Files

Simple

3

7*3

21

Inquiries

Simple

5

3*5

15

Interface

Simple

2

5*2

10

Total Count: 156

170 of 186

Bill Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

10

3*10

30

Outputs

Simple

5

4*5

20

Average

1

5*1

5

Files

Average

2

10*2

20

Inquiries

Simple

5

3*5

15

Interface

Simple

2

5*2

10

Total Count: 100

171 of 186

Research Management:

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

10

3*10

30

Average

5

4*5

20

Outputs

Simple

5

4*5

20

Files

Average

4

10*4

40

Inquiries

Average

5

4*5

20

Interface

Average

2

7*2

14

Total Count: 114

172 of 186

Security Management

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

6

6*3

18

Average

2

2*4

8

Outputs

Simple

1

4*1

4

Files

Simple

1

7*1

7

Complex

1

15*1

15

Inquiries

Simple

3

3*3

9

Interface

Simple

1

5*1

5

Total Count: 66

173 of 186

Hospital Arrangements

Measurement Parameter

Weighing factor

Count

Calculation

Total

Inputs

Simple

19

3*19

57

Average

4

4*4

16

Outputs

Simple

2

4*2

8

Files

Simple

1

7*1

7

Inquiries

Average

3

4*3

12

Interface

Simple

2

5*2

10

Total Count: 110

174 of 186

Function Point Analysis

Complex internal processing = 4

Code to be reusable = 3

High performance = 4

Project adjustment factor = 11

Adjustment calculation:

Adjusted FP = Unadjusted FP X [0.65 + (adjustment factor X 0.01)]

= 3723 X [0.65 + ( 11 X 0.01)]

= 3723 X [0.76]

= 2,829.48 Adjusted function points

​

174

175 of 186

Function Point Analysis

  • Per Programmer = Function point 257.5 approx.
  • Per Month (Per Programmer) = 25 FP approx.
  • 257.5 / 25 = 10.3 Months
  • Per Month = (Salary) Rs 40,000 Per Programmer
  • 10.3 Months X Rs 40,000 = Rs 4,12,000 Per Programmer
  • 11 Programmer = Rs 45,32,000

​

175

176 of 186

Final Cost

  • COST OF A PER SERVER IS 5 LAKHS (QUANTITY X 2 ) => 10 LAKHS
  • COST OF A WEBSITE
    • level of Development
      • Setup Cost => 10K
      • Design and building => 1 Lakhs
        • Chat Bots => 1 Lakhs
      • Content Creation => 50K
      • S.E.O => 60K
    • Total Cost => 3.2 Lakhs

176

177 of 186

Final Cost

  • Application Cost
    • Levels Of Development :-
    • Pre-development (also called - discovery or research)
    • UX/UI design => 1 Lakhs
    • App development => 3 Lakhs
      • Separate Apps for Staff => 5 Lakhs
      • Realtime Video Chat => 5 Lakhs
      • Attendance through GPS => 5 Lakhs
      • Community Based Chat App => 2 Lakhs
    • App testing and deployment => 2 Lakhs
    • Ongoing support and maintenance => 3 Lakhs

177

178 of 186

Final Cost

  • White Box And Black Box : 2 Lakhs (Third Party)
  • Tablets for management : Per tablet cost is 30k x No. of Nurses/peons/etc. i.e. 50 = 15lakh (Tentative Price)
  • COST OF SECURITY AND MAINTENANCE => 2 LAKHS
  • IOT Based Supply Cart per Cost is 1.7 lakhs => 5 piece x 1.7 Lakhs =>8.5 Lakhs
  • COST OF ROBOTICS => 1 Cr
  • COST OF HARDWARES = 20 LAKHS
  • COST OF NETWORKING SYSTEMS = 5 LAKHS
  • COST OF SECURITY AND MAINTENANCE = 2 LAKHS

178

179 of 186

179

Cost of Vending machine => 5 Lakhs

Cost of the Big screen => 1 lakhs per piece i.e. 1 X 30 => 45 Lakhs

Total Cost of the project will be => 3 cr

180 of 186

Kiosk Self Service Machine

Advantages

  • Patient can place appointment using self service machine
  • Patient can view the hospital map
  • Nurse can update patient details in our machine according to the corresponding floor
  • Doctor can Insert patients details in our machine and view the records
  • Language will not be problem anymore.
  • No need to carry your tab everywhere you go, We got Kiosk.

​

181 of 186

Vending Machine

  • Patient can buy products on their own (self service)

​

​

  • This will minimize queue in pharmacy

​

​

​

182 of 186

ER Diagram

182

183 of 186

Some of our software feature

  • A one-stop, highly flexible and customizable online appointment scheduling module screen offering views across Physicians and departments for any given date range.
  • Registration screen to capture a wide array of patient information including mandatory fields
  • Faster turnaround through self-service kiosk
  • Integration with civil ID card readers, scanners and barcode readers
  • Integration with insurance back office for co-payment and deductible calculations

184 of 186

Some of our software feature

  • SMS and e-mail confirmation for status updates to patient and Physician
  • A wide array of reports with live updates on day-to-day transactions
  • Facility to capture sponsor cards and scanned documents
  • View all patients’ medical history and consultation from doctor
  • Link patient to a predefined sponsor category based on the documents submitted

185 of 186

Conclusion

  • This project have been designed in a great user friendly and largely providing attribute interface and tp meet the requirement of a hotel management system.
  • The project is working with quick response and same level of security is also maintained.

185

186 of 186

THANKS!

For Giving Your Time

186