Perancangan Basis Data Sistem Reservasi Wisma Universitas Terbuka dengan Metode Database Life Cycle

Authors

  • Denisha Trihapningsari Universitas Terbuka
  • Mayang Anglingsari Putri Universitas Terbuka

DOI:

https://doi.org/10.32493/jtsi.v7i4.45421

Keywords:

reservation system; database design; database life cycle

Abstract

The current of wisma’s Universita Terbuka reservation system still faces various obstacles, especially related to data consistency and integrity anomalies. This problem causes errors in recording and confusion in the transaction process, such as duplication of invoice numbers, which in turn can reduce reporting accuracy. This research aims to design a basis data for the Open University guesthouse reservation system using the Basis data Life Cycle (DBLC) method. This method includes several stages, starting from needs analysis, conceptual, logical, and physical basis data design. The results show a well-structured and optimized basis data design, which supports the management of reservation data, check-in, check-out, and room reservation management. The normalization process to achieve Third Normal (3NF) ensures that the data is free from redundancy and remains consistent. The physical model of the basis data is implemented using SQL queries, which are ready to be applied to a Basis data Management System (DBMS). The designed basis data is expected to improve operational efficiency, record accuracy, and maintain data integrity in the Open University guesthouse reservation system. This research is also expected to contribute to the development of literature on systematic life cycle-based basis data design.

References

Amalya, D., & Udariansyah, D. (2019). Perancangan Basis Data Sistem Informasi Akademik Pada Smk Negeri 8 Palembang Menggunakan Semantic Object Model. Bina Darma Conference on Computer Science, 2685–2683.

Amijaya, A., Ferdinandus, F., & Bayu, M. (2019). Sistem Pendukung Keputusan Pemilihan Handphone Dengan Metode Simple Additive Weighting Berbasis WEB. Jurnal Teknik Informatika, Sistem Informasi, Dan Ilmu Komputer, 8(2), 102. https://doi.org/10.47047/ct.v8i2.47

Andika Widyanto, Khotop, Hendra Effendi, & Agung Pratama EH. (2022). Desain Model Database E-Commerce SLB Pembina Palembang dengan Menerapkan Metode Database Life Cycle. Seminar Nasional CORISINDO.

Angelin, M., & Prasetiya, H. P. (2021). Prosiding Seminar Nasional Universitas Ma Chung Sistem Informasi Manajemen pada Toko Bangunan (Studi Kasus: TB Al-haidar Kabupaten Malang). Prosiding Seminar Nasional Universitas Ma Chung, 44–60.

Bahtiar, Y., & Herwanto, D. (2022). Perancangan Basis Data Penjualan dengan Metode Database Lifecycle pada Toko Lancar Elektronik. STRING (Satuan Tulisan Riset Dan Inovasi Teknologi), 7(2).

Fajar, M. A., Afifah, S., Nugraha, B. K. S., Sari, I. N., Sakinah, A., & Ariq, M. R. F. (2024). Perancangan Basis Data Open Trip Pendakian Gunung pada Sukatraveler.id dengan Metode DBLC. Jurnal Simasi: Jurnal Ilmiah Sistem Informasi, 4(1), 1–14.

Gunawan, S. A., Rostianingsih, S., & Setiawan, A. (2019). Pencatatan dan Penghitungan Skor Pada Olahraga AAIPSC dengan NFC Berbasis Android. Jurnal Infra, 7(2), 250–255. https://publication.petra.ac.id/index.php/teknik-informatika/article/view/8883

Hardiansyah, A. D., & Dewi, C. N. P. (2020). Perancangan Basis Data Sistem Informasi Perwira Tugas Belajar (Sipatubel) Pada Kementerian Pertahanan. Senamika, 1(2), 222–233.

Kurnianti, A., Angguningtyas, & Isnanda, R. G. (2017). Perancangan Database Pada Sistem Asessmen Dan Pemetaan Hasil Asessmen Berbasis Tag Sebagai Pembantu Penyusunan Strategi Pembelajaran. Jurnal Ilmiah Semesta Teknika, 20(2), 106–115. https://doi.org/10.29103/tts.v2i3.5770

Mannino, M. (2019). Database Desain, Application Development & Administration. McGraw-Hill.

Melany, M., Nur, R., & Aryani, D. (2020). Pemodelan Basis Data Pada Sistem Informasi Laporan Kinerja Program Studi (LKPS) Berbasis Instrumen Akreditasi Program Studi (IAPS 4.0). Seminar Nasional Teknik Elektro …, 6. http://jurnal.poliupg.ac.id/index.php/sntei/article/view/2272

Pradipta, R. A., Wintoro, P. B., & Budiyanto, D. (2022). Perancangan Pemodelan Basis Data Sistem Informasi Secara Konseptual Dan Logikal. Jurnal Informatika Dan Teknik Elektro Terapan, 10(2). https://doi.org/10.23960/jitet.v10i2.2541

S.H. Felix, L., & G.Tiur. (2021). Model Perancangan Aplikasi Konsultasi Pengobatan Herbal. Journal Strategi.

Samidi, S., & Hidayat, R. (2023). Desain Model Database Mutasi Siswa Dengan Menerapkan Metode Database Life Cycle. Technomedia Journal, 8(2SP), 221–235. https://doi.org/10.33050/tmj.v8i2sp.2063

Titik Rahmawati, Eka Yulia Sari, Anjasmara Tanjung Shakti, & Atthaya Nanda Yomura. (2023). Analisis Perancangan Database Managemen Sistem Untuk Sistem Penunjang Proses Bisnis Wedang Uwuh Instan. TEKNIMEDIA: Teknologi Informasi Dan Multimedia, 4(1), 61–69. https://doi.org/10.46764/teknimedia.v4i1.104

Tri Amri Wijaya, Constantin Menteng, Afis Julianto, Adi Surya, & Ema Utami. (2021). 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 ). Jurnal Teknologi Informasi: Jurnal Keilmuan Dan Aplikasi Bidang Teknik Informatika, 15(1), 72–81. https://doi.org/10.47111/jti.v15i1.1867

Jurnal Teknologi Sistem Informasi dan Aplikasi Vol. 7 No. 4 Oktober 2024

Downloads

Published

2024-10-31

How to Cite

Trihapningsari, D., & Putri, M. A. (2024). Perancangan Basis Data Sistem Reservasi Wisma Universitas Terbuka dengan Metode Database Life Cycle. Jurnal Teknologi Sistem Informasi Dan Aplikasi, 7(4), 1638–1646. https://doi.org/10.32493/jtsi.v7i4.45421

Issue

Vol. 7 No. 4 (2024): Jurnal Teknologi Sistem Informasi dan Aplikasi

Section

Article

License

Copyright (c) 2024 Denisha Trihapningsari, Mayang Anglingsari Putri

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Authors who publish with this journal agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).

Jurnal Teknologi Sistem Informasi dan Aplikasi have CC BY-NC or an equivalent license as the optimal license for the publication, distribution, use, and reuse of scholarly work.

In developing strategy and setting priorities, Jurnal Teknologi Sistem Informasi dan Aplikasi recognize that free access is better than priced access, libre access is better than free access, and libre under CC BY-NC or the equivalent is better than libre under more restrictive open licenses. We should achieve what we can when we can. We should not delay achieving free in order to achieve libre, and we should not stop with free when we can achieve libre.

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International (CC BY-NC 4.0) License

YOU ARE FREE TO:

  • Adapt - remix, transform, and build upon the material for any purpose, even commercially.
  • The licensor cannot revoke these freedoms as long as you follow the license terms