INTERNATIONAL JOURNAL OF LATEST TECHNOLOGY IN ENGINEERING,
MANAGEMENT & APPLIED SCIENCE (IJLTEMAS)
ISSN 2278-2540 | DOI: 10.51583/IJLTEMAS | Volume XIV, Issue I, January 2025
www.ijltemas.in Page 199
The three-tier architecture was the organization of software applications into three logical and physical computing tiers, which
included the presentation (user interface), the application (data processing), and the data tier (management of data)
[9]
.
The E-Ligtas system was built on a three-tier architecture, providing efficient and secure reporting and management of child-at-
risk cases. Accessible through web browsers and mobile applications, the user interface was located at the presentation tier. The
interface enabled users, including those who are concerned or social workers, to submit reports, track the progress of cases, and
receive real-time messages to interact with designated MSWDO personnel
[12]
. The user interface was designed to be easy to
navigate and interact with, utilizing React.js and Tailwind CSS for optimal responsiveness. Moreover, this tier involved role-
based access, which means that reporters, admins (staff), and super admin (Officer-in-Charge) also have the privilege of carrying
out their assigned duties
[9]
.
E-Ligtas handled the business logic needed to handle child welfare cases efficiently at the application tier. Unlike the usual user
registration process, the system provided both anonymity and confidentiality by automatically creating a unique transaction ID for
each report submitted. This transaction ID empowered reporters to stay informed about their case's progress without revealing
personal information while also maintaining their privacy and safety. It also facilitated report assignment, where the officer-in-
charge assigned cases to the appropriate staff according to barangay location or case urgency. It also included automated priority
so that critical cases were flagged for immediate attention
[9]
.
At the data tier, E-Ligtas was tasked with securely storing and managing case reports, system records, and administrative data. By
using Firebase Realtime Database, the system provides efficient data storage and allows for real-time synchronization across
various devices
[9]
. This tier was built to uphold data integrity and security, ensuring that only authorized personnel, such as super
admins and admins, had access to and could manage case-related information. Although the system did not allow reporters to
retrieve data, it guaranteed that case details were securely stored for monitoring and future references by authorized users. The
data tier also supported exporting through a downloadable intake sheet feature, enabling admins to create Excel or PDF files for
record-keeping, documentation, and backup purposes. This capability assisted the Municipal Social Welfare and Development
(MSWD) personnel in maintaining both physical and digital archives for compliance and review. Furthermore, by employing a
scalable database structure, E-Ligtas is well-equipped for future enhancements, ensuring it could adapt as new features and
reporting requirements arise. This tier was essential in supporting child protection efforts by facilitating accurate record
management and secure case handling.
The three-tier architecture of the system offered a structured, secure, and effective system for reporting cases involving children
at risk. The presentation tier focused on accessibility and user-friendliness, the application tier managed intricate business logic
and facilitated real-time communication, while the data tier provided well-organized and secure storage for case reports. This
setup ensured that child welfare cases were handled swiftly, reducing delays and improving the efficiency of the MSWDO’s case
management process.
V. Conclusion
The development of E-Ligtas: A Reporting System for Child at Risk Cases for the MSWDO in Bani, Pangasinan represented a
major step forward in improving child protection and welfare services in the area. The system responded to the urgent need to
update outdated methods that were cumbersome and inefficient. With features like case reporting, a case status tracker, an
information dissemination homepage, a tally of cases per barangay, and mobile accessibility, E-Ligtas greatly enhanced the
accuracy and speed of data management, thus increasing the overall efficiency and effectiveness of the Municipal Social Welfare
and Development Office (MSWDO). The implemented system was built on a strong three-tier architecture, allowing each layer—
presentation, application, and data—to be developed, upgraded, and scaled independently as necessary. This design fostered a
resilient and adaptable system that can respond to changing needs. Usability testing and feedback from MSWD personnel and
community members highlight the system’s acceptability and its potential to enhance child safety and welfare.
Reference
1. P. Welbourne and J. Dixon, "Child protection and welfare: cultures, policies, and practices," European Journal of Social
Work, 2023.
2. Britannica, "child welfare," [Online]. Available: https://www.britannica.com/topic/child-abuse. [Accessed 2024].
3. J. Dantoni, "Operational Reporting: Types, Examples, and Best Practices," 2022. [Online]. Available:
https://www.netsuite.com/portal/resource/articles/data-warehouse/operational-reporting.shtml. [Accessed 2024].
4. E. Lavelle, "Manual process vs automated process: Which is better?," 2021. [Online]. Available:
https://www.enable.com/blog/manual-process-vs-automated-process-which-is-better. [Accessed 2024].
5. E. Gustafsson-Wright, S. Osborne and M. Aggarwal, "DIGITAL TOOLS FOR REAL-TIME DATA COLLECTION IN
EDUCATION," 2022. [Online]. Available: https://www.brookings.edu/articles/digital-tools-for-real-time-data-
collection-in-education/. [Accessed 2023].
6. Prashant, "Modified Waterfall in Software Engineering| Modified Waterfall," [Online]. Available:
https://radhikaclasses.com/waterfall-model-in-software-engineering/. [Accessed 2024].
7. actiTIME, "Waterfall Model: What Is It, When and How to Use It?," 2022. [Online]. Available:
https://www.actitime.com/project-management/what-is-waterfall-model. [Accessed 2024].