Article Per Year (5 Year)
p-Index From 2021 - 2026
7.258
P-Index
This Author published in this journals
All Journal Jurnal Ilmiah Informatika Komputer Techno.Com: Jurnal Teknologi Informasi Jurnal Informatika dan Teknik Elektro Terapan JAIS (Journal of Applied Intelligent System) SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan Batoboh : Jurnal Pengabdian Pada Masyarakat Jurnal Manajemen Informatika Jurnal Kridatama Sains dan Teknologi JATI (Jurnal Mahasiswa Teknik Informatika) Jurnal Sistem Komputer & Kecerdasan Buatan Parameter BERNAS: Jurnal Pengabdian Kepada Masyarakat Jurnal Sistem Informasi dan Sistem Komputer JURNAL REKAYASA INFORMASI SWADHARMA (JRIS) JURNAL ELEKTRO DAN INFORMATIKA SWADHARMA (JEIS) Jurnal Pengabdian Teknologi Tepat Guna Jurnal Difusi Jurnal Pengabdian Masyarakat IPTEK Seminar Nasional Hasil Riset dan Pengabdian (SNHRP) Journal of Economic, Business and Engineering (JEBE) Jurnal Pengabdian kepada Masyarakat Desa (JPMD) Toba: Journal of Tourism, Hospitality, and Destination Dulang: Jurnal Pengabdian Kepada Masyarakat Journal of Artificial Intelligence and Engineering Applications (JAIEA) Jurnal Sains Informatika Terapan (JSIT) Jurnal Pengabdian Masyarakat Bhinneka SAINSTECH: Jurnal Penelitian dan Pengkajian Sains dan Teknologi Dharma Pengabdian Perguruan Tinggi (DEPATI) Journal of Artificial Intelligence and Digital Business Mestaka: Jurnal Pengabdian Kepada Masyarakat Innovative: Journal Of Social Science Research TAMIKA: Jurnal Tugas Akhir Manajemen Informatika & Komputerisasi Akuntansi Journal of Data Science Theory and Application AL-KARIM: Journal of Islamic and Educational Research Jurnal Pengabdian Kepada Masyarakat (JPKM) Al-Nizam: Indonesian Journal of Research and Community Service Jurnal Intelek Dan Cendikiawan Nusantara EDUJAVARE: International Journal of Educational Research Jurnal Tarreang: Tren Pengabdian Masyarakat Agrokompleks Inovasi Gagasan Abdimas & Kuliah Kerja Nyata WISDOM : Jurnal Pengabdian Kepada Masyarakat Wisdom LogicLink: Journal of Artificial Intelligence and Multimedia in Informatics Fundamentum: Jurnal Pengabdian Multidisiplin Academic Journal of Islamic Principles and Philosophy Jurnal Pengabdiaan Masyarakat Larisma Journal of Community Research & Engagement (JCRE) Jipmas : Journal Inovasi Pengabdian Masyarakat DCS: Jurnal Pengabdian Masyarakat Man-Ana Smart Humanity: Jurnal Pengabdian Masyarakat JES-TM Social and Community Service Jurnal Teknologi Pendidikan NJCOM: Community Service Journal BHAKTI Bhinneka
Imam Prayogo Pujiono
UIN K.H. Abdurrahman Wahid Pekalongan, Pekalongan, Indonesia
Religion Agriculture, Biological Sciences & Forestry Arts Humanities Automotive Engineering Biochemistry, Genetics & Molecular Biology Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Dentistry Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Environmental Science Health Professions Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Mathematics Mechanical Engineering Medicine & Pharmacology Neuroscience Nursing Public Health Social Sciences Veterinary Other

Published : 60 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : JURNAL REKAYASA INFORMASI SWADHARMA (JRIS)

 1 
OPTIMALISASI BASIS DATA SISTEM KEUANGAN UMKM PIZZAUPPS UNTUK MENGATASI REDUDANSI DAN ANOMALI DATAI DATA Faiz, Muhammad; Raharjo, Karunia; Agus, Muhammad; Nur, Muhammad Zidni; Nugroho, Dicky Anggriawan; Pujiono, Imam Prayogo
JRIS : Jurnal Rekayasa Informasi Swadharma Vol 6, No 1 (2026): JURNAL JRIS EDISI JANUARI 2026
Publisher : Institut Teknologi dan Bisnis (ITB) Swadharma

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.56486/jris.vol6no1.1049

Abstract

Digital financial systems are crucial for MSMEs to improve the efficiency and accuracy of record-keeping. Unfortunately, many MSMEs, including PizzaUpps, still rely on poorly structured flat-file record-keeping systems. This condition causes serious problems, such as duplication of customer and product data, and inconsistencies in transaction information, due to the lack of integrity controls in their databases. To address this, this study aims to redesign and optimize the database architecture of PizzaUpps’ financial system. Using the Waterfall model, the main methodology is database normalization, which transforms the data structure from unnormalized form (UNF) to Third Normal Form (3NF) and Boyce-Codd Normal Form (BCNF). The results show that the normalization process successfully produces a new, structured relational database design. This design consists of interconnected main tables, including Customer, Product, Transaction, and Transaction_Detail, and is supported by an Entity Relationship Diagram (ERD) and a validated physical relationship schema. Foreign keys and referential integrity constraints ensure data integrity across tables. The proposed database design proved effective in eliminating data redundancy and anomalies, significantly improving the accuracy, consistency, and integrity of PizzaUpps’ financial data. This design is highly recommended as a basis for developing a more comprehensive digital financial or accounting information system in the future.Peran sistem keuangan digital sangat krusial bagi UMKM untuk meningkatkan efisiensi dan keakuratan pencatatan. Sayangnya, banyak UMKM, termasuk PizzaUpps, masih mengandalkan sistem pencatatan flat-file yang tidak terstruktur dengan baik. Kondisi ini menyebabkan masalah serius seperti duplikasi data pelanggan dan produk, serta inkonsistensi informasi transaksi, karena tidak adanya kontrol integritas pada basis data mereka. Untuk mengatasi hal ini, penelitian ini bertujuan untuk merancang ulang dan optimalisasi arsitektur basis data sistem keuangan PizzaUpps. Menggunakan model Waterfall, metodologi utamanya adalah normalisasi basis data, yaitu mentransformasikan struktur data dari bentuk tidak ternormalisasi (UNF) menjadi Third Normal Form (3NF) dan Boyce-Codd Normal Form (BCNF). Hasil penelitian menunjukkan bahwa proses normalisasi berhasil menciptakan desain basis data relasional yang baru dan terstruktur. Desain ini terdiri dari tabel-tabel utama yang saling terhubung, seperti Pelanggan, Produk, Transaksi, dan Detail_Transaksi, dan dilengkapi dengan Entity Relationship Diagram (ERD) serta skema relasi fisik yang tervalidasi. Integritas data antar tabel dijamin melalui penggunaan foreign key dan batasan integritas referensial. Desain basis data yang diusulkan terbukti efektif dalam menghilangkan redundansi dan anomali data, secara signifikan meningkatkan akurasi, konsistensi, dan integritas data keuangan PizzaUpps. Desain ini sangat direkomendasikan sebagai dasar untuk pengembangan sistem informasi keuangan atau akuntansi digital yang lebih lengkap di masa depan.
Co-Authors A'izatul Haira, Nala Abdi Cahya Subekti Abdul Majid Abu Hanif I. F. Adhiel, Adhiel Rahma Agung Prihandono Agustin, Amelya Agustina, Risma Wati Agyztia Premana Ahmad Abdussalaam Ahmad Aufal Marom Ahmad Burhanuddin, Ahmad Ahmad Ta'rifin Ahmad Turmudi Aisyah Aisyah Ajib Susanto Alfisyah, Ahmad Ammarulloh, Satriaji Andy Rachman Anugrah, Anggita Dwi Anwar, M. Shokhib Anzaini, Sayla Salma Apriani, Nadisa Ardansyah , Dawam Ardhiartha P.U., Surya Asfahani, Asfahani Aulia Miza, Nur Ayon Diniyanto Bangkit Rizka Hidayatullah Brilianu Sentanu Vito Christy Atika Sari Darutama, Ardiyan Dea Karuniawati Desi Lestari, Desi Desta Adyangga Saputra Diah Puspitaningrum Dian Sukmawati Sudrajat Dicky Anggriawan Nugroho Edi Suharyadi Eka Puji Rahayu Eko Hari Rachmawanto Elvina Rizqi Emi Nurlaela Erwin Erwin Fachri Ali Fachri Ariza, Said Fadilah Zahra Dwi Kinanti Fadilah, Gita Faiz, Muhammad Fasyih, Muhammad Rofi Nur Fatkhatun Naela Ferida Rahmawati Fiantika Mutia Rahma Fida Maisa Hana Firda Aulia Izzati Firdausi, Muh Izzat Firdausi, Muhammad Izzat Fitroh, Qorry Aina Furqon Lanang Habibah, Adinda Destiani Haiqa Virly Azzahra Hakim Elkominoki, M. Lukman Hamdi Yahya, Muhammad Hikmah Sofyan, Nurul Himawan, Inggil Ibnu Utomo Ihsan, Fuad Naufal Ihsanul Ahadin, Akbar Ikhsanuddin, Rohmatulloh Muhamad Imas Saffanatul Aminah Indra Kurniawan Irfan Ali, Muhammad Jainul Arifin Jainul Arifin Kuat Ismanto Lilik Riandita Lukman Shodik M. Adin Setyawan M. Akmal Fatkhan Rifqi M. Arsyad Alkadafi M. Azka Failandri M. Syaifuddin Maesyaroh Mochamad Iskarim Moh. Syaifuddin Mohammad Syaifuddin Mufidah, Haniatul Muhamad Ridwan Muhammad Agus Muhammad Anifan Muhammad Rikzam Kamal Muhammad Rikzam Kamal Muhammad Risqi Agung Pratama Musyaffa, Muhammad Zaki Mutiara Sofia Ramadhani Nazwa, Nazwa Gista Aulia Nisa , Nabila Luthfiyatun Noorma Fitriana M. Zain Nugroho, Dicky Anggriawan Nur Fatikhatul Jannah Nur Fatmaluna, Shabina Nur, Muhammad Zidni Nurul Hikmah Sofyan Nurwijayanti Oktaviani, Linda Pasha Ferbitama Perdana, Firdaus Prabowo, Dimas Setiaji Prayogi, Arditya Putri, Adhystha Az-Zahra QURROTA A’YUN Raharjo, Karunia rahayu, eka puji Rahmawan Bagus Trianto Rangga Dzikri Fardiarsyah Rhischa Assabet Shilla Rhischa Assabet Shilla, Rhischa Assabet Riandita, Lilik Richa Qonitatin Lazaba Riki Nasrullah Riki Nasrullah Riyadi, Ridho Rizal, Muhamad Rizaludin Rofiah, Nurul Hidayati Rohmad Abidin Rohmah, Syifa Rohmatulloh Muhamad Ikhsanuddin Sabrina, Arum Rahma Putri Saffanatul Aminah, Imas Safinatunaja , Dhifa Saizi, Muhammad Salman Salma, Salma Aulia Shofiani, Rissa Singgih Setiawan Singgih Setiawan Singgih Setiawan Sofia, Lailatul Sofiana, Sofa Sopiah, Sopiah Syaifuddin, Moh Sylva Fahri Nailannaja Syukron, Akhmad Aufa Tiara Ananda Maulidia Tsalisa Yuliyanti Turmudi, Ahmad Ummy Fatimah Utomo, Surya Ardhiartha Putro Widodo Hami Wijanarto Wijanarto Winarsih, Nurul Anisa Sri Yasmin, Nazhifa Naura Yoga Religia Zahwa Arizza Arthamevia Zuhrufillah, Khafifah Zulmi Aulia Azhari Abbas