Information System Development & Analysis: Salvation Hospital

This report provides an overview of the Information System (IS) at Salvation Hospital, which is managed by the UHS Trust. It identifies the five key components of an IS (hardware, software, database, people, and network) and their integration to perform input, process, output, control, and feedback. The report highlights applications of IS such as Financial IS and EHR implementation, detailing their benefits in financial analysis, quality assurance, and regulatory compliance. It also discusses healthcare information system standards, usage, and tools & techniques like modeling, prototyping, and JAD/RAD. Key challenges in IS implementation, such as misaligned requirements and user resistance, are addressed, along with factors contributing to successful IS adoption, including empathy, responsiveness, reliability, assurance, tangibles, and competence. Finally, the report outlines the developed information system modules, including housing projects management, beneficiaries management, and investments management, and provides entity relationship diagrams illustrating data structures within the system.

Salvation Hospital
UHS Trust.
Information
System

2
 Information System
Successful organizations large and small
leverage available technologies to manage
business activities and assist in making
decisions. They use information systems to
collect data and process it according to
the needs of the analyst, manager or
business owner. Businesses operate more
efficiently by using varied information
systems to interact with customers and
partners, curtail costs and generate
revenues.
INTRODUCTION
 Key points
 Transaction Processing Systems
 Customer Relationship Management Systems
 Business Intelligence Systems
 Knowledge Management Systems
Five components of IS:
 Hardware
 Software
 Database
 People
 Network
This components integrate to perform process, output, input, control
and feedback.

“Financial IS”
 Enable financial analysis
utilizing easy to use tools.
 Integrated financial analysis
from multiple sources
 Compare past and present
financial activity.
“EHR Implementation”
 Tactical system and operation
for easy control over crucial
information.
 Classification of the data
availability at administrative
level.
 Task and activity manage and
monitoring
“Other key application
”
 Quality assurance & regulatory
checking.
 Automated CAHPS File Transfer.
 Point-of-care Functionality
Applicatio
ns
Of Information System
3

Healthcare Information System
Healthcare Information System Standards Usage

5
TOOLS
The relationship between methods and
tools is most obvious in the construction
phase: program code written in a high-
level language is compiled into machine
code. There are some tools and techniques
for different phases.
Tools & Techniques:
 MODELING
 PROTOTYPING

process-centered technique
 joint application development
(JAD) and rapid application
development (RAD)

6
Requirements
do not
represent the
actual needs
of the
customer.
Requirements
are
incomplete or
conflicting
Requirements
are difficult
and expensive
to update
after they
have been
agreed upon
Customers,
requirements
analysts, and
software
engineers
who develop
the system
have
difficulties
understandin
g each other.
Organization’
s Decision To
Adopt
Information
Technology
Challenges
1 2 3 4 5

77
Reasons
behind
failure
 Change in Management and
System Expectations
 Not Involving all Stakeholders
in the Requirements Definition
Process
 User Resistance to the
Developed System

8
Empathy: caring, individualized
attention the company provides its
customers.
Responsiveness: willingness to help
customers and provide prompt
service.
Reliability: ability to perform the
promised service dependably and
accurately n Assurance: knowledge
and courtesy of employees and their
ability to convey trust and confidence.
Tangibles: appearance of physical
facilities , equipment, personnel and
communication materials and
competence.
Successfu
l factors

Modules of the Developed Information System The initially determined
fourteen modules were narrowed down to only eight. These included the
modules for housing projects management, beneficiaries management,
housing and residents management, developmental programs management,
investments management, managerial communications (correspondence
system), archiving, and the system management module.
Developed Information System

Data Attribute Data type
Room Number Integer
Floor number Integer
Patient ID Integer
Patient name varchar
Staff Assigned Varchar
Data Attribute Data type
Address varchar
Doctor ID Integer
Patient ID Integer
Patient name varchar
Contact Number Integer
Entity1- Room
Entity 2- patient
Entities and Types Entity 3- Drug_consume_record
Data Attribute Data type
Record_ID Integer
Patient ID Integer
Satff_ID Integer
Drug_ID Integer
Presciption_ID Integer
Entity 4- Doctor
Data Attribute Data type
Address varchar
Doctor ID Integer
Doctor Name Varchar
Contact Number Integer
Entity 5- Prescription
Data Attribute Data type
Drug_U_NO Integer
Prescription ID Integer
Doctor Name Varchar
Patient name varchar
Drug Number Integer

Entity 6- Drugs
Data Attribute Data type
Drug_U_NO Integer
Drug Name Varchar
Drug Dose Integer
Expire Date Integer
Drug Price Integer
Entity 7- Staff
Data Attribute Data type
Staff_ID Integer
Staff_Name Varchar
Staff_first_name Varchar
Staff_last_name Varchar
Contact Number Integer
Entities and Types

Patient
Drugs
Doctor
Room
Staff
Presciption
Drug_consume_Record
Patient name
Patient IDPK
Address
Contact Number
Doctor IDFK
Expire Date
Drug Name
Drug Price
Drug dose
Drug U_NOPK
Doctor Address
Doctor IDPK
Contact Number
Doctor Name
Patient name
Room numberPK
staff assigned
Floor NumberFK
Staff_first_name
Staff IDPK
Staff_Last_nme
Contact Number
Staff NameFK
Doctor IDFK
presciption IDPK
Drug name
Drug U_NOFK
Patient Name
Staff IDFK
Record_ IDPK
Drug IDFK
Presciption IDFK
Patient IDFK
Patient IDFK
2NF
Patient
Drugs
Doctor
Room
Staff
Presciption
Drug_consume_Record
Patient name
Patient IDPK
Address
Contact Number
Doctor IDFK
Expire Date
Drug Name
Drug Price
Drug dose
Drug U_NOPK
Doctor Address
Doctor IDPK
Contact Number
Doctor Name
Patient name
Room numberPK
staff assigned
Floor NumberFK
Staff_first_name
Staff IDPK
Staff_Last_nme
Contact Number
Staff NameFK
Doctor IDFK
presciption IDPK
Drug name
Drug U_NOFK
Patient Name
Staff IDFK
Record_ IDPK
Drug IDFK
Presciption IDFK
Patient IDFK
Patient IDFK