Biometric
Attendance System
Group Members Advisor
Muhammad Ubaid 2019384 • Dr. Zaiwar Ali
Muhammad Zubair 2019408 Co-Advisor
Salman Waheed 2019451 • Dr. Ahmad Kamal Hassan
Zeeshan Karim 2019560 • Dr. Memoon Sajid 1
Individual Contribution:
Muhammad
Ubaid • Interfacing of modules with esp32 using
Muhammad Arduino IDE with the library of esp32
Zubair
Salman • Working on data base using MySQL
Waheed workbench.
Zeeshan karim • PCB design through Altium.
2
Hardware
• Microcontroller(Esp32)
• Fingerprint sensor(R307)
• RTC –Real Time Clock
• Oled Display(SSD1307)
• Micro SD card reader(HW-125)
• DC Battery or Adaptor (12V, 1Amp)
3
Software
• Altium designer
• Arduino IDE
• CREO
• MySQL Workbench
4
Microcontroller
• Power up and initialize it
• Check for interrupts, faults while the modules get initialized.
• Command the fingerprint module to function as requested by the
software interface.
• Enable data to save on board storage /transfer through the wireless
module.
5
Fingerprint module(R307)
Specification
• Fingerprint sensor type: Optical
• Sensor Life: 100 million times
• Static indicators: bright green
• Image Capture Surface 15—18(mm)
• Verification Speed: 0.3 sec
• Voltage: 3.6-6.0 VDC
• Working current: Typical 90 mA, Peak 150mA
• Operating Environment Temperature: -20 to 45° centigrade
6
R307 Chip design
• Designed PCB for R307
Fig 2 2D view of PCB for R307 7
Interfacing of components with ESP32
• Finger Print module is connected to Receiver (RX2) and Transmitter
(TX2) of ESP32.
• RTC (Real Time Clock) and Oled display is connected through I2C
(Inter-Integrated Circuit) pins to the microcontroller.
• Micro SD card is interfaced to ESP32 with SPI (Serial Peripheral
Interface) communication protocol.
8
Problem faced:
• The R307 was not recognized by ESP32 using the software serial
library. (instead we have used <HardwareSerial.h> library for smooth
working of R307).
• Both the ssd1307 and RTC are interfaced with esp32 through I2C pins
and they are not working fine. (I2C pins will act as a bus to solve the
problem)
9
Circuit
Diagram
Fig 3 Circuit diagram for biometric attendance system
10
Scan and Save fingerprint
11
12
Results:
Graph of Confidence for Finger print scaner Confidence
140
120
100
Confidence
80
60
40
20
0
1 2 3 4 5 6 7
Entry
Fig 4 Confidence level
13
Block Diagram:
Admin Input
to database Student Scan and Save in spread Upload to
(Name,reg Biometric Match sheets database
no,Schedule) Input
Fig 5 Block Diagram for biometric Attendance System
14
Flow Chart
Fig 6 Flow chart for
biometric atte
15
Circuit diagram:
16
Database
Introduction
• A database is an information that is used for
easy access, management and updating
information.
• Database can be online such as Google
Cloud and Bluehost or on local servers such
as phpMyAdmin and MySQL.
• We are using MySQL for this project.
17
Types of Databases1
• There are 14 types of databases.
• However, two major types of databases
are:
i. NoSQL or single-file database use
individual files to represent
information.
ii. Relational database are more
complex database that use tables to
show the relationship between data.
18
Data
Stored in
Database
19
Match
Fingerprints
with
Database
20
Gantt Chart for FYP 22-23
5-Aug 24-Sep 13-Nov 2-Jan 21-Feb 12-Apr 1-Jun
Literature Review & Methadology
Circuit diagram: Components Selection
PCB Design
Biometric module Design
Interfacing Microcontroller with components
Working on Database
Excel sheets formulation
Emailing System Development
ull Biometric Attendance System Development
Two Replica's models
Open House Presentation
Full Biometric Interfacing
Open House Emailing System Biometric module Literature Review &
Two Replica's models Attendance System Excel sheets formulation Working on Database Microcontroller with PCB Design Components Selection
Presentation Development Design Methadology
Development components
Starting DATE 13-Apr 7-Mar 12-Feb 19-Jan 29-Dec 8-Dec 23-Nov 5-Nov 17-Oct 30-Sep 14-Sep
Duration (Days) 2 20 25 25 23 34 20 21 28 20 21 18
Task 0 0 0 0 0 0 0 0 0 0 0
Progress
Task Achieved Task Pending
• Components Selection • Biometric module designing
• Interfacing of different
components with the
microcontroller
• Research and design of database
22
Goals for 3rd Presentation
Complete database Interfacing of hardware Attendance spread sheet
design with database formulation
23
References
• Types of databases, Indeed, https://in.indeed.com/career-
advice/career-development/databases-types
• Arduino interface with R307,
https://circuitstate.com/tutorials/interfacing-r307-optical-fingerprint-
scanner-with-arduino-boards-for-biometric-authentication/
• ESP 32 interface with R307,https://github.com/NegasonicX/r307-
Fingerprint-Sensor-on-ESP32
24
