IDEAS home Printed from https://ideas.repec.org/a/gvu/itdw00/v6y2024i3id1417.html

Design and Development of Attendance Management and Analysis System using LLM

Author

Listed:
  • Yugesh Karan P.
  • Sibikumar S.
  • Haricharan U.
  • Sasikumar Gurumoorthy

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.

Suggested Citation

Handle: RePEc:gvu:itdw00:v:6:y:2024:i:3:id:1417
DOI: 10.36548/jitdw.2024.3.007
as

Download full text from publisher

File URL: https://irojournals.com/itdw/article/view/1417
File Function: Abstract page
Download Restriction: no

File URL: https://irojournals.com/itdw/article/download/1417/1266
File Function: Full text
Download Restriction: no

File URL: https://libkey.io/10.36548/jitdw.2024.3.007?utm_source=ideas
LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
---><---

More about this item

Keywords

;
;
;
;
;
;
;
;

Statistics

Access and download statistics

Corrections

All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gvu:itdw00:v:6:y:2024:i:3:id:1417. See general information about how to correct material in RePEc.

If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

We have no bibliographic references for this item. You can help adding them by using this form .

If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Journal Manager (email available below). General contact details of provider: https://irojournals.com/itdw .

Please note that corrections may take a couple of weeks to filter through the various RePEc services.

IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.