WEB-BASED
MELVIANA HEALTH CLINIC INFORMATION SYSTEM
Rendi
Brahma Fahrezi
Creative Media, Syntax
Corporation Indonesia, Cirebon, Jawa Barat, Indonesia
Email: rendibrahma00@gmail.com
|
|
Abstract
|
|
Article
Information:
Received
Revised
Accepted
Keywords:
information
systems; health clicks; web-based
|
In
today's globalization era, nscience and technology are developing very
rapidly, especially information technology. Human need for everything is
required to be more efficient, for example it is very clear from the
development of information technology, the work that originally still uses a
lot of manual systems at this time has begun to decrease, because it began to
practice to a computerized system. Because with a computerized process any
work will be easier to do. In the process of developing data and information
needs that are growing longer, has encouraged better handling of data and
information so that each element can be implemented optimally the author to
get information relevant to the topic and problems that will or are being
researched. The information can be obtained from scientific books, research
reports, yearbooks and written sources both printed and electronic..
|
Introduction
In today's globalization era, science
and technology are developing very rapidly, especially information technology (Jeronimo,
2019). Human
need for everything is required to be more efficient, for example it is very
clear from the development of information technology, the work that originally
still uses a lot of manual systems at this time has begun to decrease, because
it began to practice to a computerized system. Because with a computerized
process any work will be easier to do (Giddens, 2013). In the
process of developing data and information needs that are growing longer, has
encouraged better handling of data and information so that each element can be
implemented optimally. The information
system at the puskesmas or community health center has several activities,
including patient registration, patient medical records, patient care, queuing,
and reporting (Nursikuwagus, 2017).
This research is motivated by an analysis of the need for a health service
information system which is an important part that cannot be separated from the
health system in a country (Purnomo, Prima, & Efendi, 2021).
The era of globalization and information will have created new standards that
must be met by all players in this sector, no exception in the health care
sector (Hidayat & Sirait, 2020).
This system will provide the result of report and information needed by the
patient services administration. It is hoped that this system can be used as an
experienced assistant (Wiendara et al., 2019).
Similarly, in managing patient identity
documents at melviana clinic located at Jl.Saparua Raya No.239 Perum III East
Bekasi, Bekasi City -West Java, which is still done manually or handwritten. In
this way there are some shortcomings that can occur errors in writing and reading,
not concise, the length of service to patients, documents that are vulnerable
to loss or damage and limited storage (Mulyadi, Hoiriah, Supriadi, & Mugiati, 2018).
Patient registration at Melviana clinic is required an information technology
to process the data automatically. The use of technology in the registration of
diclinic patients can provide an ease and accuracy in processing patient
identity data. In addition, it can also provide unlimited space for storage of
pasein data.
By using this web-based information
system Melviana clinic can provide web-based services to patients to improve
performance and performance in handling community services (Andrianto & Nursikuwagus, 2017). In
addition, with this web-based information system the registration process can
be done easily, anywhere and anytime (Ibrahim, 2011). With
this web-based Melviana clinic information system will be able to compete with
other clinics and will provide the best service for patients who need health
services (Palit, Rindengan, & Lumenta, 2015).
In the description above, I did research
at Melviana Health Clinic with the title "Web-Based Melviana Health Clinic
Information System"
Method
Data collection techniques are carried
out to obtain information and data related to the needs of completing the Final
Task. The things that are done are as follows:
1. Field Studies
Field
studies are the design of research by conducting surveys based on experience or
case studies where researchers try to identify important variables and
relationships between these variables in a specific problem. Field studies were
conducted including observations and interviews of the objects studied.
a. Observation
Is a field study
that is done systematically by paying attention directly or indirectly to the
objects studied and taking visual data according to the needs of research so
that no data is missed in the web-based Melviana Health Clinic Information system
using PHP & My Sql.
b. Interview
This data
collection technique is carried out by asking directly with employees or officers
of Melviana health clinic who provide informassi about the problems that are
being researched.
2. Literature Studies
Efforts
are made by the author to obtain information relevant to the topic and the
problem that will or is being researched. The information can be obtained from
scientific books, research reports, yearbooks and written sources both
electronically and.
Results and Discussion
A. System Design
1. Entity
Relationship Diagram (ERD)
Figure 1
Entity Relationship Diagram
2. Normalization
a. Unnormalized
Form
Table 1
Abnormal Shape
b. First
Normal Form
Table 2
First Normal Form 1NF
c. 2NF /
Secon Normal Form
Table 3
Secon Normal Form
d. 3NF/Third
Normal Form
Table 4
Third Normal Form
3. Structure HIPO
a. Visitor
HIPO Structure
Figure 2
Visitor HIPO Structure
4. Program View Design
a.
Admin View Design
Figure 3
Rancngan Admin View
b. Dashboard
View Design
Figure 4
Rancngan Dashboard View
c. 
Patient
Data View Design
Figure 5
Rancngan Patient View
d. New
Patient List View Design
Figure 6
New Patient List View Rancngan
e. Laboratory
Display Design
Figure 7
Laboratory Display Design
B. Implementation
1. Relationships
Between Tables
Figure 8
Relationships
Between Tables
2. DataBase
Structure
a. Doctor
Database Structure
|
File Name
|
Doktor
|
|
Acronym
|
dokter.myd
|
|
File Functions
|
File Master
|
|
Organization
|
Index Sequential
|
|
File
|
Random
|
|
File Access
|
Harddisk
|
|
Media File
|
959 characters
|
|
Record Length
|
kd_dokter
|
|
Software
|
MySQL
|
Table 5
Doctor
database structure
=
b. Visit
Database Structure
|
File Name
|
Visit
|
|
Acronym
|
visit.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
34 characters
|
|
Field key
|
kd_kunjungan
|
|
Software
|
Mysql
|
Table 6
Visit Database Structure
c. Laboratotium
Database Structure
|
File Name
|
Laboratory
|
|
Acronym
|
laboratorium.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
322 characters
|
|
Field key
|
kd_lab
|
|
Software
|
MySQL
|
Table 7
Laboratory Database Structure
d. Login
Database Structure
|
File Name
|
Login
|
|
Acronym
|
login.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
631 characters
|
|
Field key
|
kd_user
|
|
Software
|
MySQL
|
Table 8
Login Database Structure
e. Drug
File Specifications
|
File Name
|
Drug
|
|
Acronym
|
obat.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
358 Character
|
|
Field key
|
kd_obat
|
|
Software
|
MySQL
|
Table 9
Drug Database Structure
f.
Patient File Specifications
|
File Name
|
Patients
|
|
Acronym
|
pasien.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
1228 Character
|
|
Field key
|
no_pasien
|
|
Software
|
MySQL
|
Table 10
Patient Database Structure
g. Polyclinic
File Specifications
|
File Name
|
Poliklinik
|
|
Acronym
|
poliklinik.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
322 Character
|
|
Field key
|
kd_poli
|
|
Software
|
MySQL
|
Table 11
Polyclinic Database Structure
h. Medical
Record File Specifications
|
File Name
|
rekam_medis
|
|
Acronym
|
rekam_medis.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
967 Character
|
|
Field key
|
no_rm
|
|
Software
|
MySQL
|
Table 12
Medical Records Database
Structure
i.
Action File Specifications
|
File Name
|
Action
|
|
Acronym
|
tindakan.myd
|
|
File Functions
|
File Master
|
|
Organization Files
|
Index Sequential
|
|
File Access
|
Random
|
|
Media File
|
Harddisk
|
|
Record Length
|
311 Character
|
|
Field key
|
kd_tindakan
|
|
Software
|
MySQL
|
Table 13
Action Database Structure
3. Main
Menu View, Program Input and Output
a.
Main Menu View
Figure 9
Main Menu View
b.
Admin Menu View
Figure 4.27
Admin Menu View
Figure 10
Admin Menu View
c.
Dashboard
Menu View
Figure 11
Dashboard Menu View
d.
Patient Menu
View
Figure 12
Patient Menu View
e.
Visit Menu View
Figure 13
Visit Menu View
f.
Medical
Record Menu View
Figure 14
Medical Record Menu View
g.
Print Menu View
Figure 15
Print Menu View
h.
Laboratory Menu View
Figure 16
Laboratory Menu View
i.
Action Menu view
Figure 17
Action Menu View
j.
Drug Menu Display
Figure 18
Drug Menu Display
k.
Doctor Menu View
Figure 19
Doctor Menu View
l.
Polyclinic Menu View
Figure 20
Polyclinic Menu View
m.
User Menu View
Figure 21
User Menu View
n.
Patient Report View
Figure 22
Patient Report View
o.
Visit Report View
Figure 23
Visits Report View
p.
Print Card Report View
Figure 24
Print Card Report View
q.
Laboratory Report View
Figure 25
Laboratory Report View
r.
Action
Report view
Figure 26
Actions Report View
s.
Drug Report View
Figure 27
Drug Report View
t.
Doctor Report View
Figure 28
Doctor Report View
u.
Polyclinic Report View
Figure 29
Polyclinic
Report View
v.
User Report View
Figure 30
User Report
View
4. Compile
/ Program End Result
Database
steps to use
a) Through
the star menu on the taskbar, select the all program menu
1)
Run firofox mozila
2) Type localhost
b) Select
php MyAdmin
1) Select Database
2) Type the db_dbms in the
create database field
3) Click
create
c) Create a
Table
1) Select create table
2) Type the table name in the
table name column
3) Type the field name in
the name field
4) Choose
the data type
5) Length
characters in the length values column
6) Specify
the primary key in the index column
7) Select
saveLakukan hal yang sama seperti bagian c untuk membuat tabel – the following table:
Steps to run the sales applicassi program
1)
Select the start menu on the taskbar select all programs
2)
Choose firofox mozila
3)
Type localhost/klinkmelviana/admin
4)
Enter the password
a)
If the username and password are correct to the main menu
b)
If the username and password are incorrectly rejected to
the rejection menu
c)
Main Menu
5)
Choose options such as the menu below Data
6)
Select patient for input, edit, delete
Conclusion
From the discussion that has been
described, it can be concluded the following, health services to patients are still using manual
methods, it is necessary computerized system. By using the Web, health care
information system can be developed better in the process of providing services
to patients. With a computerized system will support the delivery of accurate
and fast information to all parties who need it, especially in making decisions.
REFERENCES
Andrianto, Pradikta, &
Nursikuwagus, Agus. (2017). Sistem Informasi Pelayanan Kesehatan Berbasis Web
Di Puskesmas. Seminar Nasional Komputer Dan Informatika, 6. Google Scholar
Giddens, Anthony. (2013). The Third Way And Its Critics.
John Wiley & Sons. Google Scholar
Hidayat, Alvat Taupik, & Sirait, Ridoy Eka Dharma.
(2020). Design Of Dental Police Patient Service Information System At Upt
Puskesmas Talagabodas Bandung: Design Of Dental Police Patient Service
Information System At Upt Puskesmas Talagabodas Bandung. Jurnal Mantik, 4(2),
1171–1177. Google Scholar
Ibrahim, Ali. (2011). Sistem Pemesanan Tiket Pesawat Berbasis
Web. Jsi: Jurnal Sistem Informasi (E-Journal), 3(1). Google Scholar
Jeronimo, Advento. (2019). The Globalization Effect Of Law
And Economic On Cybercrime. Jurnal Pembaharuan Hukum, 6(3). Google
Scholar
Mulyadi, Mulyadi, Hoiriah, Hoiriah, Supriadi, Deddy, &
Mugiati, Rina. (2018). Sistem Informasi Pendaftaran Kursus Berbasis Web Pada
Yayasan Musik Jakarta. Ijcit (Indonesian Journal On Computer And Information
Technology), 3(2). Google Scholar
Nursikuwagus, Agus. (2017). E-Health As A Service Software Of
Medical System In Prototype Modeling. Ijnmt (International Journal Of New
Media Technology), 4(2), 99–104. Google Scholar
Palit, Randi V, Rindengan, Yaulie D. Y., & Lumenta, Arie
S. M. (2015). Rancangan Sistem Informasi Keuangan Gereja Berbasis Web Di Jemaat
Gmim Bukit Moria Malalayang. Jurnal Teknik Elektro Dan Komputer, 4(7),
1–7. Google Scholar
Purnomo, Wulan Andang, Prima, Wahyu, & Efendi, Raimon.
(2021). Analysis And Design Of Web-Based Health Service Information Systems
(E-Health), In The Industrial Revolution Era 4.0. Journal Of Physics:
Conference Series, 1764(1), 12067. Iop Publishing. Google Scholar
Wiendara, Geby Chintya, Abadi, Satria, Ilayaraja, M.,
Shankar, K., Nguyen, Phong Thanh, Hashim, Wahidah, & Maseleno, Andino.
(2019). Multi User-Based Patient Service Information System In Public Health
Center. Google Scholar
