Journal of Business, Social and Technology (Bustechno) http://bustechno.ridwaninstitute.co.id/index.php/jbt/issue/current

 

WEB-BASED MELVIANA HEALTH CLINIC INFORMATION SYSTEM

 

Rendi Brahma Fahrezi

Creative Media, Syntax Corporation Indonesia, Cirebon, Jawa Barat, Indonesia

Email: [email protected]

 

 

 

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), 11711177. 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), 99104. 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), 17. 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

Copyright holder :

Rendi Brahma Fahrezi (2020)

 

First publication right :

Journal of Business, Social and Technology (Bustechno)

 

This article is licensed under: