Database management system for an application that ensures the safety and convenience of gated societies. It offers features to create a wholesome community living experience and improve security standards around gated communities.
Frontend implemented with streamlit and mysql server.
🐍 Frontend python code
📀 DDL statements with constraints and queries
🏛️ Schema info
Install dependencies and specify host, user, database and password to mysql.connecttor
(in streamlit-and-mysql-ui/database.py), create database and run using streamlit run app.py
- Raise, view tickets (from a resident's POV)
- Assign staff, update ticket response and status, delete ticket (from help desk POV)
- Outputs any SQL query typed as text input.
Based off the bangalore startup MyGate, implemented part of it as a DBMS mini project!
Logo taken from here.