ACADEMIC PROJECT · 2026
Smart Home Database.
A Node.js/Oracle REST API with SQL injection safeguards and transaction handling, backed by a 3NF-normalized schema across 20+ tables.
Devices, rooms, residents, schedules, and usage logs all reference each other — a flat schema either duplicates data or can't answer real queries.
SQL injection prevention
Protected database operations from SQL injection at the REST query layer.
Transaction handling
Implemented transactions for database operations that must succeed or fail together.
3NF-normalized schema
Designed a 3NF-normalized schema across 20+ tables in Oracle, eliminating the redundancy a flatter design would carry.
REST query layer
Built Node.js REST endpoints for CRUD plus relational algebra operations — aggregation, division, and multi-table joins.
Implemented SQL injection prevention across database-facing endpoints.
Added transaction handling for operations that must succeed or fail together.
Designed the full 3NF schema across 20+ tables.
Built the Node.js REST API and query layer, including relational-division queries.