Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal JISICOM (Journal of Information System, Infomatics and Computing)
Heroe Santoso
Universitas Bumigora, Nusa Tenggara Barat
Computer Science & IT

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

Found 1 Documents
Search

 1 
Implementasi Teknik Normalisasi Basis Data untuk Menghindari Redundansi Data pada Sistem Penjualan Suriyati Suriyati; Heroe Santoso; Muhamad Azwar; Miftahul Madani; Ismarmiaty Ismarmiaty; Muhammad Innuddin; Mudawil Qulub; I Made Yadi Dharma; Muhamad Wisnu Alfiansyah
Journal of Information System, Informatics and Computing Vol 10 No 1 (2026): JISICOM (June 2026)
Publisher : Sekolah Tinggi Manajemen Informatika dan Komputer Jayakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52362/jisicom.v10i1.2354

Abstract

In today's digital era, efficient information management is key to a business's operational success. In the sales sector, high transaction volumes generate vast amounts of data daily. However, many sales systems still face a classic data architecture problem: data redundancy, or unnecessary duplication of information. Data redundancy is not simply a matter of inefficient storage; it directly impacts the emergence of data anomalies. When the same data is stored in multiple locations, the risk of information inconsistency during updates, deletions, and insertions is very high. Inconsistent data can mislead management in decision-making, for example, errors in inventory reports or financial recapitulations. The main objective of this research is to eliminate data redundancy and prevent anomalies in the sales system to ensure information integrity. Through systematic table organization, this research seeks to create a more efficient and accurate database architecture to support management decision-making. The method used is structured analysis through data decomposition stages. The process begins with collecting raw (unnormalized) transaction data, which is then processed through the 1NF, 2NF, and 3NF stages. The final stage involves validating the Create, Read, Update, and Delete (CRUD) functions to ensure the consistency of the new schema. The desired result is an optimal relational database schema, where data is logically distributed into specific, interconnected tables. This implementation will result in a lighter system, efficient storage usage, and error-free sales reporting.
Co-Authors I Made Yadi Dharma Ismarmiaty Ismarmiaty Miftahul Madani Mudawil Qulub Muhamad Azwar Muhamad Wisnu Alfiansyah Muhammad Innuddin Suriyati Suriyati