Clinical Management System Project Docum
Clinical Management System Project Docum
college
Department of “ICT”
PROJECT PROPOSALFOR:-
CLINICAL MANAGEMENT SYSTEM
preparede by:-
1. Abebaw Israel
2. Markos Eyasu
3. Yemisrach Paulos
4. Melese Sorato
1
CHAPTER 1:
Introduction
In the era of technology, where everything needs to be done efficiently and effectively the
existences of Clinic Management System (CMS) become necessary. The used of CMS can
enhance the services and also the work flow of all activity that happens in clinic where it
helps in reducing the workload of medical staff, the number of man power needed and it also
make clinical management become more manageable and easier to control.
The Clinical Management System is a windows-based software designed for registration and
management of patient’s records and easy access of the records. The system will be used to
assist the register, doctors, lab technicians and chemists to store and manage patient records
in a hospital or clinic for easier access and reference. All these activities are done routinely
and would be cumbersome on the employees if done manually hence need of an efficient
easy to use management software that will help ease the workload on employees in the
clinic/hospital.
Currently, there is a huge number of private and public hospitals that keep their patients
records in books and store them manually. it’s a very formal way of storing data and records
but the demerit of storing data in this manner is poor handling of the books may lead to lose
of data , the books are not that much secure and are easily perishable furthermore books have
no back up once lost cannot be retrieved. Applying this system in such institutions will help
manage these records and preserve the information for longer periods of time and also make
its access far much simpler and easier, it also ensures accuracy and openness of the patient’s
details / records.
2
1.1 Problem statement.
In our country, most clinics and hospitals have not embraced the new technologies that can
improve their management and also profits.as a result, most of them use analogue systems to
capture and manage data.
Large space usage. Use of paper to record data requires large space for storage over time.
This can be seen in many places where analogue systems are in use.
Inefficient back up methods. Old systems especially that which are analogue do not provide
effective ways to back up data and as a result data can be permanently lost in the event data is
damaged or misplaced. This may lead to the collapse of the institution.
.Analogue systems do not allow efficient supervision of its users and thus employees are
likely to commit fraud undetected and get away with it.
Employees are the core entity in ensuring maximum and sufficient service. The problem is in
the supervision, where employees are bound to get away with anything without the
institution’s notice. The new system will have a record of all stake holders involved in the
institution, including employees. This will establish a clear strategy that will ensure easy
employee supervision.
Since a single system will be set to monitor and process loads of the institution’s operation,
this will cut down on the unnecessary spending. The rest of the capital will help in improving
the institution facilities and other amenities.
3
1.3.1 Reduce cost.
Reducing operational cost. Our project aim is to come up with a software product that
will reduce the operational costs of a business. There will be no use of purchasing
stationery and hence reduced operational costs.
Curbing fraud by the employees. Our software will enable effective employee
supervision and stringent measures that will hinder office fraud.
Reducing errors. Our software will provide proper validation techniques that will
collectively reduce errors done when recording data.
It will improve customer relations. My software’s final aim is to improve the patients
experience by enabling an easy environment to operate in and hence the patient’s
satisfaction is achieved leading to more patients and higher revenue.
Enabling ease of access to information concerning each patient and their pervious records
thus guaranteeing efficiency and effectiveness.
No money was allocated for the project and this may to some extend limit the product
scope.
4
1.5 CONTEXT MODEL: SCOPE
Clinic
Administrators
Clinical
Common
Manageme
Database with
nt Member Sign Up
Doctors details,
System
staff details and
patients details. Member Login
and Profile View
Browse Through
Clinical System
Send Application
1.6 Input and Output data. for booking
1.6.1 Inputs
Patients Details
Doctors Details
Diagnosis
Quantity carried
1.6.2 Outputs
Prescription
Drug Quantity
Referral if required
Clinical management system will make it easier for hospital to get accessed to his
employees
Reduce the cost of paper usage (books) and embrace digital way
Reduce the clashing time by drivers since booking is online
5
Management of the hospital will be easy.
Allow the administrator to update all the information concerning the system
a)Hardware functions
The keyboard will be used to enter all kind of data into the system
The display unit will allow the administrator/users of the system to view information
The hard disk will be used to store information
a) Patients’ functions
Patients will be required to sign up first then log into the system
Provide their information and details to be feed into the system
6
CHAPTER 2:
2.0.1 Introduction
In this section we study the past, present and future problems in hospital management. The
main source of information was the people the school clinic and so we asked our fellow
students what they might know about the problem. The internet was also very crucial as a
source of information because of the vast amount of data found there and other trustable
sources.
Methodology: To get the best information we searched the internet for information
concerning the problem.
There are many clinics and hospitals in Tarcha today. The hospitals are divided into
different categories depending on the level and quality of service offered in the hospital.
These are the two main categories of clinics/hospitals in Tarcha.
Private
Public (Government hospitals)
LITERATURE REVIEW
Nowadays, the current Clinic management system that are available had not been widely
used. This is because the process of task that occurred in hospitals is quiet complex compared
to other organization. The other reason is that, most of existing system does not full fill the
requirements of doctor and other medical staff in our country.
Registration in hospitals, the processes of works to be done are vary. In current system that is
being used in clinic or hospital of tarcha where the case study has been done, all tasks are
done manually.
Before a patient can received a treatment from doctors, first of all, they need to register.
The person who is in charge in registration process must make sure either the person had ever
received a service from the hospitals or not ,lf the person had been received treatments from
the hospitals, then attendance are responsible to find back their file where a details of that
particular person had been kept.
In registration process, usually the person in charge is someone who works under
administrator department, this responsible person will hand out a form to be filled by patients
who wish to receive a treatment in Outpatient Department.
Patients need to give details about themselves In some cases, patient come to the clinic with
serious injured and because of this, patient sometimes are not able to fill in the form
themselves so someone need to fill in the form for them, before they are allow to receive a
7
treatment from Outpatient Department .Because of this scenario, sometimes the details that
had been given are not correct So whenever patient are available to do
it themselves they need to-register again, and this lead to a data redundancy, time wasting and
also and additional workload for hospital staff especially the registrar.
They need to find out the previous details about the patients which are incorrect in the archive
where, in archive, it contains thousands of files on patient's details.
Here is a list of problems that people who works in hospitals are facing:
(i) The manual registration process leads to data redundancy and also gives an
additional workload to the person who is in charge .Because if the patients have
received treatment from the clinic before, then they need to find back the details
on that particular patient in the archive.
(ii) From the research, by interviewing the medical staff, and also people who work
under this organization they feel that they are under staffed and need more
workers this also poses a problem in the Universities’ financial department as it’s
supposed to pay all the workers.
(iii) Miss handlement of the patients records and privacy , students private
information can be easily access by anyone
(iv) There is no data backup. Once data about a patient is lost it cannot be easily
recovered or be recovered at all
8
CHAPTER 3
I. Recognition of need:- It is the first stage of information system development cycle. The
preliminary investigation must define the scope of the project and the perceived constrains,
opportunities and directives that triggered the project. As for Clinical Management System, I
collected the system requirements through questionnaires and interviewing student and the staff and
the problem they face when they visit the universities Clinic. I happen to find the following:
The goal of a feasibility study is to evaluate alternative system and to purpose the most
feasible and desirable system for development.
9
I addressed five types of feasibility study in my research, they include the following.
Time Feasibility:-Being a small system and given the period of three months of
development, it is time feasible.
Time Feasibility:-The system is a small one and hence the time frame of three months
allocated for development is enough hence there is time feasibility. From the above we choose
to use a network based database system because as compared to the other strategies, it more feasible.
It will contain an interface that is distributed in the network and is connected to a central data-base.
Feasibility study involve cost/benefit analysis. In the process , the cost and benefits are estimated with
greater accuracy. If cost and benefit should be quantified to make a good system that is affordable.
10
Analysis
Analysis starts with systems request that describes the problems or desired changes in the system. It
identifies the nature and scope of the business opportunity and problem by performing a feasibility
study
Design
The Design phase creates a blueprint for the new system that will satisfy all documented
requirements. It identifies all necessary outputs, inputs, interfaces and processes. Designs internal and
external controls that will ensure:
Reliability
Security
Maintainability
Accuracy
The design is documented in the systems design specification and presented to the management and
users for their review and approval. The involvement of Management and users is to avoid any
misunderstanding about what the system will do, how it will do it and how much it will cost.
i) Implementation
In the implementation phase, the new system is constructed by the programeers and designers and
finally given to the final user.After implementation data is converted into system files,users are
trained, and the actual transition to the new system is undertaken.
A Systems Evaluation is later done to determine If the systems operates properly and if the cost of the
system and benefits are within expectations
During this phase the IT department and staff maintains (corrects the errors and adapt to changes in
the environment ) and enhances the system. Enhancements provide a maximized return on IT
investments
11
This document describes the data that will be processed by the Clinical management System and the
functions that will be performed on the data. The Entity Relationship Diagram (ERD) and data dictionary
will show data processed by the software while the Data Flow Diagrams (DFDs) will describe the functions
that will process the data.
Identification of the user and the application: The clinic Management users are;
o Doctor,
o Lab technician,
o The patients.
Entity 1: Registration (Reg No, Name, Date of Birth, Course, Date of Registration, Card No, Lab Form
No, Prescription Form, drug name, Quantity )
Entity 2: Diagnosis ( Reg No, Doctor’s Name, Doctors No, Date of Diagnosis, Lab technicians Name,
Lab Technicians No, Brief History )
Doctor Diagnosis
Description
12
Entity 3: Prescription
Prescription Details ( Lab Form No, Prescription Form No, Drug Name, Quantity, and Doctor’s No)
Prescription Patients
Drug Doctor
Entity 4: Laboratory
Lab (Lab form No, provisional Diagnosis, Card No, Reg No, Tech No)
Lab Patient
Lab findings
Tech Details (provisional diagnosis)
13
Entity 5: Referral
Referral (Ref No, Reg No, Patient’s Name, Doctor’s No, Doctor’s Name, Date of Referral, Reason for
Referral, Hospital Referred to, Referred to Doctor’s Name
14
CHAPTER 4;
4.0 METHODOLOGY
4.1 Introduction
-A project design is an organized plan to study a scientific problem. The design of a study
defines the study type (descriptive, co-relational, semi-experimental, experimental, review)
and sub-type (e.g., descriptive-longitudinal case study), research question, hypotheses,
independent and dependent variables, experimental design, and, if it can be applied, data
collection methods and a statistical analysis plan.
I decided to use the waterfall model in my system design which will be implemented as
follows:
15
4.2 Software project plan
Analysis
Design
Implementation
and coding
Testing
Maintenance
16
i. Phase dependent tools techniques and notations
To develop software requirements specifications, architectural and detailed design and the
source code the following tools may be used:
Automated tools
Specialized notations
Modern techniques
To perform unit testing, system testing and acceptance testing automated testing tools may be
used.
Other tools and techniques may be used to track and control progress can be included:-
1. Discussing the different solution strategies lay down above (Network based system,
Stand-alone system approach and the Database centered application).
2. Determining the best/appropriate solution strategy among those discussed above for
the system.
Requirements
o Elicit requirements
o Analyze Requirements
o Build requirement documents
o Review requirements
Design
Implementation
17
Implement clinic management system data entry Windows.
Implement module/sections of the clinic management system
Testing
a) Unit testing
b) Integrated testing
Delivery
Train staff
Deliver documentation
Internet Connection
18
4.2 3 Deliverable
The final system that will be delivered at the completion of the project will contain
the following:
1. A complete working website with a Login (authentication) system.
2. A documentation on the use of the system.
Table 1: Schedule.
Table 2: Budget.
19
Item Description Amount (KSHS)
20
independent variable is administered to the experimental group and not to the control
group, and both groups are measured on the same dependent variable. Subsequent
experimental designs have used more groups and more measurements over longer
periods. True experiments must have control, randomization, and manipulation.
Exploratory design-An exploratory design is conducted about a research problem
when there are few or no earlier studies to refer to. The focus is on gaining insights
and familiarity for later investigation or undertaken when problems are in a
preliminary stage of investigation.
Observational design-This type of research design draws a conclusion by
comparing subjects against a control group, in cases where the researcher has no
control over the experiment. There are two general types of observational designs. In
direct observations, people know that you are watching them. Unobtrusive measures
involve any method for studying behavior where individuals do not know they are
being observed. An observational study allows a useful insight into a phenomenon
and avoids the ethical and practical difficulties of setting up a large and cumbersome
research project.
Longitudinal design-longitudinal study follows the same sample over time and
makes repeated observations. With longitudinal surveys, for example, the same
group of people is interviewed at regular intervals, enabling researchers to track
changes over time and to relate them to variables that might explain why the changes
occur. Longitudinal research designs describe patterns of change and help establish
the direction and magnitude of causal relationships. Measurements are taken on each
variable over two or more distinct time periods. This allows the researcher to
measure change in variables over time. It is a type of observational study and is
sometimes referred to as a panel study.
-Among the research designs listed above, I chose to use a combination of case study,
observational, historical and experimental design. This is because of the following
advantages of the combination.
Using observational design we was able to see how the clinic management system will be
handled by the end user (administrator)..
1. With historical design, I was able to collect data about similar systems that
exist. The data I collected is valid and authentic because these systems are real
and used in some Kenya by some hospitals and clinic.
2. Both of these methods are cheap and we can afford to use them with
employment of few resources available at the moment.
3. The two approaches are both efficient and with less effort getting the final
result is possible.
4.5 Research methods
-To obtain information relevant to my project I employed the following methods:
a) Interviews
b) Questionnaires
c) Observation
d) Online research
21
4.3.0 Interviews
The interview is the key technique for information gathering during the
systems analysis phases of a development project.The interviewing skills of the
analyst determine what information is gathered, the quality and depth of that
information.
I used one main approach to conduct my interviews within the staff that I
interviewed with during my study.
1. The time we had for the collection of the information was limited.
2. Some of the staff tried to interview were not willing to cooperate.
3. A number of the staff I had set interviews with cancelled the interview at the last
minute.
4. Some of the answers given by the staff we interviewed were general answers and
we had to make conclusions by ourself.
4.3.1 Observation
Observation is the most effective and less tedious way to research about a topic.
Provision of a permanent record - The fact that all observation entails some form of
recording means that it provides a permanent record of such events or behavior, thus
allowing further analysis or subsequent comparisons across time or location to be
carried out.
22
Complementarily with other approaches-Observation can effectively complement
other approaches and thus enhance the quality of evidence available to the researcher.
The online research was based on case studies on similar systems that exist in
different countries around the world. I found out that there exists such a system in Kenya and
is highlighted in the literature review under existing similar systems.
4.3.3.1 Demerits
1. The available source of data may be inaccessible at the time you need them.
2. The work you are using as a basis could have contained errors hence if you
happen to use it, you may end with a more errors in your project.
23
At the end of each phase, a review takes place to determine if the project is on the right
path and whether or not to continue or discard the project.
CHAPTER 5:
we believe we have done enough research on the Project and am ready to start and complete
the project over the period specified and also make the delivery.
A lot of project and survey, as well as the documentation analysis need to be done in order to make
sure that the information are accurate and the system is more efficient and also systematic. The
project that had been done is concluding in the Literature Review. Analysis is done to make sure that
the data can be used as a guideline for developing this system. There are existing systems which
involve in this chapter. The existing system tells about how they work and what the requirements that
need from their users are. This kind of information is gathered and an analysis is done to select the
appropriate features to be developed to the new system (Development of clinic Management System
for Clinic).
24
The login form
This is the first form to be loaded once you run the system. Enter the username and the
password correctly, once the username and password is entered correctly, the welcome screen
will pop up as shown below:
25
Homepage form
Through this page, the user selects among the various available options, which task they
would like to carry out or the information they would like to view. If the user wishes to
register a patient’s details, then he/she opens the registration form and enters the patient’s
details and follows the steps.
26
Registration form
27
Doctor’s form
This page allows the doctor to enter confidential and referral details
28
29