P-ISSN: 2808-5957

E-ISSN: 2808-6724

ijoms.internationaljournallabs.com

1976

INTEGRATED DATABASE DEVELOPMENT FOOD AND NUTRITION

TRAINING PROGRAM ON SEAMEO RECFON

Dodi Suswandi

, Ivan Hanafi, Muhammad Yusro

Faculty of Engineering, State University of Jakarta, East Jakarta, DKI Jakarta, Indonesia

doddysiswandi@gmail.com

ARTICLE INFO

ABSTRACT

Published: November 28

2022

The Southeast Asian Ministers of Education Organization Regional Center

for Food and Nutrition (SEAMEO RECFON), already has a pretty good

system, but there are some problems and the need for up-to-date information

on food and nutrition topics and service facilities that support all activities.

To support the process of monitoring and evaluating program achievement

targets. SEAMEO RECFON requires a database system not only for

operations but also for monitoring and evaluation needs. The system must

be able to store and manage data on the results of achievements from

program activities, document the results of analysis, and other information.

In this study, an Integrated Database System has been designed and

implemented to achieve the achievement of training programs in the field of

food and nutrition, using the System Development Life Cycles (SDLC)

method with a prototyping development model that helps in system

development. This system can store and collect various types of

achievements along with related information such as student data, teacher

data, school data, types of training, research programs, and other detailed

information that supports the research process. The system also provides a

feature for users to be able to report and submit data on participants and

guidance schools and new colleagues. The system is implemented in

prototype form and tested against functionality, performance, and security.

The results expected by the Integrated Database system can help the

operations of the Organizational Staff both for operations and an integrated

data collection process and facilitate the process of monitoring and

evaluating program achievement targets.

Keywords: integrated database,

food and nutrition training, SEAMEO

RECFON

This work is licensed under CC

BY-SA 4.0

INTRODUCTION

Strategic Plan of SEAMEO Center Indonesia 2020-2024 Ministry of Education and Culture

Secretariat General of the SEAMEO Center Indonesia Work Unit (2021). The Southeast Asian

Ministers of Education Organization Regional Centre for Food and Nutrition (SEAMEO

RECFON) has the mandate to play a role in improving the knowledge and practice of community

nutrition in Southeast Asia to realize a society with good nutritional status. SEAMEO RECFON

actively carries out educational, research, training, and community empowerment activities so that

the need for up-to-date information on food and nutrition topics and services and facilities that

support all these activities becomes very important. This important task must be supported by

adequate facilities, including the procurement of data processing and communication devices that

can support RECFON activities every day, including in terms of dissemination of information and

knowledge derived from research results.

Based on the search results in the field, the SEAMEO RECFON Database system has

implemented information technology infrastructure without using an enterprise architecture

framework and so far has only used manual systems, namely Microsoft Excel and Access. Without

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1977 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

enterprise architecture, several problems occur in the technology infrastructure, including

hardware that has decreased performance, software that requires the latest version of upgrading to

be used optimally, and networks that often experience problems in intranet and internet

connections.

Before this development research has been carried out, several previous studies have been

carried out based on the needs of the type of data from each unit with different types of activity

programs, where several surveys were carried out by investigating and looking for information on

the use of applications in the data storage and the type of data used in each unit to fulfill information

data, a problem was found in the storage area and applications used in the SEAMEO RECFON

database system so it is necessary to make a new technology architecture plan using the appropriate

system, namely Web-based. Upgrade all data owned by SEAMEO RECFON which is useful for

supporting information dissemination and storage activities. This is expected to improve

engagement with the general public and optimize the database function owned by SEAMEO

RECFON in storing information in the field of food and nutrition both at the national and regional

levels.

Over time the management of the SEAMEO RECFON database system continues to strive

to meet the needs of information technology. Progress and success in the field of information

technology in the SEAMEO RECFON Database System have not escaped obstacles and problems

in various aspects. Less effective in database management now, databases are still not integrated

into one system for each unit so each unit still has a different database. The software used still uses

Microsoft Excel and Microsoft Access which is still manual and has not integrated data between

units and divisions, which results in double data and no data synchronization in each activity, thus

making the need for information technology quite large and complex. It is hoped that the database

system to be developed can be used as a reference for the implementation of monitoring and

evaluation activities and the SEAMEO Center Indonesia Strategic Plan by default.

The following are research questions or problem formulations

1) What is the process of designing a database of targets for achieving the SEAMEO

REFCON Training program?

2) What is the process of implementing the monitoring system carried out to obtain data

on the target achievements of the SEAMEO RECFON Training program?

3) How effective is the database system of program achievement targets in improving the

monitoring and evaluation process so that it can be carried out properly, effectively,

and efficiently in the Program implemented by SEAMEO RECFON?

The process of designing a database system for the target achievement of the SEAMEO

RECFON program is expected to provide many benefits such as the presentation of accurate, fast,

and complete information, making it easier for institutions to obtain information, monitoring, data

management by the coordinator of the activity program and helping SEAMEO RECFON know

the achievement of the implementation of the annual program implemented.

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1978 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

METHOD

The type of research used is R&D (Research and Development) which focuses on developing

a database application system that aims to produce products and find out the test results of database

development.

The development model used in this study is a development model of the System

Development Life Cycles (SDLC) method, namely prototyping. This model is often used if the

owner of the system does not master the system he is going to develop, so he needs an overview

of the system he will develop. (Mulyani: 2016). This development model was chosen because the

process of designing this application requires intense communication between the developer and

the system user.

The prototyping development model starts with collecting needs or analyzing user needs,

prototyping development, prototyping evaluation, system coding, system testing, system

evaluation, and system use (Susanto, 2016)

Figure 1. Stages of the Prototyping Development Model

Source: Susanto (2016)

The prototype model aims to allow users to frequently interact with the proposed prototype.

D Purnomo (2017) stated that Prototype will propose a basic version that can be developed to be

larger according to user needs. G. I. Marthasari et al (2017) and R. S. Pressman (2014) say that the

stages in the development of prototyping methods include:

1) Communication: At the communication stage, it is carried out by conducting interviews

and observations with the owner of the company. In this stage, the needs and problems of

the user are collected so that an outline of the entire system to be created is obtained.

2) Quick Plan and Modeling Quick Design: At this stage, it focuses on the appearance of the

system (interface) as well as the output used by the user.

3) Construction of Prototype: The construction of a planning model from the previous stage.

4) Deployment Delivery and Feedback: The prototype is then handed over to the user for trial

and evaluation. Users will provide feedback on the prototype that has been made. Feedback

will be used as a reference for improvements from prototypes to produce a system that suits

the needs of users.

Based on the prototyping method, the following stages of research will be carried

out in this study:

a) Collecting data on the system needs using interview and observation methods;

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1979 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

b) Membuat use case, sequence, activity, class diagram dan ERD;

c) Create a website display design;

d) Implementing the design and manufacture of prototypes; and

e) Handing over prototypes to users and getting feedback. If there are things that must be

repaired, then the prototype will be repaired according to user needs.

Stages of Database Creation

Designing Prototyping

Build prototyping by designing a temporary system that focuses on presenting to users based

on the analysis of application media needs in the first stage. Prototyping that is built to create ER

diagrams, flowcharts, use case diagrams, and design interfaces.

Designing the Database System Concept

The training program target achievement database is a web server-based application that is

used to store, and manage samples and information related to school data, teachers, students,

training participants, types of training, research, types of research, partnerships, MOU documents,

and participation certificates for analysis and research needs. The overall concept is in the

following figure.

Figure 2. Database System Concept Design

The following is the narrative of the Information System flow, namely:

1) Entities involved: Administrators, Students, and Teachers

2) The narrative:

a) Administrators can Create, Update, and Delete master data, namely Schools, Partners,

Students, and Teachers;

b) The administrator creates a new training, registers students as participants, and also

assigns grades to trainees;

c) Administrators can also Create, Update, and Delete activity data, namely Research, and

Visits;

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1980 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

d) The report is divided into training reports, trainees, research, and visits, the

Administrator can print the results of the report;

e) Administrators can Create, Update, and Delete student, teacher, and backend user data;

f) Students or Teachers can register through the registration page and log in to the

application;

g) Students can register for the selected training and also update their profile; and

h) Teachers can update their profile on the teacher's master page.

Flowchart/System Application Logic Design

Used to design logic that exists in a program. Here is the design of the Menu Interface that

will be implemented in a program.

Figure 1. Flowchart/System Application Logic Design

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1981 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

Designing ER Diagrams: Database Input

Figure 2. Designing ER Diagrams: Database Input

After the database design is made on the ER Diagram, it is adjusted to the needs of the feature

design system.

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1982 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

Figure 3. Relationships Between Tables in a Database

Stages of Research

In this study, data analysis was carried out in conjunction with the data collection process.

Heriyanto (2018) states that the flow of analysis follows a thematic analysis model includes:

Researchers use several methods/methods to collect data.

1) Interviews: Interviews are conducted with interviewees who have an important role in the

organization and have special capacity and knowledge about the topics covered to know

the current conditions and desired expectations.

2) Document Analysis: Document analysis is carried out on official organization documents

in the form of the SEAMEO RECFON Strategic Plan 2015-2019, the 2020-2024 Strategic

Plan, the Organization's Annual Report, the ICT & Network Division Annual Report, and

the organization's activity report. In addition to official documents, literature studies are

also carried out by studying similar and previously conducted research.

3) Field Observation: By making observations in the SEAMEO RECFON organization, it will

be known which activities are running and needed in real terms.

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1983 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

RESULT AND DISCUSSION

Analysis of System Design and Testing Results

Running System Analysis

The stale data system running in each unit on SEAMEO RECFON in the data store is still

not optimal. Storage still uses MS. Excel and MS. Access programs and the data units stored by

Masuh have not been integrated, resulting in a lot of double recording of data, such as data from

teachers, schools, and students who attended the training. For partner data, it is also still not

connected between data from each unit. So the Monev team reporting still has problems in

obtaining data.

Developed Database System Analysis

This web server-based database system is to help the administrative staff of each unit and the

monitoring and evaluation team of program activities to manage and obtain data. In this system,

there is a difference from the current system, namely data storage is integrated.

Admins from each unit can collect data on students, teachers, schools, and the type of training

they participate in and can get accurate data in the form of graphs and can be taken in the form of

Ms. Excel and PDF, the Monev team also gets maximum data and analysis results.

System Needs Analysis

1) Software requirements analysis: As for the specifications of the Application used:

a) Programming Languages: PHP 5.4, Javascript, HTML, & CSS; Framework Code Igniter;

and LTE Admin Template 2

b) Database: MySQL

2) Functional needs analysis:

a) Administrators can Create, Update, and Delete master data, namely Schools, Partners,

Students, and Teachers;

b) The administrator creates a new training, registers students as participants, and also

assigns grades to trainees;

c) Administrators can also Create, Update, and Delete activity data, namely Research, and

MoU;

d) The report is divided into training reports, training participants, research, and MoU, the

Administrator can print the results of the report;

e) Administrators can Create, Update, and Delete student, teacher, and backend user data;

f) Students or Teachers can register through the registration page and log in to the

application;

g) Students can register for the selected training and also update their profile;

h) Teachers can update their profile on the teacher's master page

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1984 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

3) Activity Diagram

a) Activity Menu Master

b) Flowchart Menu “Training”

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1985 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

c) Flowchart Menu “Research” & “Partnership”

System Implementation

Figure 1. Login form display

Before displaying the main page, the system will display the login page as a requirement to

enter the main page.

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1986 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

and password on the register page, before being able to log in to update the profile and registration

for training.

Main Menu Page (Dashboard)

On the dashboard page, we can view a summary in the form of charts and tables for activities

in the current year that have been inputted into the database

Training Menu Page

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1987 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

On the Training menu, users can Create, Update, and Delete Training according to the

available fields. This page also determines the active status of the training.

On the training list menu page, we can View Details, and also register as training participants

Training List Menu Page

On the List Training Filter list training menu with multiple lists, will display the details of

the participants and also the score and status. We can also fill in the scores of the participants.

Value Upload Menu page

On the Upload Value Step 1 menu page to select the training title and download first the

value format, then upload to step 2 and preview the list of values we have uploaded

(Frastian, 2018; Jia, 2019; Kumar & Garg, 2018; Kurniawan, 2016; Mansur & Kasmawi, 2017; Miftakul Amin et al., 2018; Mulyana & Wahana, 2017; Nurnawati, 2016; Pratama et al., 2020; Pressman, 2009; Rompas, 2021; Soipah,

2017; Sukamto & Suyanto, 2012; Taipalus et al., 2021; Yamazaki et al., 2020)

(Ackerman & Osborne, 2005; Agung, 2017; Brown et al., 2015; Connolly & Begg, 2014; Eslami et al., 2020; Goldkuhl, 2019; Ismai, 2020; Jaiswal, 2013; Marthasari et al., 2017; Purnomo, 2017; Tarigan S et al., 2010; Vicknair et al.,

2010)

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1988 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

Plant Report Training

The Report Training page serves to display a summary of training activities in a certain

period

Training Participant Report

Participant Report menu page Serves to display the value of participants in the selected

training

CONCLUSION

Each unit, especially the SEAMEO RECFON Training unit in managing data, still uses

conventional methods which still use Microsoft Acess and Microsoft Excel. Designing and

developing this information system using the System Developement Life Cycles (SDLC) method,

namely prototyping and to develop the system using several stages, namely analysis of the running

system, database design, interface display design and program testing. The Hypertext Preprocessor

(PHP) programming language is used, database design uses a MySQL database, and Apache as

the web server.

The implementation of the integrated database of training programs in the field of food and

nutrition in seameo recfon is to utilize internet technology that develops when staff can carry out

data processing processes in the office or when performing tasks outside the office area and can

be used for monitoring and evaluating activities effectively.

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1989 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

Based on the results of the study, researchers suggested that there is a need to notify which

data has been inputted and which has not been inputted and additional systems so that they can be

integrated with the data in Dapodik.

REFERENCE

Ackerman, I. N., & Osborne, R. H. (2005). Integrating data to facilitate clinical research: A case

study. Informatics in Primary Care, 13(4). https://doi.org/10.14236/jhi.v13i4.606

Agung, H. (2017). Perancangan database untuk aplikasi sistem kemahasiswaan pada mobile. In

Jurnal Teknologi Informasi (Vol. 12, Issue 1).

Brown, G. R., Hem, V., Katz, K. S., Ovetsky, M., Wallin, C., Ermolaeva, O., Tolstoy, I., Tatusova,

T., Pruitt, K. D., Maglott, D. R., & Murphy, T. D. (2015). Gene: A gene-centered information

resource at NCBI. Nucleic Acids Research, 43(D1). https://doi.org/10.1093/nar/gku1055

Connolly, T., & Begg, C. (2014). Database Systems: A practical approach to design,

implementation and management. In PEARSON (Vol. 5). Pearson.

Eslami, M., Mahmoodian, V., Dayarian, I., Charkhgard, H., & Tu, Y. (2020). Query batching

optimization in database systems. Computers and Operations Research, 121.

https://doi.org/10.1016/j.cor.2020.104983

Frastian, N. (2018). Perancangan aplikasi berbasis web pada kantor / Lembaga Swadaya

Masyarakat (LSM) Indonesia Membangun. Faktor Exacta, 5(2).

Goldkuhl, G. (2019). The generation of qualitative data in information systems research: The

diversity of empirical research methods. Communications of the Association for Information

Systems, 44(1). https://doi.org/10.17705/1CAIS.04428

Heriyanto, H. (2018). Thematic analysis sebagai metode menganalisa data untuk penelitian

kualitatif. Anuva, 2(3). https://doi.org/10.14710/anuva.2.3.317-324

Ismai. (2020). Perancangan basis data sistem informasi perwira tugas belajar (Sipatubel) pada

kementerian pertahanan. In Senamika (Vol. 1, Issue 2).

Jaiswal, G. (2013). Comparative analysis of Relational and Graph databases. IOSR Journal of

Engineering, 03(08). https://doi.org/10.9790/3021-03822527

Jia, Z. (2019). Marine integrated database management system based on improved object-

relational mapping technology. Journal of Coastal Research, 98(sp1).

https://doi.org/10.2112/SI98-033.1

Kumar, J., & Garg, V. (2018). Security analysis of unstructured data in NOSQL MongoDB

database. 2017 International Conference on Computing and Communication Technologies

for Smart Nation, IC3TSN 2017, 2017-October.

https://doi.org/10.1109/IC3TSN.2017.8284495

Kurniawan, R. (2016). Perancangan sistem basis data pada aplikasi sistem penjawab soal pilihan

ganda. VOLT - Jurnal Ilmiah Pendidikan Teknik Elektro, 1(2).

Mansur, M., & Kasmawi, K. (2017). Pengembangan sistem database terpadu berbasis web untuk

penyediaan layanan informasi website desa. Jurnal Nasional Teknologi Dan Sistem

Informasi, 3(1). https://doi.org/10.25077/teknosi.v3i1.2017.73-82

Integrated Database Development Food and Nutrition Training Program on SEAMEO RECFON

1990 | I n d o n e s i a n J o u r n a l o f M u l t i d i s c i p l i n a r y S c i e n c e , 2 ( 2 ) , N o v ,

2022

Marthasari, G. I., Risqiwati, D., Buana, T., Dewi, T. (2017). Rancang bangun dan implementasi

website e-commerce UKM GS4 Malang menggunakan metode prototyping. Seminar

Teknologi Dan Rekayasa, July.

Miftakul Amin, M., Maseleno, A., Shankar, K., Perumal, E., Vidhyavathi, R. M., &

Lakshmanaprabu, S. K. (2018). Active database system approach and rule based in the

development of academic information system. International Journal of Engineering and

Technology(UAE), 7(2.26 Special Issue 26). https://doi.org/10.14419/ijet.v7i2.26.14361

Mulyana, E., & Wahana, A. (2017). Rancang bangun sistem basis data penelitian menggunakan

top down approach. TELKA - Telekomunikasi, Elektronika, Komputasi Dan Kontrol, 3(2).

https://doi.org/10.15575/telka.v3n2.152-167

Nurnawati, E. K. (2016). Pemanfaatan basis data terintegrasi pada sistem informasi perangkat

bergerak. Prosiding Seminar Nasional Aplikasi Sains Dan Teknologi (SNAST), 1(1).

Pratama, G. B., Nurani, T. W., & Wahju, R. I. (2020). Rancang bangun sistem basis data untuk

menunjang pengelolaan perikanan Tuna Cakalang dan Tongkol di Perairan Natuna. Akuatika

Indonesia, 5(2). https://doi.org/10.24198/jaki.v5i2.28340

Pressman, R. S. (2009). Software engineering: A practitioner’s approach. In Software Engineering

A Practitioner’s Approach 7th Ed - Roger S. Pressman (7th ed.). McGraw-Hill Higher

Education. https://doi.org/10.1017/CBO9781107415324.004

Purnomo, D. (2017). Model prototyping pada pengembangan sistem informasi. J I M P - Jurnal

Informatika Merdeka Pasuruan, 2(2). https://doi.org/10.37438/jimp.v2i2.67

Rompas, L. M. (2021). Perancangan sistem informasi manajemen data base jalan dan jembatan

berbasis SIG di Kabupaten Kep. Siau Tagulandang Biaro. Tekno, 18(76).

Soipah. (2017). Perencanaan arsitektur sistem informasi koperasi menggunakan metodologi

Togaf. Jurnal Ilmiah Indonesia, 2(11).

Sukamto, S. W., & Suyanto, B. (2012). Sistem terpadu rekam medik rumah sakit dengan smart

card. Jurnal Informatika Ahmad Dahlan, 6(1).

Taipalus, T., Grahn, H., & Ghanbari, H. (2021). Error messages in relational database management

systems: A comparison of effectiveness, usefulness, and user confidence. Journal of Systems

and Software, 181. https://doi.org/10.1016/j.jss.2021.111034

Tarigan S, I. Y. S., Soedjatmiko, S., & Hartanto, R. (2010). Perancangan basis data dan layanan

akses berbasis Service Oriented Architecture (SOA) untuk Dinas Kesehatan Kabupaten

Sleman. Jurnal Buana Informatika, 1(1). https://doi.org/10.24002/jbi.v1i1.293

Vicknair, C., Nan, X., Macias, M., Chen, Y., Zhao, Z., & Wilkins, D. (2010). A comparison of a

graph database and a relational database: A data provenance perspective. Proceedings of the

Annual Southeast Conference. https://doi.org/10.1145/1900008.1900067

Yamazaki, R., Sakata, S., Oshima, T., Sueoka, M., Totsuka, T., Kawamata, Y., & Suzuki, T.

(2020). Development of JT-60SA experiment database system. Fusion Engineering and

Design, 155. https://doi.org/10.1016/j.fusengdes.2020.111555