Hospital Management

System
Life Line Medical Hospital

Presented by : Edu Saheed Olanrewaju

Presentation Outline
 Introduction
 Structure of Hospital management system
 SQL Server
 Ado. Net and Login Page.
 Microsoft. Net Framework
 Application Screen Short
 Conclusion
Introduction
 New realities are placing pressures on the healthcare industry, and how patient
care is delivered. Rising hospital management costs, an aging population, a
shortage of healthcare workers, challenges in accessing services, timely
availability of information, issues of safety and quality, and rising consumerism
are some of the facts of today’s healthcare system.
 The industry has reached a point of chasm, where they need to decide how
services could be delivered more effectively to reduce costs, improve quality, and
extend reach.
 The critical questions facing the industry today include: how can we effectively
manage hospitals and provide enhanced services without placing additional
burden on a system already pushed to its limits; how can we provide care in a
cost-efficient manner at a time when healthcare spending is rising; and how do
we most efficiently use our resources and support front-line staff in order to
reduce medical errors and enhance quality of care.
Structure of Hospital management system
 Life line hospital was founded in 2004 with am aim to help people with their medical
needs. It has become a real life line for the cit of Texas because it was founded with
the motive to serve people rather than profits. Highly dedicated employees and a
specialized medical staff are the key factors that help people to rely on life line

 Life line has a group of social and professional people as directors and managers in
its management, who provide a personal as well as professional touch to the overall
working of the hospital. Proper guidelines and objectives are laid down for every
process and section of the hospital, which results in ensuring satisfaction of patients
Department structure of life line

Life Line

Financial Patient Registration Details Miscellaneous Operating

Accounting Department

Medical History Drug History Patient Insurance

Equipment Payroll
Maintenance Management

General Store

Bills Payable Diagnosis and Medical Store

Treatment Details

Research and
laboratory

Department Structure of Life Line

 Current System

 Life Line maintains a manual system to manage its operations. The front desk assistant handles
the Out Patient (OP) registration details.
 When a patient comes for admission or consultation, the front desk assistant make the required
entries in the OP file.
 The front desk assistant provides an OP number and then the patient is referred to the concerned
doctor, such as physician, surgeon, eye nose throat (ENT) specialist, or dentist.
 The concerned department assistant then makes the entry of the patient in the In-Patient (IP) file
and provides an IP number. The patient is then referred to an available doctor and the treatment
process starts.
 The Patient Insurance department issues the required documents for the medical insurance of
the patient. The documents are then sent to the concerned doctor and accounts department for
approval and if the approval is given, the documents are sent to the concerned insurance
company
The ER diagram of the patient’s registration and
management in life line
Doc ID PreHosp
Med History
Address PreDoc
Patient
OP ID Has Medical History

Name

OP ID

Undergoes

OP ID
Login Password
Doc ID
Treatment
Username

Treat Details IP ID

Doctor
Speciality

Doc ID Name

ER Diagram of the Patient’s Registration and Management in Life Line

Envisioned System
The existing system needs to be computerized and should facilitate the life line
employees to provide quick and reliable services to the patients and their attendants. A
new system needs to be developed for lifeline that should accomplish the following
functions.

 Patient details should be duly store and maintained in the system.

 The front desk assistant should be able to allot a unique OPID to a patient.
 The department assistant should be able to allot a unique IPID to the patient
referred from the front desk.
 Patient history should be recorded so that the concerned doctor could use the
details for treatment
 The system should be able to generate treatment details and respective reports
when the patient is ready to leave the hospital.
 The patient’s insurance details should be managed to help the patient enjoy
insurance benefits .
 An efficient payroll management module needs to be created to facilitate employees
of lifeline.
 The financial inflow and outflow of fund should be managed as a separate financial
management module so that proper utilization and planning of funds can be made.
 The inventory management module needs to be created to manage the general and
medical store inventories.
 The envisioning system should also include a module for management of the
research and laboratory wing of life line.
The Patient Registration Module Diagram

Patient
Registration
Details
Database
Front Desk Assistant

Patient
Treatment
Details

Departmental
Assistance

Patient Registration Module Diagram

You being the part of the software development team have been assigned the task of
creating the business tier components, and integrating the presentation tier and the
data tier component for the patient registration module. The following tasks are for
immediate implementation:

1. Implement the functionality on the login page to validate user credentials

and provide the user with appropriate features and functionality.
2. Implement the functionality on the home page to enable the user to be
redirected to the Patient registration page. A message should be displayed
on the page that the hospital management system is under construction.
Only the patient registration menu option will be enabled and other menu
option, such as patient insurance and medical store, will be disabled.
3. Implement the functionality on the patient registrations page to view and
update the patient’s details. A patient details report should be generated
containing various descriptions, such as patient OPID and IPID.
4. Implement the functionality on the patient history page to view and modify
the medical history related to a patient.
SQL Server
Organizations have always been storing and managing business data. Earlier they
used to store on papers. With an increase in the sage of computers organization began
building and using business application to support the business operation. The
business application accepts data as input, process the data based on the business
requirements, and provide data or information as output.

System Architecture
To develop application of this kind various model or architectures are
there. Depending on the placement of elements such as user
interface, business logic, data storage, the application can be
categorized as:

Single Tier Architecture

Two Tier Architecture
Three tier architecture
N-tier architecture
 Presentation tier: This layer consists of window forms. The forms can be
used for accepting data and displaying the final result to the users. In
addition, they can be used to generate various reports, such as payroll and
patient details.
 Business logic layer tier: This layer contain the code to create the life line
hospital management system.
 Data tier: This layer consist of the SQL Server 2005 database to store the relevant
data.
 SQL Definition
SQL is a core language is use to store access and modify data. SQL is a language
used to manage data which was developed IBM in the 1970, and follows the (ISO)
and American National standard institute (ANSI) standards. Transact SQL (TSQL)
is the scripting language used on SQL server for programming. T-SQ confirms to
the ANSI-SQL -92 standard published by ANSI and ISO in the year 1992.
The SQL statement can be categorized as:
Data Definition Language (DDL): is used to define the database, data types
structures, constrains on the data. Some of the DDL commands are: CREATE,
ALTER and DROP:

Data Manipulation Language (DML): is used to manipulate in the database

objects. Some of the DML commands are: INSERT, UPDATE and DELETE.

Data Control Language: is used to control the data access in the database.
Some of the DCL commands are: GRANT.

Data Query Language: is used to query data from the database objects.
SELECT is the DQL command that is used to select data from the database in
different ways and formats.
 ADO.NET AND LOGIN
ADO.NET is a set of computer software components that can be used by
programmers to access data and data and data services. It is a par f based class
library that is included with the Microsoft. Net framework. It is commonly used by
programmers to access and modify data stored in relational database systems,
though it can also be used to access data in non relational sources. ADO.NET is
sometimes considered as evolution of ActiveX data objects (ADO) technology, but
was changed so extensively that it can be considered an entirely new product.
ADO.NET consists of two primary parts:
Data Provider: These classes access to a data source, such as a Microsoft
SQL server or Oracle Database and OLEDB data provider. Each data source
has its own set of provider objects, but they each have a common set of utility
classes.

Data Set: Data sets objects is a group of class describing a simple in memory
relational database, where the star of the show in the initial release (1.0) of the
Microsoft. Net framework. A data set is populated from a database by a data
adapter whose connection and command properties have been set. However,
a data set can save its contests to XML (optionally with an acts as the
schema), or populate itself from XML, making it exceptionally useful for web
services, distributed computing and occasionally-connected applications.
 LOGIN
In the computer security, login (logging or signing in) is the process by which
individual access to a computer system is controlled by identification of the user using
credentials provide by user. A user can log on to a system to obtain access and
logout when access is not needed. The primary use of computer login procedure to
authenticate the identity of user (or computer software on this or a different computer)
attempting to access the computer service to login into a system usually requires.

Username.
Password.
 Microsoft. Net Framework

The Microsoft. Net framework introduction is software that is available with several
Microsoft window operating systems. It includes a large library of pre-coded solution.
To common programming problem and a virtual machine that manages the execution
of program written specifically for the frame work. The .NET framework is a key
application created for the windows platform.
The following figure shows the ADO.NET object model.

Data Adapter Data Set

Connection Command

XML

Connection

Database

In the ADO.NET object model, the data residing in database is retrieved through
a data provider. In application can access the data either through a data set or
through a data reader output.
ADO.NET and Visual Studio.NET
Functionality exist in the Visual Studio.NET IDE to create specialized subclasses of the Data
Set classes for a particular database schema, allowing convenient access to each field
through strongly-typed properties. This helps catch more programming errors at compile-time
and makes the IDE’s intelligence feature more useful.
Control Used

Control Properties Description

Menu Strip Items Is used to add menu to display in the control in the menu strip. This
property can be set either at design time or run time.
Layout style Is used to set how the menu item should be displayed in the form as
well as in the control.
Label Text Is used to set the text to be displayed in the label control.
Auto size Enable automatic resizing of the label control according to the length
of its caption. This property is used to change the text of the label at
run time.
Text box Text Is used to set for the button control.

Flat Style Is used to set the appearance of the button control. It has four values
which are different styles of a button control.
AutoScroll Is used to provide logical grouping of other controls
Control Properties Description

Buttons Text Is used to set for the button control.

Flat Style Is used to set the appearance of the button control. It has four values which are
different styles of a button control.

panel AutoScroll Is used to provide logical grouping of other controls

DataGridView DataSource This control is used to diplay data from multiple records as well as multiple
columns. The data source property of the DataGridView control is used to bind the
to a specific data element, such as a column of a DataTable.
 SCREEN SHOT
Login
Information
Search
New Patient
Patient Details
Q&A
I hope this is informative for you !!!

Thank you
For Any More Information
Email:
olanrewaju111@gmail.com