Hospital Management System Project Repor
Hospital Management System Project Repor
TAKE IT SMART (OPC) PVT.LTD is an Indian based engineering and Software Company
headquartered in Bangalore, Karnataka, India. It is both product and service oriented software company.
All offices employ an experienced team of professionals, with an outstanding track record of handling
complex web & Apps development projects.
2.1 HISTORY
The company was legally registered in the year 2021, but it made its humble beginning in the year 2018
with a team of Two members.
2.2 COMPANY STRATERGY
Purpose: To be a leader in the software Industry by providing enhanced services, relationship and
profitability.
Vision: To provide quality services that exceeds the expectations of our esteemed customers.
Mission: To build long term relationships with our customers and clients and provide exceptional
customer services by pursuing business through innovation and advanced technology.
Core values:
To incorporate good business practices in order to achieve customer satisfaction and treating the
customers with respect and faith.
To grow through creativity, invention and innovation.
To integrate honesty, integrity and business ethics into all aspects of the business functioning.
Goals:
To improve, grow and become more efficient in the field electronics engineering and software
development and develop a strong base of key clients.
To understand customer requirements and fulfill them.
Increase the assets and investments of the organization to support the development of services and
expansion of the organization.
To increase the productivity and improve the customer service satisfaction.
To do Innovations in Software field and provide quality services to deliver a range of products.
2.3 COMPANY SERVICES
TAKE IT SMART (OPC) PVT.LTD have its own services such as,
Embedded Applications development
Web design and development
IT Service
vi
Android app Development
Web Bases Software Solutions
Web Based Ads Mobile Based Services: Mobile Web Apps a. Android Apps b. Windows Apps c. IOS Apps
d. Cross Plate forms Apps
Native Apps
Hybrid apps Get trained for industry requirements while you pursuing degree The Different verticals that we
operate in are: Internship & Software Training
2.4 DOMAINS
TAKE IT SMART (OPC) PVT.LTD have working with several domains like-
IT
Digital marketing
2.5 DEPARTMENTS
Marketing: These are the main section of the market departments:
Sales department is responsible for the sales and distribution of the products to the different
regions.
Promotion department decides on the type of promotion method for the products, arranges
advertisements and the advertising media used.
Distribution department distributes the products across the industries.
Embedded System and Internet of Things (IOT) department.
Machine learning and web development department.
Business Address: Take It Smart (OPC) Pvt.Ltd
14,SGN Arcade, 1st Floor, 2nd stage, 1st Main Rd,
RPC Layout, Hoshalli Extension, Stage 1,
Vijayanagar, Bengaluru, Karnataka 560040
Mobile: +91-8050104212
Email: info@takeitsmart.in
Website: www.takeitsmart.in
Programmers and opportunities:
The Institute combines pioneering research with top class education. An innovative curriculum
allows the student flexibility in selecting courses and projects. Students, even at the undergraduate
level, get to participate in on-going research and technology development - an opportunity
unprecedented in India. As a result, a vibrant undergraduate programmer co- exists with a strong
postgraduate programmer.
vi
Methodology:
This project is to provide classifieds information. The website will provide different kinds of
facilities to the user. The user should register to utilize the site. Each user will be given UserId and
password. Using that Id and password user can enter in to the site and can put the requirement.Those
who want to view the information they can without registration. This project is implemented using
HTML,CSS,JAVAscripts and PHP as the front-end and MySQL as back-end.
WEEKLY OVERVIEW OF
INTERNSHIP ACTIVITIES
DATE DAY NAME OF THE TOPIC/MODULE COMPLETED
Day4 CSS
vi
Day5 CSS Implementation using programs
vi
DATE DAY NAME OF THETOPIC/MODULE COMPLETED
Mysql
Day11 Project Discussion & Requirements gathering
Analysis & Design, coding started
Day12 Project development, Designing of Login page,
Registration page using Bootstrapping, CSS
vi
-
vii
Learning Objectives/Internship
Objectives
Internships are generally thought of to be reserved for college students looking to gain experience in a
particular field. However, a wide array of people can benefit from Training Internships in order to
receive real world experience and develop their skills.
An objective for this position should emphasize the skills you already possess in the area and your
interest in learning more
Internships are utilized in a number of different career fields, including architecture, engineering,
healthcare, economics, advertising and many more.
Some internship is used to allow individuals to perform scientific research while others are specifically
designed to allow people to gain first-hand experience working.
Utilizing internships is a great way to build your resume and develop skills that can be emphasized in
your resume for future jobs. When you are applying for a Training Internship, make sure to highlight
any special skills or talents that can make you stand apart from the rest of the applicants so that you
have an improved chance of landing the position.
viii
Hospital Management System
AUTHENTICATION
By
This Report Presented in Partial Fulfillment of the Requirements for the Degree
of Bachelor of Science in Computer Science and Engineering
Supervised
By
2
Project Title
Approval
This project work titled “Hospital Management System”. Course Title: Project- I, Course Code:,
Submitted by:, , and This project has been approved as it is satisfied the academic requirement in
respect of minor work prescribed for B.Sc. This project is doe under the guidance of Assistant
Professor, Department of Computer Science & Engineering, Lecture, Department of computer
Science and Engineering,
Course Supervisors
........................... ....................
.......
.
i
Declaration
I hereby declare that this Project Report titled “Hospital Management System” submitted to the
Department of Computer Science and Engineering, is a record of original work done by me under
the guidance of my supervisor, Department of CSE,
This Project Report is not submitted to any other university or institution for the award of any
degree, diploma or published any time before. I also declare that there have no copy of the source
code in the project.
ii
Abstract
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 JAVA as the front-end software which is an Object Oriented
Programming 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.
iii
Acknowledgement
I would like thanks to all those who are involved in this endeavor for their kind cooperation for
its successful completion. At the outset, I wish to express our sincere gratitude to all those people
who helped me to complete this project in an efficient manner.
Also I would like to thanks to my project supervisor, Lecture, Department of computer Science
and Engineering, , who gave opportunity to do this project at an extreme organization and also
help me to complete this project. Most of all and more than ever, we would like to thanks my
family member for their warmness, support, kindness and patience. We are really thankful to all of
my friends who always advised and motivated me throughout the course.
iv
Table of Contents
Approval...........................................................................................................................................i
Declaration.......................................................................................................................................ii
Abstract...........................................................................................................................................iii
Acknowledgement..........................................................................................................................iv
List of figure.................................................................................................................................viii
Chapter One...................................................................................................................................1
Introduction..................................................................................................................................1
1.1 Problem Statement..............................................................................................................1
1.2 Objective.............................................................................................................................2
1.3 Scope..................................................................................................................................2
Chapter Two...................................................................................................................................3
Project Management.....................................................................................................................3
2.1 Project planning and scheduling.........................................................................................3
2.1.1 Methodology...............................................................................................................3
2.1.2 Project Management Life Cycle.................................................................................4
2.1.3 Project Plan.................................................................................................................5
2.1.4 Schedule Representation.............................................................................................5
2.2 Risk Management...............................................................................................................6
Chapter Three................................................................................................................................7
System Analysis...........................................................................................................................7
3.1 Background Study..............................................................................................................7
3.2 Software system attributes..................................................................................................7
3.2.1 Reliability....................................................................................................................7
3.2.2 Availability.................................................................................................................7
3.3.3 Security.......................................................................................................................7
3.3 Scope of working................................................................................................................7
3.4 Feasibility study..................................................................................................................8
3.4.1 Technical Feasibility...................................................................................................8
3.4.1 Operational Feasibility................................................................................................8
v
3.4.3 Economic Feasibility..................................................................................................8
3.4.4 Management Feasibility..............................................................................................8
3.4.5 Social Feasibility.........................................................................................................9
Chapter Four................................................................................................................................10
System Design............................................................................................................................10
4.1 Database Design...........................................................................................................10
4.2 E-R Diagram of Hospital Management System...........................................................10
4.3 Database schema of Hospital Management System....................................................12
4.4 Data Flow Diagram of Hospital Management System................................................13
4.5 User Interface...............................................................................................................15
4.5.1 Home Page................................................................................................................15
4.5.2 Admin Login page....................................................................................................16
4.5.3 Admin user details page............................................................................................17
4.5.4 Appointment History page........................................................................................18
4.5.5 User (Patient) log in page.........................................................................................19
4.5.6 User account create page..........................................................................................20
4.5.7 User details page.......................................................................................................21
4.5.8 Doctor Login page....................................................................................................22
Chapter Five.................................................................................................................................23
System Implementation..............................................................................................................23
5.1 Implementation............................................................................................................23
5.2 Implementation Environment......................................................................................23
5.3 Functional Requirement...............................................................................................24
5.3.1 Administrator Interface.............................................................................................24
5.3.2 User Interface............................................................................................................24
Chapter Six..................................................................................................................................25
System Testing...........................................................................................................................25
6.1 Integration Testing.......................................................................................................25
6.2 Unit Testing.................................................................................................................25
vi
6.3 System Testing.............................................................................................................25
6.4 Acceptance Testing......................................................................................................25
6.5 Recovery Testing.........................................................................................................26
6.6 Functional Testing.......................................................................................................26
6.7 Hardware/Software Testing.........................................................................................26
6.8 Security Testing...........................................................................................................26
6.9 Advantages...................................................................................................................26
Chapter Seven..............................................................................................................................27
Conclusion..................................................................................................................................27
7.1 Conclusions..................................................................................................................27
7.2 Limitations of the system.............................................................................................27
7.3 Future plan...................................................................................................................27
REFERENCES...............................................................................................................................28
vii
List of Figures
Figure No Figure Name Page No.
1. Waterfall model................................................................................................................4
2. Gantt chart........................................................................................................................5
3. E-R Diagram of Hospital Management System.............................................................11
4. Database schema of Hospital Management System.......................................................13
5. Data flow diagram of Hospital Management System....................................................14
6. Home page......................................................................................................................15
7. All ads page....................................................................................................................16
8. Admin Login page..........................................................................................................17
9. Appointment History page.............................................................................................18
10. User (Patient) log in page...............................................................................................19
11. User account create page................................................................................................20
12. User details page............................................................................................................21
13. Doctor Login page..........................................................................................................22
viii
Chapter One
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
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 activities like Room
activities, Admission of New Patient, Discharge of Patient, Assign a Doctor, and finally compute
the bill etc. I have tried my best to make the complicated process Hospital Management System
as simple as possible using Structured & Modular technique & Menu oriented interface. I have
tried to design the software in such a way that user may not have any difficulty in using this
package & further expansion is possible without much effort. Even though I cannot claim that
this work to be entirely exhaustive, the main purpose of my exercise is perform each Hospital’s
activity in computerized way rather than manually which is time consuming.
I am confident that this software package can be readily used by non-programming personal
avoiding human handled chance of error.
1.2 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.
1.3 Scope
The proposed software product is the Hospital Management system (HMS). The system will be
used in any hospital, clinic, dispensary or pathology labs. Clinic, dispensary or pathology to get
the information from the patients and then storing that data for future usages. The current system
in use is a paper based system. It is too slow and cannot provide updated lists of patients within
reasonable timeframe. The intention of the system is to reduce over-time pay and increase the
number of patients that can be treated accurately. Requirement statements in these documents are
both functional and non-functional.
2
Chapter Two
Project Management
2.1 Project planning and scheduling
Project planning is part of project management, which relates to the use of schedules such as
Gantt charts to plan and subsequently report progress within the project environment. Initially, the
project scope is defined and the appropriate methods for completing the project are determined.
Following this step, the durations for the various tasks necessary to complete the work are listed
and grouped into a work breakdown structure. The logical dependencies between tasks are
defined using an activity network diagram that enables identification of the critical path.
2.1.1 Methodology
We have used Iterative and Incremental Development model (IID) for our project development.
This development approach is also referred to as Iterative Waterfall Development approach.
Iterative and Incremental Development is a software development process developed in response
to the more traditional waterfall model. This model is designed to take care of such big project.
The large and complicate project chiefly demand better development and testing procedure. The
waterfall model is well known for its repeated testing process. Hence I choose the waterfall
model for developing my software.
4
2.1.3 Project Plan:
Once we examine that the project is feasible, I undertake project planning. The table below
describes how we planned my project.
5
2.2 Risk Management
Software Risk Management is a proactive approach for minimizing the uncertainty and potential
loss associated with a project. Some categories of risk include product size, business impact,
customer- related, process, technology, development environment, staffing (size and experience),
schedule, and cost. Risk Management is a practice with processes, methods, and tools for
managing risks in a project.
Risk identification is a systematic attempt to specify threats to the project plan. By identifying
known and predictable risks, we can take a first step toward avoiding them when possible and
controlling them when necessary. To perform the risk identification, we categorized the risk into
different categories as:
1. Project Risk
2. Technical Risk
3. Business Risk
4. Known Risk
5. Predictable Risk
6. Unpredictable
6
Chapter Three
System Analysis
Before designing any system it is important that the nature of the business and the way it
currently operates are clearly understood. The detailed examination provides the specific data
required during designing in order to ensure that all the client's requirements are fulfilled. The
investigation or the study conducted during the analysis phase is largely based on the feasibility
study. Rather it would not be wrong to say that the analysis and feasibility phases overlap. High-
level analysis begins during the feasibility study. Though analysis is represented as one phase of
the system development life cycle (SDLC), this is not true. Analysis begins with system
initialization and continues until its maintenance. Even after successful implementation of the
system, analysis may play its role for periodic maintenance and up gradation of the system. One
of the main causes of project failures is inadequate understanding, and one of the main causes of
inadequate understanding of the requirements is the poor planning of system analysis.
2
3.4 Feasibility study
3.4.1 Technical Feasibility: This is concerned with specifying equipment and software that will
successfully satisfy the user requirement; the technical needs of the system may vary
considerably, but might include:
3.4.2 Operational Feasibility: It is mainly related to human organization and political aspects.
The points to be considered are:
3.4.3 Economic Feasibility: Economic analysis is the most frequently used technique for
evaluating the effectiveness of a proposed system. More frequently known as cost/benefit system
and compare them with costs. If benefits outweigh costs, a decision is taken to design and
implement the system.
3.4.5 Social Feasibility: Social feasibility is a determination of whether the project will be
acceptable to the people or not. This determination typically examines the probability of the
project accepted by the group directly affected by the proposed system change.
Chapter Four
System Design
4.1 Database Design
Database design is the process of producing a detailed data model of database. This data model
contains all the need logical and physical design choices and physical storage parameters needed
to generate a design in a data definition language, which can then be used to create a database. A
fully attributed data model contains detailed attributes for each entity.
The term database design can be used to describe many different part of the design of an overall
database system. Principally, and most correctly, it can be thought of as the logical design of the
base data structure used to store the data. In the relational model these are the tables and views.
In an object database the entities and relationships map directly to object classes and named
relationships. However, the term database design could also be used to apply to the overall
process of designing, not just the base data structure, but also the forms and queries used as part
of the overall database application within the database management system.
Patient Admit
information
Room
24
4.3 Database schema of Hospital Management System
A database schema is the skeleton structure that represents the logical view of the entire database.
It defines how the data is organized and how the relations among them are associated. It
formulates all the constraints that are to be applied on the data.
List of table:
1. admin
2. Users
3. Patients
4. Physician
5. Services
6. Transactions
7. user_details
8. Room
9. Discounts
10. Appointment
11. Doctors
12. Doctor specialization.
25
Fig.4.2: Database schema of Online Marketplace
26
Fig. 4.3: Data flow diagram of online marketplace
27
4.5 User Interface
4.5.1 Home Page
Actor: Any users
28
4.5.2 Admin login page
Actor: Admin users
Output: Uttara Medical Center
29
4.5.3 Admin user details page
Actor: Admin users
Output: Admin details page
30
4.5.4 Appointment History page
Actor: Admin users
Output: Appointment History.
Flow:
1. Admin user can browsers this page.
2. Admin user can view all appointment history.
31
4.5.5 User (Patient) login page
Actor: User.
Input: User email and Password
Output: User profile page.
Flow:
(1) User Logs in with user email and password.
Alternate Flow:
(1) If the user email is wrong then it is asked to login again.
(2) If the password is wrong then the user is asked to enter again.
32
4.5.6 User account create page
Actor: User.
Input: User name, email, password and confirm password.
Output: Create a new user and show user profile page.
Flow:
(1) Password must be more than 8 cheater.
(2) Password and confirm password must be same
Alternate Flow:
(1) If the mandatory fields are not fill up then alert is shown.
(2) If password less than 8 cheater or password and confirm password not match alert is
shown.
33
4.5.7 User Details page
Actor: User.
Flow:
(1) User must be fill up all input field.
Alternate Flow:
(1) If the mandatory fields are not fill up then alert is shown.
34
4.5.8 Doctor Login page
Actor: User.
Flow:
(1) User Logs in with user email and password.
35
Chapter Five
System Implementation
5.1 Implementation
Implementation is the process of having system personal check out and provides new
equipment’s into use, train the user to install a new application and construct any files of data
needed to use it. There are three types of implementation. Implementation of computer system to
replace a manual system. To problem encountered are covering files, training user, creating
accurate files and verifying print outs for integrity. Implementation of a new computer system to
replace an existing one. This is usually difficult conversion. If not properly planned, there can be
many problems. So large computer system many take as long as a year to convert.
Implementation of a modified application to replace the existing one using the same computer.
This type of conversing is relatively easy to handle, usually there are no major change in the file.
Our project is yet to be implemented.
The implementation environment of the developed system facilitates multiple users to use this
system simultaneously. The user interfaces are designed keeping in mind that the users of this
system are familiar to using GUI-based systems. Thus, we restricted ourselves to developing a
GUI-based system so that it becomes easier for the end user to get acquainted to the developed
system.
36
5.3 Functional Requirement
This system interface is divided into two section
1. Administrator interface.
2. Users interface.
37
Chapter Six
System Testing
6.9 Advantages
The software helps to handle the entire administration of hospitals and healthcare facilities.
Typically, such a software includes various modules that help doctors manage their assignments
and schedules, carry out patient registration, maintain store inventory records, keep track of
medicine, administration, maintain blood bank (with available blood type) details, individual
record of patients with their test reports, nursing and housekeeping service details, financial
information, including final billing & payments, insurance details and much more. After the
customized software is implemented and integrated into the system, patient care and hospital
administration becomes an easy job.
26
Chapter Seven
Conclusion
7.1 Conclusions
This project has been a rewarding experience in more than one way. The entire project work has
enlightened us in the following areas.
a) We have gained an insight into the working of the HOSPITAL. This represents a typical real
world situation.
b) Our understanding of database design has been strengthened this is because in order to
generate the final reports of database designing has to be properly followed.
c) Scheduling a project and adhering to that schedule creates a strong sense of time management.
d) Sense of teamwork has developed and confidence of handling real life project has increased
to a great extent.
e) Initially, there were problem with the validation but with discussions, we were to implement
validations.
27
7.3 Future plan
o Diagnostics billing system.
28
References
[1] Deepak Thomas ”͞ Beginning PHP 4 Databases”, Wrox Press Ltd. Paperback-17,
October, 2002.70-130 pp.
[2] Matt Doyle, “Beginning PHP 5.3, 2ndedition”, October 2009. 150-270 pp.
[3] ͞ HP and MySQL Web Development, 2nd
Luke Welling, Laura Thomson. Sams P
edition, Paperback- 20 February, 2003. 105-209 pp.
[4] W. Jason Gilmore “Beginning PHP 5 and MySQL 5 from Novice to Professional SECOND
EDITION”, Jul 9, 2008.100-150 pp.
[5] Abraham Silberschatz, Henry F. Korth and S. Sudarshan “Sixth Edition Database
System Conceptsreleased”, January 28, 2010. 206-253 pp.
[6] Server-Side Scriptinghttp://php.net/manual/en/index.php, Last accessed on 12/15/2017at
2:33pm
[7] HTML &CSS https://www.w3schools.com/, Last accessed on 10/21/2017at 1:33pm.
[8] Bootstraphttp://getbootstrap.com/, last accessed on 09/30/2017at 10:10pm.
[9] https://stackoverflow.com/, last accessed on 11/07/2017 at 2:20am.
28