DATABASE-BASED GUI SYSTEM TO INCREASE THE EFFECTIVENESS OF STUDENT DATA MANAGEMENT IN THE FKIP UHAMKA DORMITORY

ISMAT AMURU; Akhmad Rizal Dzikrillah

doi:10.52436/1.jutif.2024.5.4.1981

ISMAT AMURU Informatics Engineering ,Faculty of Industrial Technology and Information Technology, Universitas Muhammadiyah Prof. Dr. HAMKA, Indonesia
Akhmad Rizal Dzikrillah Informatics Engineering ,Faculty of Industrial Technology and Information Technology, Universitas Muhammadiyah Prof. Dr. HAMKA, Indonesia

DOI: https://doi.org/10.52436/1.jutif.2024.5.4.1981

Keywords: Database, GUI, Python, SUS, Waterfall

Abstract

Data management in the digital era is crucial in various institutions. One of these institutions is the dormitory or student residence, where it's important to track the progress achieved by the residents. However, data management at the FKIP UHAMKA Dormitory still faces several challenges, particularly regarding the loss of previous evaluation data, which is essential for the management. Data loss is a significant issue in the data management process for the relevant institution. Hence, there is a need for innovation in designing a database system that is user-friendly for data management in the digital era. This research aims to develop a GUI-based database system to efficiently manage student data at the FKIP UHAMKA Dormitory. The research adopts the waterfall development method, which involves stages such as requirements analysis, design, coding, and testing. Data is obtained through observation, interviews, and literature studies. The results of the research indicate that the GUI application based on the Dormitory FKIP UHAMKA Database has a good level of usability, with a System Usability Scale (SUS) score of 73.654. This suggests that users find the application easy to use and efficient in meeting their needs related to dormitory management. In addition to the SUS evaluation, this research stands out for developing a more comprehensive GUI system with significant additional features.

Downloads

Download data is not yet available.

References

D. Zakaria, M. H. Muttaqin, G. M. Suranegara, E. N. Irawan, and L. Venica, “The Training of Making Graphical User Interface (GUI) Using Python for Teachers and Students of Engineering Vocational School in Purwakarta,” REKA ELKOMIKA J. Pengabdi. Kpd. Masy., vol. 3, no. 3, pp. 152–159, 2022, doi: 10.26760/rekaelkomika.v3i3.152-159.

M. M. Muhtadi, M. D. Friyadi, and A. Rahmani, “Analisis GUI Testing pada Aplikasi E-Commerce menggunakan Katalon,” Pros. Ind. Res. Work. Natl. Semin., vol. 10, no. 1, pp. 1387–1393, 2019.

M. Anriani Ritonga, C. Fadilah, G. Erli Anggi Lubis, and F. Yusuf, “Penerapan Basis Data Pada Perusahaan e-commerce,” J. Ilmu Komputer, Ekon. dan Manaj., vol. 3, no. 2, pp. 2640–2647, 2023.

R. F. Ramadhan and R. Mukhaiyar, “Penggunaan Database Mysql dengan Interface PhpMyAdmin sebagai Pengontrolan Smarthome Berbasis Raspberry Pi,” JTEIN J. Tek. Elektro Indones., vol. 1, no. 2, pp. 129–134, 2020, doi: 10.24036/jtein.v1i2.55.

B. Rawat and S. Purnama, “Sistem Manajemen Basis Data MySQL ( DBMS ) Pada FTP Situs LAPAN Bandung,” vol. 0, no. 2, pp. 173–179, 2021.

Ery Hartati, “Sistem Informasi Transaksi Gudang Berbasis Website Pada Cv. Asyura,” Klik - J. Ilmu Komput., vol. 3, no. 1, pp. 12–18, 2022, doi: 10.56869/klik.v3i1.323.

H. Seetha et al., “Aplikasi Berbasis GUI untuk Alat Pemrosesan PDF Menggunakan Python & CustomTkinter,” 2023.

K. Sidharta and T. Wibowo, “Studi Efisiensi Sumber Daya Terhadap Efektivitas Penggunaan Database : Studi Kasus SQL Server Dan MySQL,” Conf. Business, Soc. Sci. Innov. Technol., vol. 1, no. 1, pp. 508–515, 2020, [Online]. Available: http://journal.uib.ac.id/index.php/cbssit

A. Sharma, F. Khan, D. Sharma, and S. Gupta, “Python: The Programming Language of Future,” Int. J. Innov. Res. Technol., vol. 6, no. 12, pp. 115–118, 2020.

N. Fitrianingsih, I. Fitriati, and S. Taman Siswa Bima, “Pengembangan Aplikasi E-Raport Berbasis Graphical User Interface (GUI) dengan Menggunakan VB.Net 2010 di SMKN 10 Bima,” J. Pendidik. MIPA, vol. 9, no. 1, pp. 67–75, 2023, [Online]. Available: https://ejournal.tsb.ac.id/index.php/jpm/article/view/179/157

M. Guntur Akbar, H. Witriyono, Y. Apridiyansyah, and D. Abdullah, “Implementation Of The Inter Tk Package, Sub-Process And Os In The Network Management Application Development With Python Programming Language Penerapan Paket Tk Inter, Sub Proses Dan Os Pada Pembuatan Aplikasi Manajemen Jaringan Dengan Bahasa Pemrograman ,” J. Kom., vol. 3, no. 1, pp. 187–196, 2023, [Online]. Available: https://doi.org/10.53697/jkomitek.v3i1

A. Rauf and A. T. Prastowo, “Rancang Bangun Aplikasi Berbasis Web Sistem Informasi Repository Laporan Pkl Siswa (Studi Kasus Smk N 1 Terbanggi Besar),” J. Teknol. dan Sist. Inf., vol. 2, no. 3, p. 26, 2021, [Online]. Available: http://jim.teknokrat.ac.id/index.php/JTSI

D. A. Budi, “Perancangan Sistem Login pada Aplikasi Berbasis GUI Menggunakan Qtdesigner Python,” J. SIMADA (Sistem Inf. dan Manaj. Basis Data), vol. 4, no. 2, pp. 92–100, 2021, doi: 10.30873/simada.v4i2.2961.

M. Sholeh and D. Andayati, “Implementation of SMES Address Information Data Processing Database Design Using Python Programming,” … Conf. Educ. Sci. …, pp. 156–164, 2021, [Online]. Available: http://prosiding.unirow.ac.id/index.php/iconest/article/view/1120

A. Jolie, D. Dedrick, R. K. Sugeng, W. A. Lee, and A. Yulianto, “Aplikasi Sistem Manajemen Perpustakaan dengan Penerapan Pemrograman Berorientasi Objek,” Telcomatics, vol. 7, no. 2, pp. 61–69, 2022, doi: 10.37253/telcomatics.v7i2.7349.

M. Badrul, “Penerapan Metode waterfall untuk Perancangan Sistem Informasi Inventory Pada Toko Keramik Bintang Terang,” PROSISKO J. Pengemb. Ris. dan Obs. Sist. Komput., vol. 8, no. 2, pp. 57–52, 2021, doi: 10.30656/prosisko.v8i2.3852.

khoerul ummah, “No Titleהכי קשה לראות את מה שבאמת לנגד העינים,” הארץ, no. 8.5.2017, pp. 2003–2005, 2022.

I. P. G. Astawa, I. G. M. Darmawiguna, and N. Sugihartini, “Evaluasi Usability Sistem Informasi Kepegawaian Kabupaten Badung (Simpeg Badung) Menggunakan Metode Usability Testing (studi kasus : SMP Negeri 3 Petang),” Kumpul. Artik. Mhs. Pendidik. Tek. Inform., vol. 8, no. 2, p. 209, 2019, doi: 10.23887/karmapati.v8i2.18325.

M. A. Setiawan and D. Avianto, “Pengembangan Aplikasi Android Menggunakan REST API dengan Metode Waterfall Untuk Peningkatan Aksesibilitas Situs Repositori,” vol. 8, pp. 133–143, 2024, doi: 10.30865/mib.v8i1.7056.

D. P. Kesuma, “Penggunaan Metode System Usability Scale Untuk Mengukur Aspek Usability Pada Media Pembelajaran Daring di Universitas XYZ,” JATISI (Jurnal Tek. Inform. dan Sist. Informasi), vol. 8, no. 3, pp. 1615–1626, 2021, doi: 10.35957/jatisi.v8i3.1356.