Bicol University
College of Science
Special Topics in IT
Research Review 2: Database Management System
Royland V. Pepaño
Title: Database Management System Design with Time Series Modification for Child
Growth and Malnutrition Monitoring in The Regency of Serdang Bedagai
Authors: Reza Rahutomo, Ika Nurlaila, Anzaludin Samsinga Perbangsa, and Bens
Pardamean
Proceedings: 2020 International Conference on Information Management and
Technology (ICIMTech) DOI: 10.1109/ICIMTech50083.2020.9211170
Summary
The paper focused on implementing the author's database system design to
provide an efficient way of handling the data in Child Growth and Malnutrition
Monitoring in Serdang Bedagai Regency, Indonesia. The authors created a new
database design that enables the time-series monitoring of children's physical growth.
The system is based on Connoly and Begg's principles in database system
development and was built through a 3-steps design: the conceptual, followed by
logical and lastly, the normalizations-enriched physical design to efficiently manage
the data being generated by the participants in the monitoring program.
Problem/s
Stunting refers to a child who is too short for his or her age.
The main problem presented in the study is the unavailability of an efficient
database in the regency to help the public health office document and monitor
children's physical growth in the targeted population. As a consequence, no proper
intervention has properly formulated to reverse the bad impact of stunting. Formulating
a new database design with time series modification allows the authors to effectively
and efficiently monitor every bit of superficial growth increase among participants. The
proposed solution was purposely made to provide accountable and consistent data
management to achieve the national zero stunting goal.
Solution/s and Simulation/s
The author's database design is comprising of conceptual, logical, and physical
designs. It has a data dictionary, a working Entity-Relationship Model (ERM), and user
views. The conceptual design precisely formatted the operational activity-based
concept, which produces entities, attributes, and relationships needed for ER
Modeling. The logical design role is to translate the conceptual design into the logical
structures in which the relations between entities are formatted and developed. Lastly,
the physical design role is to convert the logical design into physical forms to be
implemented in the target Database Management System (DBMS). It's set to define
