Aplikasi Database Untuk Mengelola Persediaan Barang di Toko Baju D’Clothing Menggunakan Pendekatan Entity Relationship Chart

Frea Marva Zerlinda; Muhammad    Zulfa Zaidan; Fisrawati; Novia   Hadias Safitri; Muhammad  Fathan Nabil Al-Badi

doi:10.59897/jsi.v4i1.124

Frea Marva Zerlinda IPB University
Muhammad Zulfa Zaidan Industrial Management Study Program, School of Vocational Studies, IPB University
Fisrawati Industrial Management Study Program, School of Vocational Studies, IPB University
Novia Hadias Safitri Industrial Management Study Program, School of Vocational Studies, IPB University
Muhammad Fathan Nabil Al-Badi

DOI: https://doi.org/10.59897/jsi.v4i1.124

Keywords: Database, primary key, relationship, Query

Abstract

D’Clothing store is one of the clothing stores located in Bogor that provides many choices for various ages, both women and men. Based on the interviews, D'Clothing store had some troubles in product management, starting from inventory data, suppliers data, sales data, et cetera. To overcome this problem, a new system is needed to facilitate management by utilizing technological products, which as creating a database. The output of this database is to make a form containing the name, stock, color, size, code, and price of the goods. In its preparation, there are several obstacles such as data being out of sync between the main table and other tables when building a relationship. After being analyzed, this issue happens due to the wrong placement of the primary key and records between tables. Another error is found in the placement of the formula when building the Query design. Therefore, it takes precision and logic to find a way out.