STUDENT DATABASE MANAGEMENT AND ENQUIRY SYSTEM USING BARCODE SCANNER

Electronics and Communication Engineering

National Conference on "Recent Advances in Materials Science & its Applications" & "Recent Trends in Electrical, Electronics, Computing and Information Technology"

Student’s attendance plays a very vital role in order to justify their overall academic performance. Unfortunately, there is no automated attendance record maintenance system available in schools and colleges for the students. Today with advanced technology, there a lot of technologies are being used in this century. Several of software apps are created in order to make the data's that are saved online and access the stored data through manually. The stored computerized data is more secure because it will be protected by encryption key. Thus, here is one attempt to develop such one system and to solve the existing problem. The main objective of the proposed work is to design a student database management system using Barcode scanner. In this work we convert the manual student database management into computerized system for data reliability and easy accessibility. This system provides any information regarding students such as his/her USN, Department, Attendance status, Internal Assessment score, Provisional results of any semester and also other personal information. It provides all the information of a student starting from the first day till the end of his/her course, so that it can be used later for all reporting purpose, attendance tracking, curriculum details, and hence can be used for future reference. This system will have the required databases of student directory, this application has been developed using Microsoft Visual Studio 2012 using C programming language and using MS Access for creating the database. The standalone system is accessed using barcode scanner is interfaced to the Arduino microcontroller. The student should use their Identity card and swipe it on barcode scanner to check their details. The Student database System is located on a server which can be accessed anytime and all the information's are being updated through Admin panel. Besides, by using this system we can reduce the time and human effort. The system is user - friendly with GUI support and all the instructions of accessing the system will be displayed on LCD screen. The proposed prototype is to setup student’s full pledged information, it is not only for students, and it can also accessed by their parents, just by sending one SMS to know about their ward completely with respect attendance and academic performance report card. It is secured and consumes less time to access.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.