1 / 28

Class Attendance Tracking Database System

Class Attendance Tracking Database System. Done by: Hussain Al-Lawati Isehaq Al-Mamari Al-Muatasim Al-Bahri Under Supervision of: Dr. Fahad Bait Shiginah. Class Attendance Tracking Database System. Current Attendance Tracking System: Papers Waste of resources Bins full of papers

dorisrobinson
Download Presentation

Class Attendance Tracking Database System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

  2. Class Attendance Tracking Database System Current Attendance Tracking System: Papers Waste of resources Bins full of papers Signatures Cheating (Illegal)

  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

  4. Objective To implement a system that track attendance using: Database system: Track of all information Fingerprints: Identity Recognition  Automatically generates absent warning

  5. Background

  6. Biometrics • What Biometric is?

  7. Fingerprint Sensors

  8. Database • Files Vs. DBMS • Files  Complex Code for Queries • Security of Data • RDBMS

  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)

  10. System Requirements • Non-Functional Requirements • Cost-effective • Open source • Usability

  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)

  12. System Use-Case Diagram

  13. ECCE5009 Wednesday 8:00am Class Started Z z z ECCE5009 Wednesday 10:00am End of the Class Attendees • Attendees • Ishaq • Attendees • Ishaq • Al Muatasim Database absence_records

  14. System Architecture • Decentralized Vs. Centralized. • Factors - Fingerprints Capacity - Labor work - Flexibility Centralized Wins !!

  15. System Architecture

  16. ER Diagram

  17. Database Design

  18. Prototype Implementation

  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.

  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

  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

  22. Testing • Validation Testing • Fingerprint Terminal • Database • Web Interface • Release Testing • Class Attendance Tracking Database System

  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

  24. Conclusion • Engineering Aspects • Sustainability & Manufacturability • Prototype Implementation • Economic

  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)

  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)

  27. DEMO

  28. Questions !!

More Related