Pengembangan Aplikasi Database Analisa Penjualan pada Perusahaan Maju Makmur
DOI:
https://doi.org/10.59897/jsi.v4i1.123Keywords:
Database, Primary key, Entity Relationship Chart, SalesAbstract
The creation of this database was carried out to develop a sales recording system for salesmen who handle different branches. A Microsoft Access-based database, of course, has primary key components in unique data that will be linked from one table to another. Based on the primary key for each entity, a relationship between data will be formed that will automatically function in various processes, such as making queries to reports. These components will produce an ERC (Entity Relationship Chart) which describes the logic of the database by showing the relationships between entities and their attributes in full. This database will reveal the salesman's ranking including the number of sales and total outlet receipts with accurate and reliable data. The creation of this database is expected to be able to help the Maju Makmur Company on an ongoing basis so that the performance appraisal decision process will be more effective and efficient.
References
Anggraeni, D., Aswati, S., Maulina Azmi, S. R., Akmal, A., Dewi, M., & Anwar, K. (2018). Membangun Database Menggunakan Microsoft Access 2007. Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 1(1), 7–14. https://doi.org/10.33330/jurdimas.v1i1.381
Data, D. M., Data, D. M., & Word, M. (2009). Microsoft Access 2007. Spring, 1–9.
Eckstein, J., & Schultz, B. R. (2017). Introductory Relational Database Design for Business, with Microsoft Access. In Introductory Relational Database Design for Business, with Microsoft Access. https://doi.org/10.1002/9781119430087
Fatin, C. I., Rahmi, T., & Yusra, Z. (2017). Hubungan Persepsi Terhadap Budaya Organisasi Dengan Kinerja Salesman Perusahaan Auto 2000 Bypass Padang. Jurnal RAP UNP, 8(1), 13–23.
Hidayat, A. P., Santosa, S. H., & Siskandar, R. (2022). Penentuan Jumlah Kebutuhan Bahan Baku Berdasarkan Distribusi Barang Ideal di IKM Tepung Tapioka Kabupaten Bogor. Jurnal INTECH Teknik Industri Universitas Serang Raya, 8(1), 23–28. https://doi.org/10.30656/intech.v8i1.4400
Ismai. (2020). Perancangan Basis Data Sistem Informasi Perwira Tugas Belajar (Sipatubel) Pada Kementerian Pertahanan. Senamika, 1(2), 222–233.
Larassati, M., Latukolan, A., Arwan, A., & Ananta, M. T. (2019). Pengembangan Sistem Pemetaan Otomatis Entity Relationship Diagram Ke Dalam Database. Urnal Pengembangan Teknologi Informasi Dan Ilmu Komputer , 3(4), 4059. http://j-ptiik.ub.ac.id
Mohammed, M. A., Abdul Kareem Muhammed, D., & Abdullah, J. M. (2015). International Journal of Multidisciplinary and Scientific Emerging Research Practical Approaches of Transforming ER Diagram into Tables. J. of Multidisciplinary and Scientific Emerging Research, 4(2), 1106–1110. http://www.ijmser.com/
Santosa, H. S., Hidayat, A. P., Ridwan, S., & Rizkiriani, A. (2021). Pengaruh Harga Jual Terhadap Permintaan Telur Ayam Menggunakan Pendekatan Regresi Studi Kasus: Agen Telur ABC. Indonesian Journal of Science, 2(3), 106–112. http://journal.pusatsains.com/index.php/jsi
Santosa, S. H., & Hidayat, A. P. (2019). Model Penentuan Jumlah Pesanan Pada Aktifitas Supply Chain Telur Ayam Menggunakan Fuzzy Logic. Jurnal Ilmiah Teknik Industri, 18(2), 224–235. https://doi.org/10.23917/jiti.v18i2.8486
Santosa, S. H., Hidayat, A. P., & Siskandar, R. (2021). Safea application design on determining the optimal order quantity of chicken eggs based on fuzzy logic. IAES International Journal of Artificial Intelligence, 10(4), 858–871. https://doi.org/10.11591/ijai.v10.i4.pp858-871
Tinggi, Z. S. (2020). Analisis Regresi Linier dan Korelasi menggunakan Pemrograman Visual Basic. Jurnal Ilman: Jurnal Ilmu Manajemen, 8(2), 42–50. http://journals.synthesispublication.org/index.php/ilman
