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
Zaidan Prihantoro
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 dan Pemodelan Basis Data untuk Sistem Informasi Manajemen Bengkel Mobil Zaidan Prihantoro; Yohanes Hasiolan; Edwardus Imanuel; 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.p03

Abstract

The development of information technology currently demands efficiency in various industrial sectors, including automotive service businesses such as car repair shops. Most conventional workshops still rely on paper-based manual transaction recording for their daily operations. This unintegrated operational system often triggers major obstacles, such as the risk of losing physical receipts, inaccuracies in tracking spare part stock, and difficulties in compiling monthly revenue reports quickly. This study aims to build a database design model for a Car Workshop Management System capable of automating the business’s daily bookkeeping process. The research method used is descriptive qualitative, focusing on system development through a three-level structured database modeling approach. The results are outlined into three main diagrams: Entity Relationship Diagram (ERD), Conceptual Data Model (CDM), and Physical Data Model (PDM). The database structure is thoroughly designed by integrating admin and report entities, allowing the operational transaction data recapitulation process to generate revenue information automatically and instantly. The implementation of an intermediary table in the form of transaction details proves effective in preventing data redundancy. Overall, this database design is ready to be implemented on a DBMS to improve work efficiency and support workshop managerial decision-making.
Co-Authors Edwardus Imanuel Niqotaini, Zatin Yohanes Hasiolan