Smart Inventory System for Expiry Date Tracking
Volume-7 | Issue-2

AI based Identification of Students Dress Code in Schools and Universities
Volume-6 | Issue-1

Exploiting Vulnerabilities in Weak CAPTCHA Mechanisms within DVWA
Volume-7 | Issue-2

Gamification in Mobile Apps: Assessing the Effects on Customer Engagement and Loyalty in the Retail Industry
Volume-5 | Issue-4

Investigating Process Scheduling Techniques for Optimal Performance and Energy Efficiency in Operating Systems
Volume-6 | Issue-4

Classification of Remote Sensing Image Scenes Using Double Feature Extraction Hybrid Deep Learning Approach
Volume-3 | Issue-2

Review on Sanskrit Sandhi Splitting using Deep Learning Techniques
Volume-6 | Issue-2

Survey: Unconventional Categories of Chatbots that make use of Machine Learning Techniques
Volume-5 | Issue-3

Light Weight CNN based Robust Image Watermarking Scheme for Security
Volume-3 | Issue-2

Getis-Ord (Gi*) based Farmer Suicide Hotspot Detection
Volume-4 | Issue-2

AUTOMATION USING IOT IN GREENHOUSE ENVIRONMENT
Volume-1 | Issue-1

Principle of 6G Wireless Networks: Vision, Challenges and Applications
Volume-3 | Issue-4

Classification of Remote Sensing Image Scenes Using Double Feature Extraction Hybrid Deep Learning Approach
Volume-3 | Issue-2

Light Weight CNN based Robust Image Watermarking Scheme for Security
Volume-3 | Issue-2

VIRTUAL REALITY GAMING TECHNOLOGY FOR MENTAL STIMULATION AND THERAPY
Volume-1 | Issue-1

Design of Digital Image Watermarking Technique with Two Stage Vector Extraction in Transform Domain
Volume-3 | Issue-3

Analysis of Natural Language Processing in the FinTech Models of Mid-21st Century
Volume-4 | Issue-3

PROGRESS AND PRECLUSION OF KNEE OSTEOARTHRITIS: A STUDY
Volume-3 | Issue-3

Image Augmentation based on GAN deep learning approach with Textual Content Descriptors
Volume-3 | Issue-3

Comparative Analysis for Personality Prediction by Digital Footprints in Social Media
Volume-3 | Issue-2

Home / Archives / Volume-6 / Issue-3 / Article-7

Volume - 6 | Issue - 3 | september 2024

Design and Development of Attendance Management and Analysis System using LLM Open Access
Yugesh Karan P.  , Sibikumar S., Haricharan U., Sasikumar Gurumoorthy  169
Pages: 286-301
Cite this article
P., Yugesh Karan, Sibikumar S., Haricharan U., and Sasikumar Gurumoorthy. "Design and Development of Attendance Management and Analysis System using LLM." Journal of Information Technology and Digital World 6, no. 3 (2024): 286-301
Published
13 September, 2024
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.

Keywords

PHP MySQL DB HTML 5.0 SCSS. JavaScript Python Langchain (NLP Library) Streamlit (Chatbot UI) OpenAI API

×

Currently, subscription is the only source of revenue. The subscription resource covers the operating expenses such as web presence, online version, pre-press preparations, and staff wages.

To access the full PDF, please complete the payment process.

Subscription Details

Category Fee
Article Access Charge
15 USD
Open Access Fee Nil
Annual Subscription Fee
200 USD
After payment,
please send an email to irojournals.contact@gmail.com / journals@iroglobal.com requesting article access.
Subscription form: click here