ANALISIS PERANCANGAN DATABASE MANAGEMEN SISTEM UNTUK SISTEM PENUNJANG PROSES BISNIS WEDANG UWUH INSTAN

Titik Rahmawati; Eka Yulia Sari; Anjasmara Tanjung Shakti; Atthaya Nanda Yomura

doi:10.46764/teknimedia.v4i1.104

Titik Rahmawati Universitas Sarjanawiyata Tamansiswa
Eka Yulia Sari Universitas Sarjanawiyata Tamansiswa
Anjasmara Tanjung Shakti Universitas Sarjanawiyata Tamansiswa
Atthaya Nanda Yomura Universitas Sarjanawiyata Tamansiswa

DOI: https://doi.org/10.46764/teknimedia.v4i1.104

Keywords: Database Design, Conceptual Model, Logical Model, Physical Model, DBSDLC (Database System Development Lifecycle)

Abstract

The use of information technology can support business people in supporting their business processes. Wedang uwuh instan which is a form of creativity for Industrial Engineering students at the Universitas Sarjanawiyata Tamansiswa that managed by PT Sruput Jaya which is a socially and profit-oriented student business unit. The current marketing reach is still offline and in the surrounding environment. The target consumer has not been given the maximum information platform regarding Wedhang Uwuh Instan products so consumer interest is lacking. Therefore it is necessary to make an application to support business processes at PT Sruput Jaya as a portal for online marketing and ordering. The development of such system technology cannot be separated from the development of a database that is used as a place for managing and using data in a running information system. Database development can be done using the DBSDLC (Database System Development Lifecycle) method. There are 3 processes in database design using the DBSDLC method, namely Conceptual Schema Design, Logical Design, and Physical Design. The results of this study are in the form of a business process support system design model at PT Sruput Jaya in the form of marketing applications and instant wedang uwuh online ordering. This model will support further system development.

References

[1] T. Oktavia, “Pemodelan Sistem Basis Data Relasional Pada Unit Operasional Pelayanan Kesehatan,” vol. 2012, no. semnasIF, pp. 229–236, 2012.
[2] R. A. Pradipta, P. B. Wintoro, and D. Budiyanto, “Perancangan Pemodelan Basis Data Sistem Informasi Secara Konseptual Dan Logikal,” J. Inform. dan Tek. Elektro Terap., vol. 10, no. 2, 2022, doi: 10.23960/jitet.v10i2.2541.
[3] M. Ohyver, J. V. Moniaga, I. Sungkawa, B. E. Subagyo, and I. A. Chandra, “The comparison firebase realtime database and MySQL database performance using wilcoxon signed-rank test,” Procedia Comput. Sci., vol. 157, pp. 396–405, 2019, doi: 10.1016/j.procs.2019.08.231.
[4] Gat, “Perancangan Basis Data Perputakaan Sekolah dengan Menerapkan Model Data Relasional,” Citec J., vol. 2, no. 4, pp. 305–3015, 2015.
[5] Nst CPutri NLawita N, “Perancangan Basis Data (Emos Marketplace) Sebagai Transaksi PT. Primarintis Sejahtera.pdf,” J. Pendidik. Tambusai, vol. 5, no. 2, pp. 3771–3781, 2021.
[6] T. A. Wijayaa and E. U. Constantin Mentenga, Adi Suryaa, Afis Juliantoa, “PERANCANGAN DESAIN BASIS DATA SISTEM INFORMASI GEOGRAFIS TANAH PENDUDUK DENGAN MENERAPKAN MODEL DATA RELASIONAL ( STUDI KASUS _ DESA TUMBANG MANTUHE KABUPATEN GUNUNG MAS PROVINSI KALIMANTAN TENGAH ).pdf,” J. Teknol. Inf. (Jurnal Keilmuan dan Apl. Bid. Tek. Inform., vol. 15, no. 1, pp. 72–81, 2021.
[7] Nofiyani, “Model Basis Data Untuk Mendukung Sistem Administrasi Pelayanan dan Perbaikan Motor,” Simp. Nas. Ilm. dengan tema (Peningkatan Kualitas Publ. Ilm. melalui Has. Ris. dan Pe367ngabdian Kpd. Masyarakat), no. November, pp. 367–375, 2019, doi: 10.30998/simponi.v0i0.333.
[8] Nofiyani and Wulandari, “Perancangan Model Basis Data Guna Memonitoring Sistem Produksi,” J. TICOM Technol. Inf. Commun., vol. 11, no. 2, pp. 119–123, 2023.
[9] A. Widyanto, H. Effendi, and A. P. Eh, “Desain Model Database E-Commerce SLB Pembina Palembang dengan Menerapkan Metode Database Life Cycle”.
[10] dan G. A. V. M. G. I.G.D. Dwijayana1, I.G.A. Wibawa2, “RANCANG SKEMA DATABASE DAN IMPLEMENTASI DATABASE MIGRATION PADA APLIKASI PEMINJAMAN RUANGAN.pdf,” JUPITA (Jurnal Pengabdi. Inform., vol. 1, no. 1, pp. 145–154, 2022, [Online]. Available: https://ejournal1.unud.ac.id/index.php/jupita/article/view/136/187
[11] W. S. Prasetya, “Perancangan Model Basis Data Relasional Dengan Metode Database Life Cycle,” Pros. Semin. Nas. Inform. 2015, pp. 91–98, 2015.
[12] M. Melany, R. Nur, and D. Aryani, “Pemodelan Basis Data Pada Sistem Informasi Laporan Kinerja Program Studi (LKPS) Berbasis Instrumen Akreditasi Program Studi (IAPS 4.0),” Semin. Nas. Tek. Elektro …, p. 6, 2020, [Online]. Available: http://jurnal.poliupg.ac.id/index.php/sntei/article/view/2272
[13] G. Hampel, “Preparing The Conceptual Model of a Database,” QUAESTUS Multidiscip. Res. J., vol. 19, pp. 290–304, 2021.