1. INTRODUCTION 1.1 About the project
Our project Hospital Management System includes registration of patients, storing their details into the system and also computerized billing in the pharmacy, and labs. Our software has the facility to give a unique id for every patient and stores the details of every patient and the staff automatically. It includes a search facility to know the current status of each room. User can search availability of a doctor and the details of a patient using the id. The Advanced Hospital Management System can be entered using a username and password. It is accessible either by an administrator or receptionist. Only they can add data into the database. The data can be retrieved easily.
The interface is very user-friendly.
The data are well
protected for personal use and makes the data processing very fast.
1
1.2 Organizational profile
Srishti Systems is a software and Web Development Company which provides technology solutions and professional software for clients worldwide. Srishti focus on quality, innovations and leverage deep industry and functional expertise to help customers to transform their highest value business processes. Our in-depth technical knowledge coupled with industry experience and the unique methodology enables us to successfully deliver the services to clients worldwide. We are driven to attain our customer¶s highest satisfaction by providing business experts with underlying delivery expertise in Enterprise Technology, Methodologies and Implementations. Our core competencies are designed to effectively deliver results to our customers.
Srishti Training Center provides premier instructor-led IT training through a carefully balanced blend of hands-on lab exercises and lecture. Training is conducted in the comfortable classrooms at our training facility and client locations. productive and enjoyable. enjoyable.
Experienced instructors make training
Customizable Customizable courses and computer lab lab offer
additional options fro your training needs. needs. We also provide project guidance for all academic students which help them to t o build a successful portfolio and start their IT journey successfully s uccessfully..
2
1.2 Organizational profile
Srishti Systems is a software and Web Development Company which provides technology solutions and professional software for clients worldwide. Srishti focus on quality, innovations and leverage deep industry and functional expertise to help customers to transform their highest value business processes. Our in-depth technical knowledge coupled with industry experience and the unique methodology enables us to successfully deliver the services to clients worldwide. We are driven to attain our customer¶s highest satisfaction by providing business experts with underlying delivery expertise in Enterprise Technology, Methodologies and Implementations. Our core competencies are designed to effectively deliver results to our customers.
Srishti Training Center provides premier instructor-led IT training through a carefully balanced blend of hands-on lab exercises and lecture. Training is conducted in the comfortable classrooms at our training facility and client locations. productive and enjoyable. enjoyable.
Experienced instructors make training
Customizable Customizable courses and computer lab lab offer
additional options fro your training needs. needs. We also provide project guidance for all academic students which help them to t o build a successful portfolio and start their IT journey successfully s uccessfully..
2
2. SYSTEM ANALYSIS 2.1 Introduction
System Analysis is the detailed study of the various operations performed by the system and their relationships within and outside the system. Analysis is the process of breaking something into its parts so that the whole may be understood. System analysis is concerned with becoming aware of the problem, identifying the relevant and most decisional variables, analyzing and synthesizing the various factors and determining an opti mal or at least a satisfactory solution. During this a problem is identified, alternate system solutions are studied and recommendations are made about committing the resources used to design the system Here in the project Advanced Hospital Management System, a detailed study of existing system is carried along with all the steps in system analysis. An idea for creating a better project was carried and the next steps were followed. 2.2 EXISTING SYSTEM
. Existing system refers to the system that is being followed till now. Presently all the hospital functionalities are done manually. That is if a patient want to consult a doctor he can visit their till his chance called. This is make the person very difficult. Out_Patient and In_Patient tickets are distributed directly. The main disadvantage is time consuming.
3
2.2.1 LIMITATIONS OF EXISTING 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 limitations and make the the system
working more more
accurately it needs to be computerized. 2.3 PROPOSED SYSTEM
The aim of proposed system is to develop a system of improved facilities. The proposed system can overcome all the limitations of the existing system. The system provides data accuracy and save disc space. The existing system has several disadvantages and many more difficulties to work well. The proposed system tries to eliminate or reduce these difficulties up to some extent. The proposed system will help the user to consume time. The system requires very low system resources.
2.3.1 OBJECTIVES OF PROPOSED SYSTEM
The Hospital management system software is user-friendly software. The main objectives of the system is which shows and helps you to collect most of the information about Hospitality and Medical Services The system
4
is very simple in design and to implement. The system requires very low system resources and the system will work in almost all configurations. The main objectives of the proposed system can be enumerated as follows: y
Patients are easily allocated to the doctors.
y
Doctors Search is possible.
y
Today¶s patient list help doctors to search their patients
2.3.2 ADVANTAGES OF PROPOSED SYSTEM
The system is very simple in design and to implement. The system requires very low system resources and the system will work in almost all configurations.
Security of data.
Ensure data accuracy¶s.
Administrator controls the entire system.
R educe
the damages of the machines.
Minimize manual data entry.
Greater efficiency.
User friendly and interactive.
Minimum time required.
5
FEASIBILTY STUDY
A feasibility analysis usually involves a through assessment of the operational(need), financial and technical aspects of a proposal. Feasibility study is the test of the system proposal made to identify whether the user needs may be satisfied using the current software and hardware technologies, whether the system will be cost effective from a business point of view and whether it can be developed with the given budgetary constraints. A feasibility study should be relatively cheap and done at the earliest possible time. Depending on the study, the decision is made whether to go ahead with a more detailed analysis.
When a new project is proposed, it normally goes through feasibility assessment. Feasibility study is carried out to determine whether the proposed system is possible to develop with available resources and what should be the cost consideration. Facts considered in the feasibility analysis were.
y
Technical Feasibility
y
Economic Feasibility
y
Behavioral
Feasibility
6
2.4.1 TECHNICAL FEASIBILITY
Technical feasibility includes whether the technology is available in the market for development and its availability. The assessment of technical feasibility must be based on an outline design of system requirements in terms of input, output, files, programs and procedures. This can be qualified in terms of volumes of data, trends, frequency of updating, cycles of activity etc, in order to give an introduction of technical system. Considering our project if is technically feasible. Advanced Hospital Management System with its emphasis on a more strategic decision making is fast gaining ground as a popular outsourced function. 2.4.2 OPERATIONAL FEASIBILITY
This analysis involves how it will work when it is installed and the assessment of political and managerial environment in which it is implemented. People are inherently resistant to change and computers have been known to facilitate change. The new proposed system is very much useful to the useful to the users and there for it will accept broad audience from around the world.
7
3. SOFTWAREREQUIREMENT SPECIFICATIONS 3.1 SOFTWARE SPECIFICATIONS Operating System
:
Windows 2000/XP
Font end
:
Visual Basic 6.0
Back end
:
MS Access
Design Tool
:
Data Flow Diagram
3.2 HARDWARE SPECIFICATIONS Processor
:
X86 Compatible processor with 1.7
RAM
:
512 MB or more
Hard disk
:
20 GB or more
Monitor
:
VGA/SVGA
Keyboard
:
104 Keys
Mouse
:
2 buttons/ 3 buttons
GHz Clock speed
8
3.3 LANGUAGE REQUIREMENT 3.3.1 VISUAL BASIC
Visual
Basic
6.0 is Microsoft¶s latest version of the Visual
Basic
Programming language. Although writing programs can be a tedious chore at time. Visual
Basic
reduces the effort required on your part, and makes
programming enjoyable. Visual Basic makes many aspects of programming as simple as dragging graphics objects on to screen with your mouse. Visual Basic 6.0 is more than just a programming language; the secret to Visual
Basic
is in its name´ Visual´. With to days Windows Operating
System, a program must be able to interact with the screen. Keyboard, mouse and printer graphically. The environment provided by Visual
Basic
is suitable for any type of
application. Using this environment, the user can visually design the objects that your application uses.
Visual
Basic
is not just a languages, it¶s an
integrated development environment in which you can develop, run, test and debug your applications. The impressive array of programming resources provided by Visual
Basic
enables to create the objects extemporaneously
which can range from pop-up menu to a message box. A form is a major part of Visual
Basic
application, which allows the
user to enter the data as well as view the result. A control is an object that we draw on a form to enable or enhance user interaction with an application.
9
Hence a Visual
Basic
application is a combination of object like forms and
controls, procedures that can respond to Events and other general-purpose procedures. Visual Basic (VB) is an event-driven programming language. This is
called because programming is done in a graphical environment unlike the previous version
BASIC
where programming is done in a text only
environment and executed sequentially in order to control the user interface. Visual Basic enables the user to design the user interface quickly by drawing and arranging the user elements. Due to this spent time is saved for the repetitive task. Visual Basic is an event-driven language. Visual
Basic
is governed
by an event processor. That means that nothing happens in a Visual
Basic
project until some event occurs. Once an event is detected, the project finds a series of instructions related to that event, called an event procedure. An event is an action recognized by a form or the control. Event driven applications execute basic in response to an event. Each form and control in Visual
Basic
has a predefined set of events. If one of these events
occurs and there is code in the associated event procedure, Visual invokes that code.
10
Basic
Following is the sequence of events in an event driven applications. a) The application starts and a form is loaded and displayed. b) The form (or a control on the form) receives an event. The event might be caused by the user (For example, a key stroke), by the system (For example, a timer event), or indirectly by your code. c) If there is code in the corresponding event procedure, it executes. d) The application waits for the next event.
Features of Visual Basic:
1. Good User Interface. 2. OLE Features. 3. Windows API Features. 4. 32 bit Programming
Languages.
5. Data Management 6. Online Help 7. Data Access.
11
3.3.2
MICROSOFT ACCESS
Microsoft Access
Microsoft Access is the default database of Microsoft Visual
Basic.
Microsoft Access 2003 provides many new features that make working with data and designing a database even easier. Microsoft Access Database is a collection of data and objects related to particular topic or purpose. Microsoft Access Database may contain tables; queries, forms, reports, macros modules and shortcuts top data access pages.
Microsoft Access is a
R elational
Database Management System.
Using Access we can organize our data according to subject and can store information about how different subject are related. In general MS-Access database can have several small tables.
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system.
Access can use data stored in Access/Jet, Microsoft SQ L Server, Oracle, or any OD BC-compliant data container (including MySQ L and PostgreSQL). Skilled software developers and data architects use it to
12
develop application software.
R elatively
unskilled programmers and non-
programmer "power users" can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool.
Access was also the name of a communications program from Microsoft, meant to compete with ProComm and other programs. This proved a failure and was dropped. Years later Microsoft reused the name for its database software.
Access is used by small businesses, within departments of large corporations, and by hobby programmers to create ad hoc customized desktop systems for handling the creation and manipulation of data. Access can be used as a database for basic web based applications hosted on Microsoft's Internet Information Services and utilizing Microsoft Active Server Pages ASP. Most typical web applications should use tools like ASP/Microsoft SQ L Server or the LAMP stack. Some professional application developers use Access for rapid application development, especially for the creation of prototypes and standalone applications that serve as tools for on-the-road salesmen. Access does not scale well if data access is via a network, so applications that are used by more than a handful of people tend to rely on Client-Server based solutions. However, an Access "front end" (the forms, reports, queries and VB code) can be used against a host of database back ends, including JET
13
(file-based database engine, used in Access by default), Microsoft SQ L Server, Oracle, and any other OD BC-compliant product. Features
One of the benefits of Access from a programmer's perspective is its relative compatibility with SQ L (structured query language) ²queries may be viewed and edited as SQL statements, and SQ L statements can be used directly in Macros and V BA Modules to manipulate Access tables. Users may mix and use both V BA and "Macros" for programming forms and logic and offers object-oriented possibilities. MSDE (Microsoft SQ L Server Desktop Engine) 2000, a mini-version of MS SQ L Server 2000, is included with the developer edition of Office XP and may be used with Access as an alternative to the Jet Database Engine. Unlike a modern
R DBMS,
the Access and the Jet Engine implements
database triggers and stored procedures in a non-standard way. Stored Procedures are implemented in V BA, and Triggers are only available from embedded Forms.
Both
Triggers and Stored procedures are only available to
applications built completely within the Access database management system. Client applications built with V B or C++ are not able to access these features. Starting in MS Access 2003 (Jet 4.0), there is a new syntax for creating queries with parameters, in a way that looks like creating stored procedures, but these procedures are still limited to one statement per procedure. Microsoft Access does allow forms to contain code that is triggered as changes are made to the underlying table (as long as the modifications are done only with that form) and it is common to use pass-
14
through queries and other techniques in Access to run stored procedures in R DBMSs
that support these.
In ADP files (supported in MS Access 2003 and later), the databaserelated features are entirely different, because this type of file connects to a MSDE or Microsoft SQ L Server, instead of using the Jet Engine. Thus, it supports the creation of nearly all objects in the underlying server (tables with constraints and triggers, views, stored procedures and UDF-s). However, only forms, reports, macros and modules are stored in the ADP file (the other objects are stored in the back-end database).
SYSTEM DESIGN INTRODUCTION
The most creative and challenging face of the system development is System Design. It provides the understanding and procedural details necessary for implementing the system recommended in the feasibility study. Design goes through the logical and physical stages of development.
In designing a new system, the system analyst must have a clear understanding of the objectives, which the design is aiming to fulfill. The first step is to determine how the output is to be produced and in what format. Second, input data and master files have to be designed to meet the requirements of the proposed output. The operational phases are handled through program construction and testing.
15
Design of a system can be defined as a process of applying various techniques and principles for the purpose of defining a device, a process or a system in sufficient detail to permit its physical realization. Thus system design is a solution to ³how to´ approach to the creation of a new system. Thus important phase provides the understanding and the procedural details necessary for implementing the system recommended in the feasibility study. The design step provides a data design, architectural design, and a procedural design.
4.1 INPUT DESIGN
In the input design, user-oriented inputs are converted into a computer based system format. It also includes determining the record media, method of input, speed of capture and entry on to the screen. Data entry accepts commands and data through a keyboard. The major approach to input design is the menu and the prompt design. In each alternative, the user¶s options are predefined. The data flow diagram indicates logical data flow, data stores, source and destination. Input data are collected and organized into a group of similar data. Once identified input media are selected for processing.
In this software, importance is given to develop
Graphical
User
Interface (GUI), which is an important factor in developing efficient and user-friendly software. For inputting user data, attractive forms are designed. User can also select desired options from the menu, which provides all possible facilities.
16
Also the important input format is designed in such a way that accidental errors are avoided. The user has to input only just the minimum data required, which also helps in avoiding the errors that the users may make. Accurate designing of the input format is very important in developing efficient software. The goal or input design is to make entry as easy, logical and free from errors.
4.2 OUTPUT DESIGN
In the output design, the emphasis is on producing a hard copy of the information requested or displaying the output on the C R T screen in a predetermined format. Two of the most output media today are printers and the screen. Most users now access their reports from a hard copy or screen display. Computer¶s output is the most important and direct source o f information to the user, efficient, logical, output design should improve the systems relations with the user and help in decision-making.
As the outputs are the most important source of information to the user, better design should improve the system¶s re lation and also should help in decision-making. The output device¶s capability, print capability response time requirements etc should also be considered form design elaborates the way output is presented and layout available for capturing information. It¶s very helpful to produce the clear, accurate and speedy information for end users.
17
4.3 DATABASE DESIGN
The general theme behind a database is to handle information as an integrated whole. A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and effectively. After designing the input and output, the analyst must concentrate on database design or how data should be organized around user requirements. The general objective is to make information access, easy, quick, inexpensive and flexible for other users. During database design, the following objectives are concerned:y
Controlled redundancy
y
Easy to learn and use
y
More information and low cost
y
Accuracy
y
Integrity
The database file used in the system is :
Table Name: Login
This table stores the details about the login .User login table contains the fields username and password.
Field Name User Name Password
Data Type Text Text
18
Description User Name User Name
Table Name: Admin Registration
This table stores the details about the admin .Admin registration contains the fields username and password.
Field Name User Name Password
Data Type Text Text
table
Description User Name User Name
Table Name: User Registration
This table stores the details about the user registration. The User R egistration table contains the fields.
Field Name Name Age Sex Address Phone no User Name Password
Data Type Text Integer Text Text Long Long Long
19
Description User Name Age Sex Address Phone Number User Name Password
Table Name: Doctor Registration
This table stores the details about the doctor registration. The Doctor R egistration table contains the fields.
Field Name Dr name Sex Dept Consultation time Address Contact no Emergency no Consult fee Date Consultation day Tot pat
Data Type Text Text Text Integer
Description Doctor Name Sex Department Consultation Time
Text Long Long Long Date/Time Text Double
Address Contact Number Emergency Number Consultation fees Date Consultation Day Total Patient
20
Table Name: Patient Details
This table stores the details about the Patient. The Patient Details table contains the fields.
Field Name Name Age Sex Address Doctor Patient id R eg fee Admin Date R oom no
Data Type Text Integer Text Text Text Text Double Date/Time Integer
Description Name Age Sex Address Doctor Patient id R egistration fees Admitted Date R oom Number
Table Name: Medicine
This table stores the details about the medicine. The Medicine table contains the fields.
Field Name Medname Medtype Amt Expdate Stock
Data Type Text Text Double Date/Time Double
21
Description Medicine Name Medicine Type Amount Expiry Date Stock
Table Name: Discharge Sheet
This table stores the details about the discharge. The Discharge Sheet table contains the fields. Field Name Patient id Name Doctor R emark Totbill Date
Data Type Double Text Text Text Double Date/Time
Description Patient id Name Doctor R emark Total Bill Date
Table Name: Blood Bank
This table stores the details about the contains the fields.
Blood
Field Name Name Age Sex Address Phone No Blood Group
Description Name Age Sex Address Phone Number Blood Group
Data Type Text Integer Text Text Integer Text
22
donors. The
Blood Bank
table
Table Name: Eye Bank
This table stores the details about the eye donors. The Eye contains the fields.
Field Name Name Age Sex Address Phone No
Data Type Text Integer Text Text Integer
23
Description Name Age Sex Address Phone Number
Bank
table
4.4 DATA FLOW DIAGRAM
CONTEXT DIAGRAM
Controls Overall Data
Advanced
Add/Edit/Delete Data
Hospital Administrator
Management System
24
User
Level 1 DFD Administrator
Administrator
Hospital Login
Details
Management Process
Login
25
Hospital Database
Level 1 DFD User
User
Hospital Login
Details
Management Process
Login
26
Hospital Database
Patient
Level 2 DFD User
Registration
Patients
User
Login
IP/ OP
Details
Search
Login
Doctor Search
IP/OP
Doctors
Hospital
Billing
Management Login
Process
Bill
Report Generation
Add Medicine
Medicine
Change Password
TPL
Blood Bank
User
TPL
Bloodbank
Registration
Eye Bank
27
Registration
Eyebank
Level 2 DFD Admin
Add New
Admin
Admin
Admin
Add/Edit/
User
View New User Login
Details Add/Edit
Doctor
/View Doctor Login
Add /Edit/ View New
Departments
Departments
Hospital Login
Management Process
Add/Edit/View Rooms
New Rooms
TPL
Blood bank
TPL
Bloodbank
registration
Eye bank registration
28
Eyebank
4.5 SYSTEM STRUCTURE CHART Lo
in
Digital Signage
S stem Tra
Running main process
View la list
Log
Chan e assword
Add to la list
Bill
29
file entry
Delete la list item
4.7 GANTT CHART
DEC 23
JAN 10
JAN 29
FEB 13
MAR 9
APR 13
APR 26
System study Design database
Design forms
Code for application Code database part
Integrate and test
User manual and documentation
30
6. SYSTEM TESTING
Testing is a process to show the correctness of the program. Testing is needed to show completeness, t improve the quality of the software and to provide the maintenance aid. Some testing standards are therefore necessary reduce the testing costs and operation time. Testing software e xtends throughout the coding phase and it represents the ultimate review of configurations, design and coding.
Based
on the way the software reacts to
these testing, we can decide whether the configuration that has been built is study or not. All components of an application are tested, as the failure to do so many results in a series of bugs after the software is put to use. Testing involves y
Unit testing
y
Integration testing
y
Acceptance testing
The first level of test is unit testing. The purpose of unit testing is to ensure that each program is fully tested. The second step is integration testing. In this individual program units or programs are integrated and tested as a complete system to ensure that the software requirements are met. Acceptance Testing involves planning and the execution of various types of tests in order to demonstrate that the implemented software system
31
satisfies the requirements. Finally our project meets the requirements after going through all the levels of testing.
32
7.IMPLEMENTATION AND MAINTENANCE System Implementation
Implementation includes all those activities that take place to convert from the old system to the newe system.The new system may be totally new,replacing an existing system.Proper implementation is essential to provide a reliable system to meet the organization requirements.Successful implementation may not guarantee any improvement in the organization using the new system. The implementation phase includes the following tasks: y
Careful planning.
y
Investigation of the system and constraints.
y
Design of methods to achive the change over phase.
y
Training of staff in the change over phase.
y
Evaluation of change over. The method of implementation and time scale to be adapted is found out initially. Next,the system is tested properly and at the same time the users were trained in the new environment. In
Advanced
Hospital
Management
System
implementation process is successfully .We implement the systen by satisfying all the aspects of the user. All the procedure are designed to
33
minimise the users resistance to change and make a attitude for full utilization of the system.
System Maintenance
After the installation phase is completed and the user is adjusted to the changes created by the new system,evaluation and maintenance is to continue to bring the new system to the standards. If the new information is consistent
with
made.Maintenance
the
design
specification,changes
have
is
actually
the
of
implementation
to the
be post
implementation review plan. Maintenance is necessary to eliminate errors in the working system during its working life and to tune the system to any variation in its working environment.There are also some errors detected that must be corrected.The quality assurance goal is develop a procedure for corecting errors and enhancing the software.This procedure improves quality assurance by encouraging complete reporting and log of problems,ensuring that reported problems are promptly forwarded to the appropriate group of resolution. In our project if any error is reported it must be corrected.
34
8.CONCLUSION
The ADVA NCED HOSPITAL MA NAGEME NT SYSTEM is a great improvement over the manual system using case fields and paper. The computerization of the system has sped up the process. In the current system, the front office managing is very slow. The hospital managing system was thoroughly checked and tested with dummy data and thus is found to be very reliable.
35
9.FUTURE ENHANCEMENT
The proposed system is Hospital Management System. We can enhance this system by including more facilities like billing system, inpatient room allotment for the admitted patients and the stock details of medicines in the pharmacy.Providing such features enable the users to include more comments into the system.
36
10.BIBLIOGRAPHY Books y
y
A Complete
Guide
to Programming in Visual
A Complete Visual
Basic
Basic . Net
6 Training Course: How to
Programme: Package y
Advanced Programming Using Visual
y
Access 2003 Power Programming with V BA
y
Advanced MS Visual
Basic
Site Address y
www.associatedcontent.com
y
www.members.tripod.com
y
www.vbcodesource.com
37
Basic:
Version 6.0
11. APPENDIX 11.1 Screen layouts
Login
38
Doctor Registration
39
Edit Doctor
40
Add Rooms
41
Room Allocations
42
Patient R egistration
43
Doctor Search
44
IP Billing
45
OP Billing
46
Lab Billing
47