SGIF Fire Management System
Database and Interface System
Project Description
SGIF, standing for “Sistema de Gestão de Incêncios Florestais” (Forest Fire Management System), was a Database Class Project (2018) which aimed to build a database and interface to manage all info pertaining to active emergency scenarios and the means allocated to them.
Development Process
In order to achieve this, we first began by studying the problem and data we were dealing with and subsequently carefully designing the Entity-Relationship Diagrams to represent what we wanted our schema to look like.
After this step was complete we used PostgreSQL to build and deploy a flexible and organized database according to the plan laid out previously, always making sure to follow the best practices.
Finally, it was time to build an interface that could be used to query the data aggregated in the database as well as input new info and edit old entries. For this, we built a rudimentary website with HTML and Javascript and used PHP to run and sanitize queries.