class attendance tracking database system done by: hussain al-lawati isehaq al-mamari al-muatasim...
TRANSCRIPT
![Page 1: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/1.jpg)
Class Attendance Tracking Database System
Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri
Under Supervision of: Dr. Fahad Bait Shiginah
![Page 2: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/2.jpg)
Class Attendance Tracking Database System
Current Attendance Tracking System: Papers
Waste of resources Bins full of papers
Signatures Cheating (Illegal)
![Page 3: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/3.jpg)
3
Presentation Outline Objective Background
Biometrics Fingerprint Sensors Database Application Server
System Requirements System Architecture Database Design Prototype Implementation
Application Server Fingerprint Terminal Emulator Web Interface
Testing Security Conclusion Demo
![Page 4: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/4.jpg)
4
Objective
To implement a system that track attendance using: Database system:
Track of all information
Fingerprints: Identity Recognition
Automatically generates absent warning
![Page 5: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/5.jpg)
5
Background
![Page 6: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/6.jpg)
6
Biometrics
What Biometric is?Types of Biometrics: Properties
Fingerprints Fingerprints are unique for each finger of a person
Face Recognition non-intrusive, hands-free, continuous and accepted by most users
Speaker Recognition Easy to implement
Iris Recognition It does not require physical contact with a scanner, Expensive.
Hand and Finger Geometry These methods of personal authentication are well established.
Signature Verification Uses the dynamic analysis of a signature to authenticate a person.
![Page 7: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/7.jpg)
7
Fingerprint Sensors
Fingerprint sensors how its work? price
Optical Capture a digital image of the fingerprint. 50 -100 $
Ultrasonic Use very high frequency sound waves to enter the epidermal layer of skin.
500-1000 $
Capacitance Use the principles associated with capacitance in order to form fingerprint images.
100-150 $
Thermal Sensors Use the same pyro-electric material that is used in infrared cameras.
200 $
RF Sensors Low radio frequency (RF) signal is applied to the user’s finger. 200 $
![Page 8: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/8.jpg)
8
Database
Files Vs. DBMS Files Complex Code for Queries Security of Data
RDBMS
![Page 9: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/9.jpg)
9
Application Server
Using PHP under LAMP (GNU/Linux , Apache , MySQL, PHP)
CodeIgniter:- Open source PHP web application framework Small footprint MVC structured code (Model-View-Controller) Internal security features (XSS Filtering,
Encryption classes, input validation classes)
![Page 10: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/10.jpg)
10
System Requirements
Non-Functional Requirements Cost-effective
Open source Usability
![Page 11: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/11.jpg)
11
System Requirements
Functional Requirements Instructor enable the terminal (tracking) Students register attendance (fingerprint) Record absentees Send notification email to them Generate warnings automatically Instructor detailed reports of attendance in his
classes (web interface)
![Page 12: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/12.jpg)
12
System Use-Case Diagram
![Page 13: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/13.jpg)
13
ECCE5009 Wednesday 8:00am
Class Started
ECCE5009 Wednesday 10:00am
End of the Class
AttendeesAttendees
• Ishaq
Attendees
• Ishaq
• Al Muatasim
![Page 14: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/14.jpg)
14
System Architecture
Decentralized Vs. Centralized. Factors
- Fingerprints Capacity
- Labor work
- Flexibility Centralized Wins !!
![Page 15: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/15.jpg)
15
System Architecture
![Page 16: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/16.jpg)
16
ER Diagram
![Page 17: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/17.jpg)
17
Database Design
![Page 18: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/18.jpg)
18
PrototypeImplementatio
n
![Page 19: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/19.jpg)
19
Application Server All responses are encoded in JSON
(JavaScript Object Notation) Binary Data are Base64 encoded
Provide a pre-defined tasks to the fingerprint terminal Authorize instructors Provide a list of students along with their
fingerprints in the current class using instructor id & current date and time
Add absent students to the database. Limit what users can do with the database.
![Page 20: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/20.jpg)
20
Fingerprint Terminal Emulator Written in Java Object Oriented Programming paradigm Using Eclipse as an integrated development
environment Futronic Fingerprint Software Development Kit
for fingerprint matching “json_simple” for JSON encoding & decoding Communicate with the Application server using
HTTP protocol Emulate both the numbered keyboard and the
LCD screen Communicate with the fingerprint sensor using
Futronic Fingerprint SDK
![Page 21: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/21.jpg)
21
Web Interface Levels of Access
One level Instructor
Functions: Detailed Report of Students’ Attendance in a
Section View, edit absence records Email Approve Warnings
![Page 22: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/22.jpg)
22
Testing
Validation Testing Fingerprint Terminal Database Web Interface
Release Testing Class Attendance Tracking Database
System
![Page 23: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/23.jpg)
23
Security Avoid Security By Obscurity Allow only authorized users to gain access Restrictive regarding which characters to
allow in URL strings Filter the data as if it were tainted Validate the data to ensure it confirms the
correct type, length and size Escape the data before submitting it into the
database All cookies are encrypted
![Page 24: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/24.jpg)
24
Conclusion
Engineering Aspects
Sustainability & Manufacturability Prototype Implementation
Economic
![Page 25: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/25.jpg)
25
Conclusion Standards
Fingerprint Terminal Emulator Java Standard Edition 6 (1.6)
Web Interface XHTML 1.0 (A Reformulation of HTML 4 in XML 1.0) Cascading Style Sheets 2.1 (CSS 2.1) ECMAScript (aka. JavaScript) ECMA-262
specification and ISO/IEC 16262 Communication
Hypertext Transfer Protocol -- HTTP/1.1 (RFC 2616) JSON (JavaScript Object Notation) (RFC 4627)
![Page 26: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/26.jpg)
26
Conclusion
Why SQU should adapt this solution? Environment (paperless) Lower total-cost of ownership Time-effective Easy and fast access to data Less human error (more affective tracking
system)
![Page 27: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/27.jpg)
27
DEMO
![Page 28: Class Attendance Tracking Database System Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah](https://reader030.vdocuments.us/reader030/viewer/2022020219/56649d195503460f949eea1d/html5/thumbnails/28.jpg)
28
Questions !!