Access Control and Recording System Using SQLite and RFID

Abstract

In this study, a prototype system, of which recordings are made into the SQLite database, which is controlled by an Arduino microcontroller, which approves or rejects the accesses to be made through a gate by reading RFID tags with an RFID reader, was realized. Door access, control, and recording operations are provided with an interface designed with C#. The contact, date, time, and minute information of accesses is displayed and recorded with the SQLite database. The system consists of two parts. The prototype door section consists of an Arduino Uno microcontroller, RFID reader, LCD, DC motor, DC motor drive, and a sliding door. A computer, recording and control software created with C#, and the SQLite database running in relation to this software are found in the second part.

Keywords: Access Control, RFID, Arduino, SQLite database

DOI: 10.7176/JSTR/5-10-04