ACADEMIC PROJECT · 2026
Smart Home Database.
A 3NF-normalized relational schema across 20+ tables, with Node.js/Oracle REST endpoints supporting CRUD, aggregation, division, and multi-table joins.
01 · THE PROBLEM
Devices, rooms, residents, schedules, and usage logs all reference each other — a flat schema either duplicates data or can't answer real queries.
02 · KEY FEATURES
01
3NF-normalized schema
Designed a 3NF-normalized schema across 20+ tables in Oracle, eliminating the redundancy a flatter design would carry.
02
REST query layer
Built Node.js REST endpoints for CRUD plus relational algebra operations — aggregation, division, and multi-table joins.
03 · WHAT I OWNED
Designed the full 3NF schema across 20+ tables.
Built the Node.js REST API and query layer, including relational-division queries.