JIKUM: Jurnal Ilmu Komputer
Vol. 2 No. 2 (2026): JIKUM: Jurnal Ilmu Komputer, November 2026

Implementasi Konsep Fungsi dalam Perancangan Basis Data Sederhana pada Sistem Informasi Akademik

Muhammad Ulya Farhan Farhan (Universitas Malikussaleh)
Maryana (Unknown)
Dio Tri Firnanda (Unknown)
Muhammad Rasyya Alfarisi (Unknown)
Muhammad Lukmanul Hakim (Unknown)



Article Info

Publish Date
02 Aug 2026

Abstract

Good database design is the foundation of a reliable Academic Information System (SIAKAD). However, manydesigners work intuitively without a solid theoretical basis, making them prone to redundancy and operationalanomalies. This study examines the implementation of functions in discrete mathematics as a formal basis for SIAKADrelational 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 functionaldependencies, normalization up to the third normal form (3NF), and modeling relational schemas.The results show adirect correspondence between mathematical functions and relational database elements: function domains relate toprimary keys, codomains to non-key attributes, injective functions to UNIQUE constraints, surjective functions toFOREIGN KEY coverage, and composite functions to transitive dependencies. Applying this mapping to the SIAKADcase study yielded four normalized relational schemas, Student, Course, Lecturer, and Grade, which are free fromredundancy and data anomalies. This research provides a systematic conceptual framework for database designers tointegrate discrete mathematics principles into the design process.

Copyrights © 2026






Journal Info

Abbrev

jikum

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management

Description

JIKUM: Jurnal Ilmu Komputer menerbitkan artikel dalam Bahasa Indonesia yang akan diterbitkan 2 kali setahun yaitu periode Mei dan Nopember. Penulis yang mengirimkan naskah pada JIKUM: Jurnal Ilmu Komputer harus mengikuti pedoman penulisan, fokus dan ruang lingkup jurnal, serta template jurnal. ...