Web-Based Student Clinic System
Web-Based Student Clinic System
Group members
Name ID Number
1. TEZERA TAKELE--------------------------417/11
2. TEWODROS ESHETU--------------------414/11
3. TEMESGEN TESHOME-------------------402/11
4. TEKETEL BELAYNE----------------------394/11
5. YISHAK TEMESGEN----------------------464/11
Advisor:-
1. Mr. MESAY WANA
JUNE, 2023
Wolaita, Ethiopia
List of table
Table 1:actors description..........................................................................................................................13
Table 2:use case staff log in.......................................................................................................................16
Table 3 use case description for admin add staff.......................................................................................17
Table 4 use case description for admin delete staff...................................................................................18
Table 5:use case description for admin update staff..................................................................................19
Table 6 use case description for admin view staff.....................................................................................20
Table 7 use case description for reception add patient...............................................................................21
Table 8 use case description for admin summarize report.........................................................................22
Table 9 use case for view patient...............................................................................................................23
Table 10 use case for manager view report................................................................................................24
Table 11 use case for doctor prescribe.......................................................................................................25
Table 12use case doctor view report..........................................................................................................26
Table 13 use case view prescribe...............................................................................................................27
Table 14 use case description for add drug................................................................................................28
Table 15 use case description for view drug..............................................................................................29
Table 16 use case description for update drug...........................................................................................30
Table 17 use case description for delete drug............................................................................................31
I
List of fiure
Figure 1:system requirements......................................................................................................................6
Figure 2:cost estimation..............................................................................................................................7
Figure 3:patient information......................................................................................................................10
Figure 4:existing and proposed system in process.................................................................................11
Figure 5:use case diagram.........................................................................................................................15
Figure 6 sequence for login.......................................................................................................................32
Figure 7 sequence for view staff................................................................................................................33
Figure 8 sequence for admin add staff.......................................................................................................34
Figure 9sequence for admin update staff...................................................................................................35
Figure 10 sequence diagram for admin delete staff...................................................................................36
Figure 11sequence diagram for manager view patient...............................................................................37
Figure 12sequence diagram for manager view drug..................................................................................38
Figure 13sequence diagram for manager view patient...............................................................................39
Figure 14 sequence diagram for manager view report..............................................................................40
Figure 15 sequence diagram for manger summarize report.......................................................................41
Figure 16sequence diagram for doctor prescription...................................................................................42
Figure 17 sequence diagram for doctor view patient.................................................................................43
Figure 18sequence diagram for reception add patient................................................................................44
Figure 19 sequence diagram for reception update patient..........................................................................45
Figure 20 reception view patient...............................................................................................................46
Figure 21sequence diagram for store man add drug..................................................................................47
Figure 22sequence diagram for store man delete drug...............................................................................49
Figure 23 sequence diagram for store man view drug...............................................................................50
Figure 24sequence diagram for store man delete drug...............................................................................51
Figure 25sequence diagram for dispensary prescription............................................................................52
Figure 26sequence diagram for lab tech report..........................................................................................53
Figure 27Activity diagram for login.........................................................................................................54
Figure 28Activity diagram for admin add staff..........................................................................................55
Figure 29Activity diagram for delete staff.................................................................................................55
Figure 30Activity diagram for update staff..........................................................................................56
Figure 31 Activity diagram for admin view staff.......................................................................................56
Figure 32Activity diagram Manager View drug........................................................................................57
Figure 33Activity diagram manager for view patient................................................................................57
Figure 34Activity diagram for manager for view report............................................................................58
Figure 35 Activity diagram foe doctor prescription...................................................................................58
Figure 36 Activity diagram for reception add patient...............................................................................59
Figure 37 Activity diagram for reception for update patient information..................................................60
Figure 38 Activity diagram Store man view drug......................................................................................60
Figure 39 Activity diagram for store man add drug...................................................................................60
Figure 40 Activity diagram for store man delete drug....................................................................61
II
Figure 41 Activity diagram for lab technician view result.........................................................................62
Figure 42:class diagram.............................................................................................................................63
Figure 45 system architecture....................................................................................................................65
Figure 46 deployment diagram..................................................................................................................65
III
Catalog
List of table...................................................................................................................................................I
List of fiure...................................................................................................................................................II
Chapter one.................................................................................................................................................1
1.1Introduction....................................................................................................................................1
1.7 Methodology.................................................................................................................................3
1.9 Implementation.....................................................................................................................................4
1.12Testing technique.........................................................................................................................5
IV
1.15 Cost Estimation............................................................................................................................7
Chapter Two................................................................................................................................................9
2. System Analysis.......................................................................................................................................9
Chapter Three....................................................................................................................................63
4. System Design....................................................................................................................................63
4.1. Introduction................................................................................................................................63
V
4.5 Deployment diagram...................................................................................................................65
References.................................................................................................................................................66
VI
Chapter one
1.1Introduction
In the present day, most applications are changed in automated systems. This helps increase the
qualities of the work, reduces the complexity of tasks, keeps the security of the data in
advantageous condition, data transfers make more easily, provide timely and accurate reliable or
quality reports and analysis, provides faster product release, better service, and more reliable
products with better product histories.
Today the most business is done online worldwide, the management of institutions is done
through the networked system all the systems of information management have been
computerized. All these innovations have the aim to simplify life by making a lot of things easily
and in a short time. wolayita sodo university student Clinic Information Management System is
an automated system that is used to manage patient information, drug information, and staff
administration. It is meant to provide the Administration and Staff, with information in real-time
to reduce their workload.
This project concerned developing web based clinic information management system for
wolayita sodo university students. This project aims to simplify the workload for the clinic staffs
to reduce patients waiting time in the clinic.
1
1.3 Statement of the problem
In the existing system clinics more of the time works its activities manually so this
system has created many problems using or accessing the system. Some of them are listed below:
2
1.6 Limitation of the study
The study is limited to the Drug sales, scheduling staff. The system cannot be accessed by blind
people and the proposed system provides only for regular students.
1.7 Methodology
This is a description of methods chosen to achieve the objectives of the proposed system. It
will go on to describe the techniques of data collection that will be employed in the project of
the proposed systems. The methods that will be applied to achieve the specific objectives are
observation, Oral interviews, document analysis.
Document Analysis
Studying the documents that are use in the past; enables us to get clinic form reports to
understand problems with the existing system, rules for processing data. We have analyze
different documents that are use in the existing system for storing patient information and their
drug store details.
Development methodology
To develop this system spiral model is going to be use spiral model is one of the most important
software development life cycle models which provides flexibility when working on a project. Its
flexibility regarding requirements going to help us incorporate changes at later phases. These
changes might be a result of incorrect assumptions we make during the earlier phases of the
project
3
1.8 Tools used for system analysis and design
We can use tools and technologies such as these for the Software Design and Analysis
Specification.
Visual Paradigm
Star UML
This tool will help us design use case model, activity diagram, State chart diagram and
sequence diagram.
1.9 Implementation
System implementation (coding) is the process of writing computer programs to satisfy the
business functional requirements identified during the system analysis phase, as well as the detail
design requirements found during the design phase.
Programming languages used for implementation
Several programming languages will be use to create this system, which will be list below.
HTML is the basic markup language for building Web pages.
JavaScript is a programming or scripting language that allows you to create dynamic web
pages.
CSS specifies how HTML elements should display on a computer, in print, or in other
media.
SQL is a language to operate database operation such as storing, manipulating and
retrieving data in databases.
JQuery is a JavaScript Library. JQuery greatly simplifies JavaScript programming.
JQuery is easy to learn.
Bootstrap is the most popular HTML, CSS, and JavaScript framework for developing
responsive, mobile-first websites.
4
Hardware requirements
Integration Testing in reconciliation testing, there can be different phases of testing in our
proposed framework. To begin with, when the units are incorporated into a greater segment, a
coordination test will be apply by the colleague building up those parts. What's more,
furthermore, those segments will be coordinate with segments create by other group individuals
5
and combination test will be apply here again to guarantee that the incorporate parts act as
require. At long last, System Testing will be apply to test the entire framework in the wake of
incorporating all the sub components. Notwithstanding the useful test systems record above,
there will be nonfunctional testing procedures, for example,
Performance Testing
Security Testing
Usability Testing
Activities tools/programs
6
Database server XAMP, MySQL
7
Items Quantity Cost in
ETB
Per unit Total
Personal computer 1 20,000 birr 20,000 birr
Internet For 3 month 700 birr 2,100 birr
Printing and 200 page 5 birr 1000 birr
binding cost
Pen and paper 1 packet paper and 600 birr and 25 625 birr
3 pen birr
Total 23,725 birr
8
Chapter Two
2. System Analysis
2.1 Introduction of Existing System
There are many clinical management systems available in the market. Most of the systems are
using a manual system to assist them in managing patients' records, and also other functions like
a drug store, user management, and reporting. The purpose of computerizing is to save time,
space, and money and to enhance the patients' record management process to more efficient and
effective, reduce man power. Improve clinical and administrative efficiency, and protect the data.
The Wolayita Sodo University student clinics works manual (card/paper-based.) The manual
(card/paper-based) ineffective, inefficient, and unsafe system can cause trouble in managing a
huge amount of patient records.
In the manual form: They are keeping patients' records manually. One of the most popular
techniques they used is a medical card. Medical cards are printed cards that include brief patient
information. The date tier each visit, diagnosis, and treatment for each diagnosis.
A medical card will be generated by the receptionist when the patient first visits the clinic.
Usually, patients still ask by the receptionist to show their identity card during registration. Then
the receptionist will fill in their information based on what is stated on the identity card. The
receptionist will also get the contact number from the patient as usual. Some of the clinics will
rewrite the new patient information in a record book for backup purposes. After that, the medical
card will be passed to the doctor to write down the diagnosis and treatment information after the
doctor diagnosed the patient and then passed it back to the laboratories. The laboratories check
the patient based on the paper given by the doctor and return the result to the doctor after the
result the doctor makes a prescription. These medical cards will be later kept in a cabinet or a
rack and it is organized according to the reference number on the card. The medical card is
mainly used for recording the diagnosis and treatment that have been done on the patient. The
medical card is also used for reviewing the treatment and diagnosis that is previously done by the
doctor. Normally each patient will have their own medical card.
9
2.2 Players in the existing manual system
Receptionist: manually record and search patient information
Doctor: treat and update the patient information (information updated manually). In addition,
doctors can refer other hospital
Lab technician: diagnosis patient from the requests of doctor send results back to the doctor
manually.
Dispensary: give the medicine to the patient according to prescription and record manually
prescription details
Drug store man: record drug manually and controls the drug expiration date
Manager: control and manage staff and drug, viewing report.
10
Figure 4:existing and proposed system in process
11
The main purpose of this project is:
To provide computerized patients registration
To Update, search and record patient information
To reduce data redundancy and data mishandling
To Increasing the security and privacy of the clinic and patient profile.
Calculate and record the expense of accessing the resources found in the clinic that is
attached to the student cost-sharing in a computerized format.
Each record stored in the system in a single database server and can be access by users.
The system should very straight forward to the user and easy to operate by the user
The massage that is shown when error is detected will be in the English language in terms
that the user will understand.
Reliability
The system must authenticate the users of the system.
The error rate of this system must be shrinking.
Performance
The system must allow the staff to search the patient records in an easy and efficient way
from a large amount of data
The system response time must be faster and the system should allow the user to open
several tasks at one time when they using it.
12
Security and Access permissions
The system must verify and validate all user input and users must be notified in case of
errors detected in the course of using the system
The system only allows the administrator to delete existing users in the database; the system
should be allowed to add new staff
The data and information about the patient is the main asset. Therefore, the system must
be highly secured from external threats and unauthorized users. To access the system
users should log in with an authorized user name and password to ensure authentication.
MD5 allows securing the password for unreadable text.
Backup and Recovery
Make sure there is an additional server to back up the clinic data in case when the server
is down.
Use other external discs to back up data
2.7 Analysis model
This section introduces the proposed system with UML system models. System models describe
the model of the envisioned system. For the new system model we will use Use-case models,
sequence diagrams, Analysis level class model, and state chart diagrams
2.7.1 Use case model
Actors represent roles that can be played by users of the system. They are parties outside the
system that interact with the system. The list of actors identified for the system along with their
description is presented in table
Table 1:actors description
Manager Manager is a person who is responsible to view all activities and who is responsible
to provide solution and also generate report.
Doctor Doctor is a person who works in the Wolayita Sodo university students clinic and
who is responsible for treat the patient.
13
Lab technician Lab technician is a person who works in the Wolayita Sodo university students
clinic and who is responsible for diagnosis the patient.
Drug store Drug store man is a person who is assigned to add, delete ,update new drug in
man store.
Receptionist Receptionists a person who works in the Wolayita Sodo university student’s clinic
and responsible to add patient.
14
Figure 5:use case diagram
15
Table 2:use case staff log in
Participating Admin ,manager ,doctor ,reception ,store man, dispensary, lab technician
Actors
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The staff press” log in” tab from the 2 The system displays the login page
dashboard
3 Staff fill the username and password 4 The system validates user name
and password
Alternative flow A1 If the user entered inappropriate information press “Reset” button.
2. Go to step 3
16
Use case name Add staff
Participating Admin
Actors
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The admin press “add staff” tab 2 The system displays” add staff
from the dashboard “page with different text field
4. Go to step 3
17
Participating Actors Admin
Entry pre-Condition System Validate username and password and the user logged in
Flow of Events 1 The Admin press “delete staff” 2 System displays staff
tab from the dashboard information
18
Participating Actors Admin
Entry pre- System Validate username and password and the user logged in
Condition
Alternative flow A1 If the user entered inappropriate information press “Reset” button
A2 Go to step 3
19
Use case name view staff
Flow of Events 1 The Admin/ manager press “view 2. System displays “staff
staff” tab from the dashboard information”
20
Participating Receptionist
Actors
Entry pre- System Validate username and password and the user logged in
Condition
A2 Go to step 3
21
Description Enables summarize report
Entry pre-Condition System Validate username and password and the user logged in
Flow of Events 1 The manager press “add summarized report 2 . System displays
“tab from the dashboard “report “ page with
different text fields
Alternative flow A1 If the user entered inappropriate information press “Reset” button.
A2 Go to step 3
22
Entry pre- System Validate username and password and the user logged in
Condition
4 The Receptionist/Doctor/Manager
view patient information
23
Entry pre-Condition System Validate username and password and the user logged in
Flow of Events 1 The Manager press “view report” 2 System displays “report “
tab from the dashboard page
24
Use case UC-10
number
Participating Doctor
Actors
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The Doctor press “prescription” tab from the 2 . System displays
dashboard “patient prescribe “
page with different
3 The Doctor fill the information about patient text fields
prescription
5 The system show
successful message
25
Table 12use case doctor view report
Participating Doctor
Actors
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The Doctor press “view report” tab from 2 System displays “
the dashboard view report “ page
with different text
fields
26
Table 13 use case view prescribe
Entry pre-Condition System Validate username and password and the user logged in
27
Table 14 use case description for add drug
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The Store man press “add drug” tab 2 System displays “add
from the dashboard . drug “ page with
different text field
4 The Store man press add drug button 5 The system display
to save the drug information successful message
Alternative flow A1 If the Store man entered inappropriate information press “reset”
button.
A2 Go to step 3
28
Table 15 use case description for view drug
Entry pre- System Validate username and password and the user logged in
Condition
29
Table 16 use case description for update drug
Entry pre-Condition System Validate username and password and the user logged in
Flow of Events 1 The Store man press “update drug” tab 2. System displays drug
from the dashboard information
A2 Go to step 3
30
Table 17 use case description for delete drug
Entry pre- System Validate username and password and the user logged in
Condition
Flow of Events 1 The Store man press “delete drug” tab 2. The system shows drug
from the dashboard information
31
2.9 Sequence diagram
It shows the way objects interact with one another as messages are passed between them. It also
demonstrates the behavior of objects in a use case by describing the objects and the messages
they pass.
32
Figure 7 sequence for view staff
33
Figure 8 sequence for admin add staff
34
Figure 9sequence for admin update staff
35
Figure 10 sequence diagram for admin delete staff
36
Figure 11sequence diagram for manager view patient
37
Figure 12sequence diagram for manager view drug
38
Figure 13sequence diagram for manager view patient
39
Figure 14 sequence diagram for manager view report
40
Figure 15 sequence diagram for manger summarize report
41
Figure 16sequence diagram for doctor prescription
42
Figure 17 sequence diagram for doctor view patient
43
Figure 18sequence diagram for reception add patient
44
Figure 19 sequence diagram for reception update patient
45
46
Figure 20 reception view patient
47
Figure 21sequence diagram for store man add drug
48
Figure 22sequence diagram for store man delete drug
49
Figure 23 sequence diagram for store man view drug
50
Figure 24sequence diagram for store man delete drug
51
Figure 25sequence diagram for dispensary prescription
52
Figure 26sequence diagram for lab tech report
53
2.10 Activity diagram
Activity diagrams are used to show how different workflows in the system are constructed, how
they start and the possibly many decision paths that can be taken from start to finish. They may
also illustrate the where parallel processing may occur in the execution of some activities.
Figure
27Activi
ty
diagram
for
login
For
the
following activity diagrams we assume the actors are logged in to the system
54
Figure 28Activity diagram for admin add staff
55
Figure 30Activity diagram for update staff
Figure 31 Activity
diagram for admin view staff
56
Figure 32Activity diagram Manager View drug
57
Figure 34Activity diagram for manager for view report
58
Figure 36 Activity diagram for reception add patient
59
Figure 38 Activity diagram Store man view drug
60
Figure 40 Activity diagram for store man delete drug
61
2.11 Class Diagram of the system
Unified Modeling Language (UML) class diagrams are the mainstay of object-oriented
modeling. Class models show the classes of the system, their interrelationships (including
inheritance, aggregation, and association), and the operations and attributes of the classes. Class
diagrams are used for a wide variety of purposes, including both conceptual/domain modeling
and detailed structural design modeling. Classes are depicted as boxes with three sections: the
top one indicates the name of the class, the middle one lists the attributes of the class, and the
third one lists the methods. By including both an attribute and a method box in the class. Another
approach would be to have two sections, one for the name and one for the responsibilities. [1]
62
Chapter Three
3. System Design
Software architecture is structured into three layers by dotted lines. Each layer is an abstraction
of functionality. The layer on the bottom offers data management functionality to the services
layer. And the services layer offers functionality to several clients on the Internet. Each layer is
build onto the functionality of the next layer down the stack.
Client machine: - refers to a user's computer that is connected to a network and accesses the
system from server, machine.
Web browser: -The application program that serves for accessing the World Wide Web, one of
the major services on the Internet. In order to view a Web site, by using the website address
(URL).
Server machine: -is a system that responds to requests across a computer network to provide, the
system service
3.1. Introduction
System design model is a transformation of the analysis model in to a system design model. System
design is the first part to get in to solution domain in software development. This chapter focuses on
transforming the analysis model in to design model that takes in to account the nonfunctional
requirements and constraints described in the problem statement and requirements analysis section
discussed earlier
63
• Compatibility: The system should be compatible with windows platform and all users know
about the system of the registration.
• Security: The system should be secured that unauthorized user cannot access the data that does
not concern with them.
• Usability: the system should be user friendly for end users.
• Availability: the users should have access to the HUSCIS system whenever they need it.
• Maintenance: In time of failure or need modification the system need to be maintainable
4.4 Proposed system architecture
This gives a high level view of the new system with the main components of the system and the
services they provide and how they communicate. The system is implemented using a three-tier
architecture that comprises of user interface, process management and DBMS as
64
Figure 43 system architecture
65
References
[2] J. W. a. S., in Requirements Engineering A good practice guide, , Ramos Rowel and Kurts Alfeche, ,
1997..
66