ABSTRACT
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.
LITERATURE SURVEY
Attendance is the act or fact of attending (being present at) school. Also, attendance is used to define the number of persons present on a particular day at school. An attendance policy provides the guidelines and expectations for students’ attendance at school as defined, written, disseminated, and implemented by the school. Attendance can be recorded in many ways such as using web based, RFID, biometrics and bar code scanner. Since most of the application developed nowadays requires the world wide accessibility, web based system is the most common attendance system that available.
PROPOSED SYSTEM
Fig.1.Proposed Block diagram
In this proposed work. The block diagram displays the process of the complete system. In proposed system, students can access their details when they feel to check, which is on the output window (LCD screen) or by a smart phone application. This system provides information about their respective student attendance and marks. It provides more security and reliable than RFID technology. Even if parents want to know performance of student they can SMS and get the reports through SMS.
HARDWARE IMPLEMENTATION
- Arduino Uno And Mega 2560
- GPRS/GSM MODULE (SIM 900)
- Barcode Scanner
- LCD Display (20X4)
Arduino Uno And Mega 2560
The Arduino Mega 2560 is a microcontroller board based on the ATmega2560. It has 54 digital input/output pins (of which 14 can be used as PWM outputs), 16 analog inputs, 4 UARTs (hardware serial ports), a 16 MHz crystal oscillator, a USB connection, a power jack, an ICSP header, and a reset button. It contains everything needed to support the microcontroller; simply connect it to a computer with a USB cable or power it with a AC – to – DC adapter or battery to get started.
SOFTWARE IMPLEMENTATION
Embedded C
Embedded C is a set of language extensions for the C Programming language by the C Standards committee to address commonality issues that exist between C extensions for different embedded systems. Historically, embedded C programming requires nonstandard extensions to the C language in order to support exotic features such as fixed – point arithmetic, multiple distinct memory banks, and basic I/O operations.
PHP (Pre-processor Hypertext) & MySQL (My Structured Query Language)
PHP is a High level programming language installed on a web server which receives inputs from user via internet and processes these inputs to produce dynamic outputs. A PHP can access databases which are installed on server. It can able to receive inputs ( Serial number, ID number etc.) from clients and get the entire information associated with it and sent it back to the client. It also validates the information before processing the same. MySQL is a language used to control the functioning of a database
NET Framework (.NET)
.NET Framework (.NET) means it is a software development framework from Microsoft. It provides a controlled programming environment where software can be developed, installed and executed on Windows – based operating systems.
CONCLUSION AND FUTURE SCOPE
This work describes an information management system of students, which uses barcode technology. It shows the potential applications of using digital barcodes to carry useful information, how the system can be helpful in providing information to the users. The developed Web – Based Student Enquiry System using Barcode and GPRS/GSM technology will significantly improve the current manual process of student attendance, results enquiry and tracking system of a university or school environment.
The system promotes a semi – automated approach in enquiry of any information related to his academics, i.e. by having t he students to flash their college Identity cards to the Barcode reader. Then he can view the data of his desire on the LCD display. In addition, a number of other advantages are gained by having an online web – based system, acting as a central repository of student database record. Firstly all processes of managing the student database record such as USN, Department, Attendance status, Internal Assessment score, Provisional results of particular semester and other resources too are performed online, allowing administrators and lecturers to view or modify the users’ data through any computer via the web browser through admin panel which is developed using .net with admin password.
This way, no specific software installation is required. The student data are a lso processed and analyze automatically with less risk of data loss, compared to a manual filing approach. Although the student database management module is not fully integrated to the system and used on real time, the system prototype demonstrates easy navigation and data are stored in a systematic way. Overall, efficiency has improved and work processes simplified. Although all the objectives have been met, the system still has room for improvement. The system is robust and flexible enough for future upgrade using advanced technology and devices.
Source: Jain University
Authors: Raj Kiran T | T Abhinav | V Nafeez | Adithya H B | Amulya S | R Meghana | Sunil MP
>> List of Student Database Management System DBMS Projects using C, C++