Computer Lab LMS
Hardware Lab Inventory & Fault Ticketing System with 3NF Schema
Technical Blueprint
ArchitectureSystems & Security
Release Year2025
Deployment StatusComplete
Core Technologies3 Libraries / Tools
Technologies Deployed
Project Architecture & Overview
Enterprise lab management software developed for collegiate computer labs. Manages workstation serial numbers, peripheral health status, maintenance schedules, and student fault reporting with a normalized 3NF relational database structure.
Key Engineering Milestones
- ✦Third Normal Form (3NF) relational MySQL schema preventing data anomalies
- ✦Role-based access control (Admin, Lab Assistant, Student) with secure session hashing
- ✦Automated hardware maintenance reminder triggers and repair log history
- ✦Comprehensive inventory export with departmental device audit metrics
