Computer Project File
Smart Complaint Tracker & Public Resolve
Introduc on of the Project
In today’s digital age, efficient complaint management has become essen al for
maintaining accountability and transparency in administra ve systems. Manual or
paper-based methods are o en slow, error-prone, and difficult to track, leading to
delays and ci zen dissa sfac on. The Smart Complaint Tracker project aims to
overcome these challenges by providing a digital pla orm that simplifies complaint
registra on, monitoring, and resolu on. It ensures ci zens can easily lodge grievances
while allowing authori es to systema cally track progress, assign responsibili es, and
maintain a clear, centralized record of all complaints.
The primary goal of this project is to establish an organized and automated workflow
for handling public complaints. It reduces manual effort, minimizes errors, and
ensures mely follow-up through structured data management. A centralized MySQL
database stores informa on about ci zens, officers, and complaints, enabling quick
retrieval and analysis. The project also enhances transparency and accountability by
ensuring that every complaint is processed, updated, and recorded systema cally
allowing ci zens to remain informed about their issue’s progress while providing
administrators with insights for service improvement.
By replacing tradi onal systems with an automated digital framework, Smart
Complaint Tracker brings efficiency, reliability, and accessibility to public service
management. Ci zens can register complaints from anywhere, and administrators can
assign or resolve them directly through the system. Core features such as ci zen
registra on, officer management, complaint tracking, and automated repor ng make
it highly suitable for educa onal ins tu ons, municipal bodies, and office
environments. Ul mately, the project demonstrates how integra ng technology into
administra ve processes can improve responsiveness, promote transparency, and
foster trust between ci zens and authori es.
Acknowledgement
I Nirmal Panchal student of class 12. I would like to express my sincere gra tude
to all these individuals for mentoring and suppor ng me in comple ng this
project. My teacher Dipali Gandhi for providing me with invaluable insights and
direc on.
Our esteemed principal Shailja Singh for fostering an environment of learning
and crea vity within our school. To my parents, their constant encouragement,
pa ence, and understanding have been the pillars of my success. I am grateful to
my friends who contributed ideas and perspec ves that enriched the project.
Thank you everyone for shaping this project and enhancing my
learning experience.
Modules Used in the Project
Module Name Descrip on
A Python library used to establish connec vity between the Python
program and the MySQL database. It enables data inser on, retrieval,
[Link]
updates, and dele ons through SQL queries executed directly within
Python.
A forma ng library that displays tabular data in an organized, grid-like
tabulate
structure for be er readability in the console. It enhances user experience
by presen ng database outputs in a clear and professional format.
An in-built Python module used for handling dates and mes. It helps
date me record complaint filing and resolu on dates automa cally, ensuring
accurate mestamping for database entries.
Manages ci zen-related opera ons such as registra on, viewing, searching,
ci zens module
upda ng, and dele on of ci zen records from the database.
Handles officer informa on, allowing addi on, modifica on, and retrieval of
officer's module
officer details responsible for resolving complaints.
Acts as the project’s core component for lodging, assigning, upda ng, and
complaint module tracking complaints, while linking them to ci zens and officers via rela onal
keys.
Generates and exports summarized reports of complaints into text format,
report module providing administrators with a quick overview of complaint statuses and
resolu ons.
Usage of Key Modules in the Project
• [Link]: Used to connect the Python program with the MySQL server. It
allows CRUD opera ons (Create, Read, Update, Delete) on the database tables
(citizens, officers, complaints) through SQL commands executed via Python
cursors.
• tabulate: Used to format and display database query results neatly within the
terminal. It transforms raw MySQL query outputs into readable, aligned tables for
user and admin interac ons.
• datetime: U lized in the complaint registra on and update modules to
automa cally capture and store the date of complaint filing (date_filed) and
resolu on (date_resolved), improving accuracy and traceability.
Tables Used in the Project
1. ci zens table: -
table 1: ci zens table with sample data
table 2: structure of the ci zens table
2. officers table: -
table 3: officers table with sample data
3. complaints table: -
table 5: complaints table with sample data
table 6: structure of the complaints table
Source Code of the Project
Output
Main Menu
Ci zens Management Module
1. Ci zen Management Module Menu
2. Add new ci zen
3. View all ci zens
4. Search Ci zen
i. By ci zen ID
ii. By ci zen name
6. Delete Ci zen
Updated Database -
Officer Management Module
1. Officer Management Module Menu
2. Add Officer
3. View All Officers
i.
ii. By Officer Name
5. Update Officer
6. Delete Officer
Updated Database -
Complaint Management Module
1. Complain Management Module Menu
3. View All Complaints
4. Update Complaint Status
5. Delete Complaint
6. Search Complaint
i. By complaint ID
ii. By ci zen name
Generate Complaint Report
Contents of [Link]