Ban Phet Phaiwan Drinking Water Distribution Information System

Abstract

This research aims to analyze, design, and develop an information system for the production and distribution of drinking water by Ban Phet Phaiwan Village. The study follows the principles of the System Development Life Cycle (SDLC), encompassing data collection, system analysis using Data Flow Diagrams (DFDs), Entity-Relationship Diagrams (ERDs), and web-based system development using MySQL and PHP. The system was assessed through a satisfaction survey involving a sample of 60 participants. The research findings indicate that the developed system accurately and effectively meets the needs of the sample group, assisting in the management of data and workflow processes compared to traditional methods of recording information on paper. The overall satisfaction level of the sample group was high ( = 4.39, S.D. = 0.68), particularly regarding 1) processing that meets user requirements and  2) ease of data access, which had the highest satisfaction levels ( = 4.55, S.D. = 0.62, and   = 4.55, S.D. = 0.69). However, the suitability of the report format received the lowest satisfaction rating ( = 4.20, S.D. = 0.93). This system is capable of integrating database management and automation, contributing to increased reliability and scalability for future developments. This study demonstrates the potential of a specifically designed information system to improve workflow processes in community organizations and can serve as a model for application in other contexts. The developed system contributes to enhancing service delivery and supports economic development at the community level through efficient management of drinking water distribution.