Download Hospital Management System: A Proposed Automated System for Medical Institutions and more Study Guides, Projects, Research Computer Science in PDF only on Docsity!
EXECUTIVE SUMMARY
Hospital Management System provides the benefits of streamlined operations, enhanced administration & control, superior patient care, strict cost control and improved profitability. HMS is powerful, flexible, and easy to use and is designed and developed to deliver real conceivable benefits to hospitals. More importantly it is backed by reliable and dependable support.
The project ‘Hospital Management System’ is based on the database, object oriented and networking techniques. As there are many areas where we keep the records in database for which we are using MY SQL software which is one of the best and the easiest software to keep our information. This project uses HTML CSS as the front-end software and has connectivity with MY SQL.
Hospital Management System is custom built to meet the specific requirement of the mid and large size hospitals across the globe. All the required modules and features have been particularly built to just fit in to your requirement. This package has been widely accepted by the clients in India and overseas. Not stopping only to this but they are highly satisfied and appreciating. Entire application is web based and built on 3 tier architecture using the latest technologies. The sound database of the application makes it more users friendly and expandable. The package is highly customizable and can be modified as per the needs and requirements of our clients. Prolonged study of the functionalities of the hospital and its specific requirement has given it a wonderful shape both technically and usability wise. It covers all the required modules right from Patient Registration, Medicine details, Doctor, Wards, , Admin, Store, Patient appointment, bill payment, record modification, discharge details etc.
Introduction
Human Body is a very complex and sophisticated structure and comprises of millions of functions. All these complicated functions have been understood by man him, part-by-part their research and experiments. As science and technology progressed, medicine became an integral part of the research. Gradually, medical science became an entirely new branch of science. As of today, the Health Sector comprises of Medical institutions i.e. Hospitals, HOSPITALs etc. research and development institutions and medical colleges. Thus the Health sector aims at providing the best medical facilities to the common man.
Medical Institutions in India
Still being a developing nation India has seen a tremendous growth of the Health sector in the field of research as well as in the field of development of numerous large and small scale Hospital institutions still lacking in inter-structure facilities. Government of India has still aimed at providing medical facilities by establishing hospital. The basic working of various hospitals in India is still on paper as compared to hospitals in European countries where computers have been put in to assist the hospital personals their work. The concept of automation of the administration and management of hospital is now being implemented in India also, with large hospitals like APPOLO and AIIMS in Delhi, ESCORTS in Chennai, having automated their existing system.
Our project is based on the above concept i.e. automation of Administration and Management of Hospital. The project has been developed keeping in-view the following aspects: - (i) Working environment of the Hospital. (ii) The thought-process and attitude of Indian people. (iii) The literacy rate of India. (iv) The Existing system, being used in the majority of Hospitals. (v) The availability of Infra-structural facilities likes finance, skilled personals, and working environment.
DEFINITION OF PROBLEM
Since HOSPITAL is associated with the lives of common people and their day-to-day routines so I decided to work on this project. The manual handling of the record is time consuming and highly prone to error. The purpose of this project is to automate or make online, the process of day-to day
- Problem of Accuracy: There are too many mistakes in reports.
- Problem of timeliness: In the current system the reports and output produced is mostly late and
in most of the cases it is useless because it is not on time.
- Problem of Validity: The output and reports mostly contains misleading information. The
customer's information is sometimes not valid.
- Problem of Economy: The current system is very costly. We have to spend lots of money to
keep the system up and going, but still not get the desired results.
- Problem of Capacity: The current system is suffering from problem of capacity also. The staff
for organization is very less and the workload is too much. Few peoples cannot handle all the work.
PROPOSED SYSTEM
l. Employee Details: The new proposed system stores and maintains all the employees details.
2. Calculations: The new proposed system calculates salary and income tax automatically and it is very fast and accurate. 3. Registers: There is no need of keeping and maintaining salary and employee register manually. It remembers each and every record and we can get any report related to employee and salary at any time. 4. Speed: The new proposed system is very fast with 100% accuracy and saves time. 5. Manpower: The new proposed system needs less manpower. Less people can do the large work. 6. Efficiency: The new proposed systems complete the work of many salesperson in less time. 7. Past details: The new proposed system contains the details of every past doctor and patients for future assistance.
8. Reduces redundancy: The most important benefit of this system is that it reduces the redundancy of data within the data. 9. Work load: Reduces the work load of the data store by helping in easy updates of the products and providing them with the necessary details together with financial transactions management. 10. Easy statements: Month-end and day-end statement easily taken out without getting headaches on browsing through the day end statements.
Objective
Hospital are the essential part of our lives, providing best medical facilities to people suffering from various ailments, which may be due to change in climatic conditions, increased work-load, emotional trauma stress etc. It is necessary for the hospitals to keep track of its day-to-day activities & records of its patients, doctors, nurses, ward boys and other staff personals that keep the hospital running smoothly & successfully.
But keeping track of all the activities and their records on paper is very cumbersome and error prone. It also is very inefficient and a time-consuming process Observing the continuous increase in population and number of people visiting the hospital. Recording and maintaining all these records is highly unreliable, inefficient and error-prone. It is also not economically & technically feasible to maintain these records on paper.
Thus keeping the working of the manual system as the basis of our project. We have developed an automated version of the manual system, named as “ADMINISTRATION SUPPORT SYSTEM FOR MEDICAL INSTITUTIONS”.
The main aim of our project is to provide a paper-less hospital up to 90%. It also aims at providing low-cost reliable automation of the existing systems. The system also provides excellent security of data at every level of user-system interaction and also provides robust & reliable storage and backup facilities.
A Hospital is a place where Patients come up for general diseases. Hospitals provide facilities like:-
Consultation by Doctors on Diseases. Diagnosis for diseases.
a) Admission of New Patient
- Free Medical Advice For the Patients
- Discharge Detail Functions b) Discharge of Patient c) Doctor Assigning related to Patient’s Disease
- Training Courses Provided by the Hospital
- Statement of Patient Details
- Admitted Patient
- Discharged Patient
- Doctor Details
- Total number of Patients admitted in the Hospital
- Doctors available in the Hospital
- Preventive Health Checkups
- Administrator Links a.Login Form b.To add new doctors in the site c.List of patients d.List of Doctors
HARDWARE
Processor : Pentium 2.4 GHz or above
Memory : 256 MB RAM or above
Cache Memory : 128 KB or above
Hard Disk : 3 GB or above [at least 3 MB free space required]
Pen Drive : 5 GB
Printer : Laser Printer
SOFTWARE
Operating System : Windows XP (Professional).
Font-End Tool : PHP, HTML, Java Script,CSS
Back-End : My Sql
FRONT END
We have implemented JavaScript for all the Client side validations. Client side JavaScript is designed to reside inside HTML document & ensure they run properly. It is object based, event driven, platform independent. These are important parts of any Web application to implement Client side Validations and the invalid data is not submitted. The form is not submitted until user fills in correct data. It is extremely useful to restrict mistakes by user.
BACK END
We have used My Sql. My Sql provides efficient/effective solution for major database tech.
- Large database and space management.
- Many concurrent database users.
- High transaction processing requirement
- High Availability
- Industry accepted standards
- Manageable security
- Portability
IDENTIFICATION OF NEED
I have designed the given proposed system in the PHP to automate the process of news sites. Many different people use Usenet, for many different reasons, ranging from discussions of various topics, requests for help or to trade media, which is often seen as the ‘dark side’ to Usenet — the abuse of public news groups to trade copyrighted or offensive material. Thankfully however, those that use Usenet responsibly far out weight the few who use it as a tool for piracy etc.
Many of the people using and contributing to Usenet are people who work with computer technology. These people often use Usenet to seek help with a piece of software or suggest
The module is operated on by the operational level user. The module receives input from the patients, which includes their details. System will record these details & generate a OPD No. and list of Doctors available in OPD on that day. The output generated is the OPD Card No and patient is directed to the required Doctor with that card. The revenue generated from OPD is recorded & updated in the Master Revenue Database after every 24 hours.
Admission Registration Process :-
This module receives input from two areas:-
(i) From the patient himself who has to get admitted to the Hospital. This process record patient details and issues a Admission No. .This no. is used as reference in other modules. The module generates a admission slip as the output indicating the ward & Bed allotted to the patient.
(ii) The record input is received from the OPD Registration module, if the OPD Doctor recommends patient for immediate admission to the hospital. The Card No. taken as reference so that patient details do not required entering again. The card no is now replaced by the admission no. and output generated is same as in the case (i).
Duty Allocation Process :- This module is operated by the super user in collaboration with top management who together build-up the schedule for all employees of the Hospital. The process receives input from the employee Master database and the process prepares schedule for a period. The output of the process is the schedule report for the period in the consideration.
Financial Activity Process :- This process receives two types of inputs:- (iii) First input, which is received, is for the Patient. It receives input from the admission- registration module, and test & treatment-undertaken module, as well as the patient master database. It records & process all the financial transactions taken place between the hospital and the patient and generates the final bill as the output. (iv) Second input, which is received, is for the employees of the hospital. It receives input from the duty allocation process and the employee database for the preparation of a
salary-slip. The module records & processes various calculations and generates the salary-slip as the output. Test and Treatment Undertaken Process :- This module receives input in the form of prescription written by the doctor for the types of tests and treatment to be undertaken by the patient. It records and process, the various details about the test and generates the lab-report as the output of the module. It also generates the receipt for the tests undertaken. These receipts serve as one of the input to the financial-activity module.
Medical supply Process: - This module is fairly independent of the other modules. It maintains the inventory of the various medicines. It takes input in the form of prescription and generates output in the form of bill containing the number of medicines purchased and their respective rates, along with the total amount to be paid by the patient. The module also maintains a database of the medicines and provides a check for their availability and non-availability. In case of low inventory of any medicine, a message is sent to the hospital, which replenishes the inventory-level of that medicine.
Maintenance Process: -
This module is the most important module. It receives input from every other module of the system, and its functionality is to maintain the working and processing of other modules as well as the maintenance of the various databases. Thus, it aims at the overall maintenance of the whole system.
DFD for patient Appointment
Database
USER
1. Read patient request _2. Search from Doctor Data base
- Give the Time and Number_
Output UNIT
DFD for Patient Search
Database
Patient (^) 1. Read the Data from patient
2. Search the _patient in patient-ID
- Copy Selected Record_
Output Unit
DFD For Login Of User
User^ Data Base
Read User Id & Password
Authenticate User & Login
Output
DATA FLOW DIAGRAM ADMISSION OF A NEW PATIENT
FILE
Patient Details
Process
Update Table
PATIENT
1 Admitted
1.1 Display Form
1.2 Get Details
Assigning a Doctor
Update
Address Char (30) Not null Date_of_join Date Not null Desgination Not null
OPD_master
Field Type Constraint Name Char (30) Not Null Card_no Char (30) Primary key Patient_name Char (30) Not null Gender Char (30) Not null Age Numeric Not null Address Char(60) Not null Phone Numeric Not null Rel_name Char (30) Not Null Date Date Not null Dr_unit Char (30) Not null Days Char(60) Not null Dep_name Char (30) Not null
Test_details
Field Type Constraint Receipt_no Char(30) Primary key Patient_id Char (30) Not null Name Char (30) Not null Date Date Not null Report Char (60) Not null
Feedback Field Type Constraint Name Char (30) Not Null Email Id Char (30) Not Null Phone Char (30) Not Null State Char (30) Not null Comment Char (60) Not null
TESTING PHASE
One of the purposes of the testing is to validate and verify the system. Verification means checking the system to ensure that it is doing what the function is supposed to do and Validation means checking to ensure that system is doing what the user wants it to do. No program or system design is perfect; communication between the user and the designer is not always complete or clear, and time is usually short. The result is errors and more errors. Theoretically, a newly designed system should have all the pieces in working order, but in reality, each piece works independently. Now is the time to put all the pieces into one system and test it to determine whether it meets the user's requirements. This is the best chance to detect and correct errors before the system is implemented. The purpose of system testing is to consider all the likely variations to which it will be subjected and then push the system to its limits. If we implement the system without proper testing then it might cause the problems.
- Communication between the user and the designer.
- The programmer's ability to generate a code that reflects exactly the system specification.
- The time frame for the design.
Theoretically, a new designed system should have all the pieces in working order, but in reality, each piece works independently. Now is the time to put all the pieces into one system and test it to determine whether it meets the requirements of the user. The process of system testing and the steps taken to validate and prepare a system for final implementation are:
LEVELS OF TESTING:
The different types of testing are as follows:
UNIT TESTING VALIDATION INTREGRATION N SYSTEM
