Design and Implementation of a Relational Database for an Academic Information System
DOI:
https://doi.org/10.33050/italic.v3i2.801Keywords:
Academic Information System, Relational Database, Data Management, SQL, Entity-Relationship ModelAbstract
This paper focuses on the design and implementation of a relational database for an Academic Information System (AIS), aiming to streamline data management and improve the efficiency of academic processes. The study highlights challenges faced by educational institutions in managing large volumes of student and academic data, often resulting in inefficiencies and errors. The objective is to create a relational database supporting student information, course registrations, faculty assignments, and academic records. The methodology includes developing an Entity-Relationship (ER) model, applying database normalization, and implementing the system using Structured Query Language (SQL). The result is a functional database that improves data retrieval speed, enhances integrity, and simplifies access for academic staff and administrators. The solution contributes to optimizing academic data management by ensuring consistency, reducing errors, and offering scalability for future growth. This research also includes system performance evaluations and stakeholder feedback from faculty, staff, and students. Findings reveal significant improvements in usability, accuracy, and system responsiveness compared to prior legacy systems. Integrated security measures, including role-based access and encryption, safeguard data and ensure compliance with institutional privacy policies. The relational database framework supports real-time access, centralized control, and efficient administrative workflows. Overall, this system strengthens digital infrastructure in educational institutions and aligns with broader digital transformation goals. It enhances data-driven decision-making and supports sustainable, scalable, and secure academic information management, making it a valuable contribution to improving operational performance and educational service delivery in higher education settings.
References
J. Elov, U. Khamdamov, A. Abdullayev, I. Narzullayev, and D. Sultanov, “Development of a database of higher education process management information system based on the relational model,” in 2021 International Conference on Information Science and Communications Technologies (ICISCT). IEEE, 2021, pp. 01–05.
H. Xia, Z. Liu, M. Efremochkina, X. Liu, and C. Lin, “Study on city digital twin technologies for sustainable smart city design: A review and bibliometric analysis of geographic information system and building information modeling integration,” Sustainable Cities and Society, vol. 84, p. 104009, 2022.
Q. Aini, M. Budiarto, P. O. H. Putra, and U. Rahardja, “Exploring e-learning challenges during the global covid-19 pandemic: A review,” Jurnal Sistem Informasi, vol. 16, no. 2, pp. 57–65, 2020.
A. C. Bock and U. Frank, “Low-code platform,” Business & Information Systems Engineering, vol. 63, pp. 733–740, 2021.
J. Li, B. Hui, G. Qu, J. Yang, B. Li, B. Li, B. Wang, B. Qin, R. Geng, N. Huo et al., “Can llm already serve as a database interface? a big bench for large-scale database grounded text-to-sqls,” Advances in Neural Information Processing Systems, vol. 36, pp. 42 330–42 357, 2023.
A. Martinez, A. Fitzroy, and A. Hogwart, “Network communication security: Challenges and solutions in the digital era,” International Journal of Cyber and IT Service Management, vol. 4, no. 1, pp. 46–51, 2024.
Q. Aini, D. Manongga, U. Rahardja, I. Sembiring, and Y.-M. Li, “Understanding behavioral intention to use of air quality monitoring solutions with emphasis on technology readiness,” International Journal of Human–Computer Interaction, vol. 41, no. 8, pp. 5079–5099, 2025.
M. Bilal and E. Andajani, “Factors affecting the intention to use roof solar panel in households in indonesia,” ADI Journal on Recent Innovation, vol. 5, no. 1, pp. 25–33, 2023.
M. Amini and A. Rahmani, “Agricultural databases evaluation with machine learning procedure,” Australian Journal of Engineering and Applied Science, vol. 8, no. 2023, pp. 39–50, 2023.
A. Ruangkanjanases, A. Khan, O. Sivarak, U. Rahardja, and S.-C. Chen, “Modeling the consumers’ flow experience in e-commerce: The integration of ecm and tam with the antecedents of flow experience,” Sage Open, vol. 14, no. 2, p. 21582440241258595, 2024.
D. Jonas, E. Maria, I. R. Widiasari, U. Rahardja, T. Wellem et al., “Design of a tam framework with emotional variables in the acceptance of health-based iot in indonesia,” ADI Journal on Recent Innovation, vol. 5, no. 2, pp. 146–154, 2024.
A. Z. Far, M. Z. Far, S. Gharibzadeh, H. K. Naeini, L. Amini, S. Zangeneh, M. Rahimi, and S. Asadi, “Artificial intelligence for secured information systems in smart cities: Collaborative iot computing with deep reinforcement learning and blockchain,” arXiv preprint arXiv:2409.16444, 2024.
R. Zeiss, A. Ixmeier, J. Recker, and J. Kranz, “Mobilising information systems scholarship for a circular economy: Review, synthesis, and directions for future research,” Information Systems Journal, vol. 31, no. 1, pp. 148–183, 2021.
D. S. S. Wuisan, R. A. Sunardjo, Q. Aini, N. A. Yusuf, and U. Rahardja, “Integrating artificial intelligence in human resource management: A smartpls approach for entrepreneurial success,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 3, pp. 334–345, 2023.
D. Hercog, T. Lerher, M. Truntiˇc, and O. Teˇzak, “Design and implementation of esp32-based iot devices,” Sensors, vol. 23, no. 15, p. 6739, 2023.
P. A. Sunarya, U. Rahardja, S. C. Chen, Y.-M. Lic, and M. Hardini, “Deciphering digital social dynamics: A comparative study of logistic regression and random forest in predicting e-commerce customer behavior,” Journal of Applied Data Sciences, vol. 5, no. 1, pp. 100–113, 2024.
H. Ilham, B. Wijayanto, and S. P. Rahayu, “Analysis and design of user interface/user experience with the design thinking method in the academic information system of jenderal soedirman university,” Jurnal Teknik Informatika (Jutif), vol. 2, no. 1, pp. 17–26, 2021.
A. Pambudi, N. Lutfiani, M. Hardini, A. R. A. Zahra, and U. Rahardja, “The digital revolution of startup matchmaking: Ai and computer science synergies,” in 2023 Eighth International Conference on Informatics and Computing (ICIC). IEEE, 2023, pp. 1–6.
R. Wandira, A. Fauzi, F. Nurahim et al., “Analysis of factors influencing behavioral intention to use cloud-based academic information system using extended technology acceptance model (tam) and expectation-confirmation model (ecm),” Journal of Information Systems Engineering and Business Intelligence, vol. 10, no. 2, pp. 179–190, 2024.
D. Amalia, D. Cahyono, V. Septiani, and M. Kristiawan, “Ux test in the academic information system of vocational higher education,” JPGI (Jurnal Penelitian Guru Indonesia), vol. 7, no. 1, pp. 36–46, 2022.
U. Rahardja, T. Hongsuchon, T. Hariguna, and A. Ruangkanjanases, “Understanding impact sustainable intention of s-commerce activities: The role of customer experiences, perceived value, and mediation of relationship quality,” Sustainability, vol. 13, no. 20, p. 11492, 2021.
M. Ahli, M. F. Hilmi, and A. Abudaqa, “Moderating effect of employee service quality and mediating impact of experiential marketing in uae entrepreneurial sector,” Aptisi Transactions on Technopreneurship (ATT), vol. 6, no. 2, pp. 285–299, 2024.
R. Heriyanto and T. Mariyanti, “Poverty alleviation strategies through sharia microfinance institutions politico-economics study with tawhidi approach,” Aptisi Transactions on Management, vol. 6, no. 2, pp. 132–141, 2022.
R. Fahrudin, M. Hatta, Y. Yulianti, E. Erwin, and A. Zelene, “Machine learning for the next generation: A guide to matchmaking at startups,” IAIC Transactions on Sustainable Digital Innovation (ITSDI), vol. 6, no. 1, pp. 65–74, 2024.
H. S. Simarmata and I. R. Widiasari, “Manajemen bandwidth menggunakan hierarchical token bucket (htb)(studi kasus: Pt. orion cyber internet),” Technomedia Journal, vol. 8, no. 2 Special Issues, pp. 248–260, 2023.
W. Setyowati, T. A. Setiyono, G. Gung, and B. Novriyanti, “Leveraging technology in accounting for entrepreneurial insight into government budgeting efficiency,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 3, pp. 251–260, 2023.
L. Kask, N. Bloom, and R. Porta, “Health informatics: Utilization of information technology in health care and patient management,” International Journal of Cyber and IT Service Management, vol. 4, no. 1, pp. 52–57, 2024.
M. F. Nur and A. Siregar, “Exploring the use of cluster analysis in market segmentation for targeted advertising,” IAIC Transactions on Sustainable Digital Innovation (ITSDI), vol. 5, no. 2, pp. 158–168, 2024.
D. S. Sitorus, A. A. Putri, P. R. Hidayat, and C. F. Rostina, “The influence of selection, motivation and utilization of information system academic for lecturer (siad) on the lecturer performance,” Golden Ratio of Human Resource Management, vol. 1, no. 2, pp. 61–71, 2021.
I. Darmawan, M. S. Anwar, A. Rahmatulloh, and H. Sulastri, “Design thinking approach for user interface design and user experience on campus academic information systems,” JOIV: International Journal on Informatics Visualization, vol. 6, no. 2, pp. 327–334, 2022.
P. Edastama, A. Dudhat, and G. Maulani, “Use of data warehouse and data mining for academic data: A case study at a national university,” International Journal of Cyber and IT Service Management, vol. 1, no. 2, pp. 206–215, 2021.
S. Guerreiro, J. F. Ferreira, T. Fonseca, and M. Correia, “Integrating an academic management system with blockchain: A case study,” Blockchain: Research and Applications, vol. 3, no. 4, p. 100099, 2022.
N. F. A. Shahidan, A. F. Ibrahim, and M. N. F. Jamaluddin, “Data visualization of student academic performance analysis,” Applied Mathematics and Computational Intelligence, vol. 13, no. 4, pp. 49–61, 2024.
R. Aprianto, R. Haris, A. Williams, H. Agustian, and N. Aptwell, “Social influence on ai-driven air quality monitoring adoption: Smartpls analysis,” Sundara Advanced Research on Artificial Intelligence, vol. 1, no. 1, pp. 28–36, 2025.
J. Hom, V. Melinda, and D. Lazirkha, “Quality analysis of digital business services in improving customer satisfaction,” Startupreneur Business Digital (SABDA), vol. 1, no. 1, 2022.
S. C. Daradinanti and R. Kuswati, “Is truly trustworthiness of celebrity endorsement effect on online purchase intention: A study on online travel agency customers,” Indonesian Interdisciplinary Journal of Sharia Economics (IIJSE), vol. 8, no. 2, pp. 2697–2717, 2025.
A. Maariz, M. A. Wiputra, and M. R. D. Armanto, “Blockchain technology: Revolutionizing data integrity and security in digital environments,” International Transactions on Education Technology (ITEE), vol. 2, no. 2, pp. 92–98, 2024.
M. Annas and T. Handra, “High rate of turnover intention: Study of logistics industrial workers,” Startupreneur Business Digital (SABDA Journal), vol. 2, no. 2, pp. 106–117, 2023.
V. El Ardeliya, J. Taylor, and J. Wolfson, “Exploration of artificial intelligence in creative fields: Generative art, music, and design,” International Journal of Cyber and IT Service Management, vol. 4, no. 1, pp. 40–46, 2024.
I. Amsyar, E. Cristhopher, U. Rahardja, N. Lutfiani, and A. Rizky, “Application of building workers services in facing industrial revolution 4.0,” Aptisi Transactions on Technopreneurship (ATT), vol. 3, no. 1, pp. 32–41, 2021.
V. Shela, T. Ramayah, K. L. Aravindan, N. H. Ahmad, and A. I. Alzahrani, “Run! this road has no ending! a systematic review of pls-sem application in strategic management research among developing nations,” Heliyon, vol. 9, no. 12, 2023.
H. W. Aripradono, “Application of digital storytelling communication on instagram social media,” Technical, vol. 9, no. 2, pp. 121–128, 2020.
T. Pujiati, H. Setiyowati, B. Rawat, N. P. L. Santoso, and M. G. Ilham, “Exploring the role of artificial intelligence in enhancing environmental health: Utaut2 analysis,” Sundara Advanced Research on Artificial Intelligence, vol. 1, no. 1, pp. 37–46, 2025.
R. Tarmizi, N. Septiani, P. A. Sunarya, and Y. P. A. Sanjaya, “Harnessing digital platforms for entrepreneurial success: A study of technopreneurship trends and practices,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 3, pp. 278–290, 2023.
L. S. Riza, E. Piantari, E. Junaeti, I. S. Permana et al., “Implementation of the gamification concept in the development of a learning management system to improve students’ cognitive in basic programming subjects towards a smart learning environment,” ADI Journal on Recent Innovation, vol. 5, no. 1, pp. 43–53, 2023.
J. Huangfu, “Storytelling as a pr tool for a tech startup,” Frontiers in Management Science, vol. 2, no. 2, pp. 79–88, 2023.
E. Endri and W. Prasetyo, “Optimizing marketing communication strategies of startup companies in the f&b franchise sector,” Indonesian Journal: Informatics and Communication Management (JIMIK), vol. 6, no. 1, pp. 83–94, 2025, journal STMiki+1.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Muna Azuddin, Muhamad Yusup, Harlis Setiyowati, Shesilia Wibowo, Jaka Suwita, Sucipto Basuki, Eka Dian Astuti
This work is licensed under a Creative Commons Attribution 4.0 International License.
