Abstract
This research addresses the present issues in attendance management system, including poor faculty user interface when handling large volume of student data and the time-consuming process of analysing and visualizing attendance and other student related information from the database using SQL queries. To resolve these challenges, a user friendly, web-based attendance management system is developed. This system can be deployed on both desktop and standalone devices. This system incorporates an SQL chatbot powered by a Large Language Model (LLM) to analyse and retrieve information from the database. The server side of this application is built with PHP scripting language, with MySQL as the database for managing students, faculties, subjects, timetable, and attendance data. The frontend of this software is developed using HTML 5.0, Sassy CSS (SCSS), and JavaScript to ensure a responsive and user-friendly user interface. A key feature of this system is the integrated MySQL chatbot, built with Python using the streamlit (U/I) framework, LangChain NLP library and OpenAI API. This chatbot interface directly connects with attendance database, allowing administrators to analyse and visualize data through natural language commands, eliminating the need for simple/complex SQL queries. Through natural language interaction, the chatbot can perform various database operations such as updating, modifying, and deleting records, thus significantly enhancing data management efficiency and usability.
References
S. Kotresh, “Radio frequency identification of attendance system”. International Journal for Research in Applied Science and Engineering Technology 12(5) 2024:1870-1873.
Yash Ghorpade, Harshal Thakare, Siddesh Sonawane, Anan Dedhila, Shubhra Mukherjee Mathur, “Face Recoginition Attendance Monitoring System”. International Journal of Advanced Research in Science, Communication and Technology. 4(3): 2024 544-546
N Mohammed Nowsath, IoT Biometric Attendance System Nexus with Automated Data Streamlining and Software Orchestration. International Journal of Scientific Research in Engineering and Management 2024. 08(03):1-5.
Amelia, Amelia,Solikhah, Mar’atus. "Web-based employee attendance information system on CV. Syntax corporation Indonesia." Journal Indonesia Social Technology 4, no. 12 (2023).2436-2442.
Hassan, Sahar, and Dr Muhammad Asghar. "Web Based Attendance Management System."(2015).https://www.satkhiramunicipality.org.bd/admin/uploads/c6505ee796446e997c 73fbdd5825065.pdf
Rahman, Md Mijanur. "Study on Introducing Biometric Fingerprint Authentication in Automated Student Attendance System." Book Publisher International 4 (2021): 121-131.
Singh, Akash, Shreya Bhatt, and Abhishek Gupta. "Automated attendance system with face recognition." International Journal of Engineering Applied Sciences and Technology (2021): 5(12): 233-241.
Utkarsh, “Digital Attendance System using Face Recognition Technique”. International Journal for Research in Applied Science and Engineering Technology. 9(12) 2021 :2273-2277.
R. K. Kodali and R. V. Hemadri, "Attendance Management System," 2021 International Conference on Computer Communication and Informatics (ICCCI), Coimbatore, India, 2021, 1-5.
Yashi Porwal, Deependra Rastogi, “Smart Attendance System”. International Journal of Computer Science and Engineering, 7(6),2020 13-16.
Preeti Pandeyk, D. John Arvindhar, “Smart System for Attendance”. International Journal of Innovative Research in Applied Sciences and Engineering 3(12) 2020:587-592.
Naen, Mohamad Fakir, Muhamad Hariz Muhamad Adnan, Nurul Adilah Yazi, and Chee Ken Nee. "Development of attendance monitoring system with artificial intelligence optimization in cloud." International Journal of Artificial Intelligence 8, no. 2 (2021): 88-98.
Junika, Selvia. "Malang City Polytechnic Web Based Student Attendance Information System Telecommunications Engineering Study Program Using Fingerprint." Journal Of Informatics and Telecommunication Engineering 3, no. 1 (2019): 32-40.
Raj, Mool, and Tanishu Mahajan. "Study of opinions related to the use of bio-enabled attendance system for improving punctuality among teachers." MIER Journal of Educational Studies Trends and Practices (2021): 41-52.