context
A navigable operating model for grid monitoring
The assignment supplied an IoT monitoring database. I interpreted it as a simplified electrical-grid SCADA and extended the minimum interface into a navigable operating tool.
problem
Protecting the dashboard from invalid relationships
Sensor readings were only useful if relationships between substations, transformers and devices remained valid. Invalid ranges, duplicates and orphaned associations could undermine the dashboard.
approach
Validated management flows without changing the schema
I implemented management flows for substations, transformers, sensors and readings using PHP, HTML, CSS and MariaDB. Validation covered required fields, numeric ranges, duplicate records and referential existence without changing the supplied schema.
results
End-to-end monitoring with stronger data quality
The final application supported end-to-end navigation, monitoring and data maintenance while preserving database compatibility. The additional validation made data-quality failures visible at entry time.
next
From coursework application to operating platform
Add time-series aggregation, alarm acknowledgement, role-based access and an edge-to-cloud ingestion contract.