A comprehensive relational database solution for automating the borrowing lifecycle of IoT devices within academic institutions. Built with MySQL, normalized to BCNF.
Everything you need to manage IoT device lending operations efficiently and reliably.
Real-time tracking of all devices, models, and their physical condition with location mapping.
Streamlined loan processing with automatic due date tracking, overdue detection, and fine calculation.
Priority-based reservation queue allowing students to book specific device models in advance.
Schedule and monitor maintenance windows to ensure damaged devices are not loaned out.
Four distinct user roles with granular permissions: Admin, Librarian, Assistant, and Student.
Generate detailed reports on loans, fines, popular devices, and overall system statistics.
11 normalized tables following Third Normal Form (3NF) and BCNF for optimal data integrity.
The brilliant minds behind the Laksa project.
A25MJ4015
Team Lead
A25MJ4014
Database Designer
A25MJ4012
SQL Developer
A25MJ4009
Documentation
A25MJ4016
Testing & QA