Design of an Integrated Database System for Optimizing Laundry Services

Yemima Monica Geasela, Randy Frederick Leonardy, Andreanus Joe Reynald, Dantacitto Jonatan

Abstract


The rapid advancement of technology has brought significant changes across various sectors, including service industries like laundry. Many laundry businesses still rely on manual, paper-based record-keeping, which is prone to errors, data loss, and inefficiencies in information retrieval. This traditional method also makes it difficult for business owners to monitor transactions and manage customers effectively. Therefore, this study aims to design a database system that can manage laundry transactions more efficiently, accurately, and structurally. The research methodology includes direct observation of laundry operations and a literature review on database systems. The database design process consists of three main stages: conceptual, logical, and physical. In the conceptual stage, key entities such as customers, employees, services, transactions, and memberships are identified. The logical stage implements relational schemas using an Entity-Relationship Diagram (ERD) to ensure entity relationships and eliminate data redundancy. The physical stage involves implementing the database design into a Database Management System (DBMS) and testing through anomaly scenarios in insertion, deletion, and updates to ensure data integrity and consistency. The study results indicate that the designed database system enhances laundry operational efficiency by providing more accurate transaction records, faster data retrieval, and improved data security. The use of constraints in the database helps maintain data validity, reduce duplication risks, and improve system reliability in transaction management. With this system, laundry business owners can easily monitor business activities, enhance service quality, and optimize marketing strategies based on customer data. By implementing a structured database system, laundry businesses are expected to adapt to technological advancements, increase competitiveness, and provide more professional services to customers.

Keywords


Database System, Laundry, Information System, Transaction Management, Information Technology

Full Text:

8i1.8282

References


Atmaja, G., Firmansyah, I. J., Latif, O. H. A., & Saprudin. (2023). Perancangan Sistem Transaksi Laundry Berbasis Website Menggunakan Metode Extreme Programming. Biner : Jurnal Ilmu Komputer , Teknik Dan Multimedia, 1(2), 238–258.

Beno, J., Silen, A. P., & Yanti, M. (2022). Dampak Pandemi COVID-19 Pada Kegiatan Ekspor Impor (Studi Pada PT Pelabuhan Indonesia II (Pesero) Cabang Teluk Bayur). Jurnal Saintek Maritim, 9(2), 356–363.

Cholik, C. A. (2022). Pemanfaatan Google Classroom Dalam Meningkatkan Kualitas Pendidikan Di Era New Normal. NUSANTARA : Jurnal Ilmu Pengetahuan Sosial, 9(2), 239–245. http://jurnal.um-tapsel.ac.id/index.php/nusantara/article/view/6090

Fauzan Natsir, Triyadi, T., & Anggraeni, N. K. P. (2022). Optimalisasi Pemanfaatan Sistem Informasi pada UMKM Beladies Laundry Kiloan. Jurnal Pengabdian Kepada Masyarakat UBJ, 5(1), 53–62. https://doi.org/10.31599/jabdimas.v5i1.961

Geasela, Y. M., Ariawan, E., Lee, F. S., Andry, J. F., & Tanjaya, V. (2025). Rancang Bangun Aplikasi Adopsi Hewan Peliharaan Berbasis Mobile. JATI (Jurnal Mahasiswa Teknik Informatika), 9(1), 1634–1642.

Geasela, Y. M., Hartono, H., Sesilia, M., Winarto, H., & Pratiwi, H. (2022). Analisis Penerimaan Aplikasi Asset Digital Menggunakan Technology Acceptance Model (Tam). JBASE - Journal of Business and Audit Information Systems, 5(2), 30–35. https://doi.org/10.30813/jbase.v5i2.3778

Geasela, Y. M., Wijaya, A., Apriyanti, S., Tanuhariono, V. R., & Andry, J. F. (2023). Optimasi Pengalaman Pengguna Pendekatan Ilmiah Mengukur Kualitas Aplikasi Shopee dengan Metode Webqual 4.0. Jurnal Fasilkom, 13(3), 538–545. https://doi.org/10.37859/jf.v13i3.5828

Haryanto, A. T. (2024). APJII: Jumlah Pengguna Internet Indonesia Tembus 221 Juta Orang. Detikinet. https://apjii.or.id/berita/d/apjii-jumlah-pengguna-internet-indonesia-tembus-221-juta-orang

Kartika, A. D., Jannah, M. R., Putri, I. Y., Perdana, A. R., & Maizardi, F. (2023). Jurnal Indonesia : Manajemen Informatika dan Komunikasi Menggunakan Aplikasi Zahir Accounting Jurnal Indonesia : Manajemen Informatika dan Komunikasi. 4(3), 1511–1522.

Monisa, M. (2013). Persepsi Kemudahan Dan Kegunaan Opac Perpustakaan Unair. Universitas Airlangga, 1–16. http://journal.unair.ac.id/download-fullpapers-Jurnal Martina.pdf

Nurcahyawati, V., Muhamad Risqiwahid, & Achmad Arrosyidi. (2023). Optimasi Penjadwalan Mata Pelajaran menggunakan Constraint Programming. Jurnal Informatika Dan Teknologi Informasi, 1(3), 118–124. https://doi.org/10.56854/jt.v1i3.134

Rizqy, M., Zachani, N. S. A., Fajri, S., & Suryandari, M. (2023). Pengaruh Media Teknologi Informasi Modern Terhadap Aktivitas Dakwah di Era Revolusi Industri 4.0. ALADALAH: Jurnal Politik, Sosial, Hukum Dan Humaniora, 1(1), 22–42. https://doi.org/10.59246/aladalah.v1i1.146

Safwandi, S.T., M. K. (2021). Perancangan Database Pada Sistem Asessmen Dan Pemetaan Hasil Asessmen Berbasis Tag Sebagai Pembantu Penyusunan Strategi Pembelajaran. Jurnal Teknologi Terapan and Sains 4.0, 2(No 3), 1–15. https://ojs.unimal.ac.id/tts/article/view/5770

Syahputri, K., Irwan, M., & Nasution, P. (2023). Peran Database Dalam Sistem Informasi Manajemen. Jurnal Akuntansi Keuangan Dan Bisnis, 1(2), 54–58. https://jurnal.ittc.web.id/index.php/jakbs/article/view/36

Utomo, Y. B., Kurniasari, I., & Yanuartanti, I. (2023). Penerapan Knowledge Discovery in Database. Jurnal Teknik Informatika Kaputama (JTIK), 7(1).

Wijayanti, T. P., Sipayung, E. M., Thenata, A. P., & Riyanne, C. (2024). Analisis UI / UX Portal Akademik Universitas XYZ Menggunakan Metode Heuristic Evaluation. Jurnal of Business and Audit Information System (JBASE), 7(2), 1–12. https://doi.org/dx.doi.org/ 10.30813/jbase.v7i1.5784




DOI: http://dx.doi.org/10.30813/jbase.v8i1.8282

Refbacks

  • There are currently no refbacks.


ISSN: 2620-7907


View My Stats