Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Nasional Teknologi Informasi dan Aplikasinya
Andhika Galang Adisaputro
Universitas Pembangunan Nasional "Veteran" Jakarta
Computer Science & IT Engineering

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

Found 1 Documents
Search

 1 
Perancangan Basis Data Inventaris dan Transaksi pada Reda Printing Berbasis Single Admin Andhika Galang Adisaputro; Ignatius Gavrilla Reda; Diaz Kahfi Baldan; Zatin Niqotaini
Jurnal Nasional Teknologi Informasi dan Aplikasinya Vol. 4 No. 4 (2026): JNATIA Vol. 4, No. 4, Agustus 2026
Publisher : Informatics Department, Faculty of Mathematics and Natural Sciences, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/JNATIA.2026.v04.i04.p01

Abstract

Reda Printing is a printing business that still relies on manual recording for raw material inventory and operational transactions. This condition causes various issues, such as stock mismatches, sudden depletion of production materials, and the absence of a structured transaction track record, which ultimately burdens the management that relies heavily on a single administrator. This study presents the design of an integrated relational database system to address these problems. The design was carried out through three main stages: Entity Relationship Diagram (ERD) for logical modeling, Conceptual Data Model (CDM) as a conceptual representation, and Physical Data Model (PDM) for technical implementation. This system integrates five core entities—Barang, Supplier, Transaksi_Masuk, Order, and Detail_Order—which are implemented into MySQL. The added value of this design is the application of database-level automation using Triggers and Views, which function to update stock automatically and provide early warnings (smart alerts) when stock reaches its minimum limit. The results of this database design are expected to serve as the foundation for developing a reliable, accurate, and efficient operational information system to support Reda Printing's productivity.
Co-Authors Diaz Kahfi Baldan Ignatius Gavrilla Reda Niqotaini, Zatin