Implementasi Konsep Fungsi dalam Perancangan Basis Data Sederhana pada Sistem Informasi Akademik
DOI:
https://doi.org/10.62671/jikum.v2i2.318Keywords:
mathematical functions, functional dependency, database normalization, academic information system, relational databaseAbstract
Good database design is the foundation of a reliable Academic Information System (SIAKAD). However, many
designers work intuitively without a solid theoretical basis, making them prone to redundancy and operational
anomalies. This study examines the implementation of functions in discrete mathematics as a formal basis for SIAKAD
relational database design.The method uses a literature review with a comparative conceptual analysis approach,
including identifying SIAKAD entities, mapping function concepts to functional dependencies, analyzing functional
dependencies, normalization up to the third normal form (3NF), and modeling relational schemas.The results show a
direct correspondence between mathematical functions and relational database elements: function domains relate to
primary keys, codomains to non-key attributes, injective functions to UNIQUE constraints, surjective functions to
FOREIGN KEY coverage, and composite functions to transitive dependencies. Applying this mapping to the SIAKAD
case study yielded four normalized relational schemas, Student, Course, Lecturer, and Grade, which are free from
redundancy and data anomalies. This research provides a systematic conceptual framework for database designers to
integrate discrete mathematics principles into the design process.
References
Armstrong, W. W. (1974). Dependency structures of data base relationships. Proceedings of IFIP Congress, 580–583.
Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, 13(6), 377–387. doi.org
Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson.
Date, C. J. (2003). An Introduction to Database Systems (8th ed.). Addison-Wesley.
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Pearson.
Epp, S. S. (2019). Discrete Mathematics with Applications (5th ed.). Cengage Learning.
Febriyanti, F., & Saputra, R. (2023). Penerapan functional dependency dalam perancangan basis data relasional. Jurnal Teknologi Informasi, 15(1), 66–83.
Garnier, R., & Taylor, J. (2009). Discrete Mathematics: Proofs, Structures and Applications (3rd ed.). CRC Press.
Hartono, B. (2021). Matematika diskrit dan aplikasinya dalam sistem informasi. Jurnal Informatika, 8(1), 22–39.
Johnsonbaugh, R. (2018). Discrete Mathematics (8th ed.). Pearson.
Koshy, T. (2004). Discrete Mathematics with Applications. Academic Press.
Kusuma, A. B. (2019). Konsep fungsi dalam perancangan basis data: Sebuah pendekatan matematis. Jurnal Sistem Informasi, 11(2), 112–127.
Lestari, P., & Wibowo, A. (2021). Keterkaitan konsep fungsi bijektif dengan functional dependency. Jurnal Rekayasa Sistem, 7(3), 201–218.
Maulana, A. (2024). Optimasi skema basis data relasional melalui normalisasi database. Jurnal Komputer dan Aplikasi, 12(1), 44–59.
Nurdin, N. (2022). Perancangan basis data sistem informasi akademik menggunakan normalisasi. Jurnal Sains dan Teknologi, 6(1), 55–70.
Pratama, A., & Sari, D. (2020). Perancangan basis data SIAKAD menggunakan ERD. Jurnal Edukasi IT, 5(1), 33–48.
Putra, R. A., & Nugroho, A. S. (2023). Analisis functional dependency dari perspektif fungsi matematika. Jurnal Algoritma, 9(2), 178–194.
Rahman, F., Hidayat, T., & Nugroho, S. (2021). Implementasi database normalization pada SIAKAD. Jurnal Sistem Komputer, 10(3), 201–215.
Rosen, K. H. (2019). Discrete Mathematics and Its Applications (8th ed.). McGraw-Hill.
Setiawan, D. (2023). Analisis perbandingan normalisasi dan denormalisasi pada basis data. Jurnal Riset Komputer, 10(1), 89–104.
Wahyuni, S., Hidayat, R., & Pratama, A. (2021). Implementasi normalisasi basis data pada SIAKAD. Jurnal Pengembangan Teknologi Informasi, 5(2), 145–158.
