PERANCANGAN DESAIN BASIS DATA SEMINAR HASIL BERBASIS DBLC DENGAN INTEGRASI KALENDER DOSEN DAN NOTIFIKASI OTOMATIS UNTUK EFISIENSI DAN TRANSPARANSI PENJADWALAN

Khansa Firyal Adiilaa; Aurelia Callysta Mamahit; Diva Kurnianingtyas, Dr., S.Kom.

doi:10.47111/jti.v20i1.22986

Authors

Khansa Firyal Adiilaa Adiila
Aurelia Callysta Mamahit Mahasiswa Prodi Teknologi Informasi, Fakultas Ilmu Komputer, Universitas Brawijaya
Diva Kurnianingtyas, Dr., S.Kom. Dosen Fakultas Ilmu Komputer, Universitas Brawijaya

DOI:

https://doi.org/10.47111/jti.v20i1.22986

Keywords:

Database Design, Data Base Life Cycle

Abstract

Scheduling seminars at universities is still sometimes hampered by manual processes and systems that are not integrated with faculty calendars, leading to scheduling conflicts, delayed confirmations, and a lack of transparency. The purpose of this study is to design an efficient and transparent database for scheduling seminars that is integrated with faculty calendars and automatic notifications, thereby minimizing delays and cancellations. The methods used include a literature review, interviews, and the Database Life Cycle (DBLC), encompassing the conceptual, logical, and physical design stages. Normalization was carried out to the third normal form (3NF) to ensure structured data without redundancy. Quantitative results show that the system produces 13 main tables interconnected through primary and foreign keys, which are capable of eliminating data duplication and remain consistent in validation tests. In addition, the system supports the sending of notifications at least seven days before the seminar. This database design can improve the efficiency, accuracy, and transparency of seminar scheduling. This study differs from previous research as it not only applies the DBLC for database design but also emphasizes the integration of faculty calendars and automatic notification mechanisms, aspects that have not been explored in depth in earlier works

Downloads

Download data is not yet available.

Author Biographies

Aurelia Callysta Mamahit, Mahasiswa Prodi Teknologi Informasi, Fakultas Ilmu Komputer, Universitas Brawijaya

Aurelia Callysta Mamahit adalah seorang mahasiswa semester 3 Prodi Teknologi Informasi, Fakultas Ilmu Komputer, Universitas Brawijaya.

Diva Kurnianingtyas, Dr., S.Kom., Dosen Fakultas Ilmu Komputer, Universitas Brawijaya

Diva Kurnianingtyas, Dr., S.Kom. adalah seorang dosen di Fakultas Ilmu Komputer, Universitas Brawijaya.

DOI: 10.47111/jti.v20i1.22986 DOI URL: https://doi.org/10.47111/jti.v20i1.22986

Views: 17 | Downloads: 31

References

[1] Salsabila, U. H., & Agustian, N. (2021). Peran Teknologi Pembelajaran

[2] Jamaludin, et al. (2022). Sistem Basis Data. Padang: PT Global Eksekutif Teknologi.

[3]M.Riyan Dirgantara, S. S. (2023). Pengenalan Database Management System (DBMS). https://doi.org/10.5281/ZENODO.8123019

[4] Tri Amri Wijaya, Constantin Menteng, Afis Julianto, Adi Surya, & Ema Utami. (2021). Perancangan Desain Basis Data Sistem Informasi Geografi 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

[5] 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

[6] Titik Rahmawati, Eka Yulia Sari, Anjasmara Tanjung Shakti, & Atthaya Nanda Yomura. (2023). Analisis Perancangan Database Managemen Sistem Untuk Sistem Penunjang Proses Bisnis Wedang Uwuh Digital. TEKNIMEDIA: Teknologi

Informasi dan Multimedia, 4(1), 61–69. https://doi.org/10.46764/teknimedia.v4i1.104

[7] Adawiyah, H., Krisnanik, E., Kom, S., & Purabaya, R. H. (2022). Analisis Dan Perancangan Basis Data Sistem Informasi Akademik Pondok Pesantren Al-Qur'an An Assa’Adiyah.

[8] 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

[9] Pieris, D., Wijegunesekera, M. C., & J Dias, N. G. (2020). ER Model Partitioning: Towards Trustworthy Automated Systems Development, 11(6).

[10] Azzahra, Z. F., & Anggoro, A. D. (2022). Analisis Teknik Entity-Relationship Diagram dalam Perancangan Database Sebuah Literature Review. INTECH (Informatika dan Teknologi), 3(2), 70-74.

[11] Rashkovits, R., & Lavy, I. (2021). Mapping Common Errors in Entity Relationship Diagram Design of Novice Designers. International Journal of Database Management Systems, 13(1), 1-19.

[12] Blacher, M., Giesen, J., Laue, S., Klaus, J., & Leis, V. (2022). Machine learning, linear algebra, and more: Is SQL all you need?. In CIDR.

[13] Mulyana, D., & Sidiq, M. (2023). Perancangan Desain Sistem Basis Data Pengelolaan Aset (Studi Kasus: Universitas Galuh). Journal of Galuh Information System, 1(1), 17. https://doi.org/10.25157/JSIG.V1I1.2917

[14] Taseska, T. (2024). Conceptual And Logical Design Of Relational Database: A Case Study. Journal

of Student Research, 1(1). https://doi.org/10.20544/

[15] Permana, K. E., Sophan, M. K., Muntasa, A., & Rahmat, A. B. (2023). Perbandingan Kinerja Query SQL Join Tables Dengan Menggunakan Index. Jurnal Simantec,

11(2), 241–249. https://doi.org/10.21107/simantec.v11i2.20288