Computer Project File
Smart Complaint Tracker & Public Resolve
Introduction of the Project
In today’s digital age, efficient complaint management has become essential for
maintaining accountability and transparency in administrative systems. Manual
or paper-based methods are often slow, error-prone, and difficult to track,
leading to delays and citizen dissatisfaction. The Smart Complaint Tracker
project aims to overcome these challenges by providing a digital platform that
simplifies complaint registration, monitoring, and resolution. It ensures citizens
can easily lodge grievances while allowing authorities to systematically track
progress, assign responsibilities, 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 timely follow-up through structured data management. A
centralized MySQL database stores information about citizens, 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 systematically allowing citizens to remain informed about
their issue’s progress while providing administrators with insights for service
improvement.
By replacing traditional systems with an automated digital framework, Smart
Complaint Tracker brings efficiency, reliability, and accessibility to public
service management. Citizens can register complaints from anywhere, and
administrators can assign or resolve them directly through the system. Core
features such as citizen registration, officer management, complaint tracking,
and automated reporting make it highly suitable for educational institutions,
municipal bodies, and office environments. Ultimately, the project demonstrates
how integrating technology into administrative processes can improve
responsiveness, promote transparency, and foster trust between citizens and
authorities.
Modules Used in the Project
Module Name Description
A Python library used to establish connectivity between the Python
program and the MySQL database. It enables data insertion, retrieval,
[Link]
updates, and deletions through SQL queries executed directly within
Python.
A formatting library that displays tabular data in an organized, grid-like
structure for better readability in the console. It enhances user
tabulate
experience by presenting database outputs in a clear and professional
format.
An in-built Python module used for handling dates and times. It helps
datetime record complaint filing and resolution dates automatically, ensuring
accurate timestamping for database entries.
Manages citizen-related operations such as registration, viewing,
citizens module
searching, updating, and deletion of citizen records from the database.
Handles officer information, allowing addition, modification, and
officer's module
retrieval of officer details responsible for resolving complaints.
Acts as the project’s core component for lodging, assigning, updating,
complaint
and tracking complaints, while linking them to citizens and officers via
module
relational keys.
Generates and exports summarized reports of complaints into text
report module format, providing administrators with a quick overview of complaint
statuses and resolutions.
Usage of Key Modules in the Project
• [Link]: Used to connect the Python program with the MySQL server.
It allows CRUD operations (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 interactions.
• datetime: Utilized in the complaint registration and update modules to
automatically capture and store the date of complaint filing (date_filed) and
resolution (date_resolved), improving accuracy and traceability.
Tables Used in the Project
1. citizens table: -
table 1: citizens table with sample data
table 2: structure of the citizens 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
Citizens Management Module
1. Citizen Management Module Menu
2. Add new citizen
3. View all citizens
4. Search Citizen
i. By citizen ID
ii. By citizen name
5. Update Citizen
6. Delete Citizen
Updated Database -
Officer Management Module
1. Officer Management Module Menu
2. Add Officer
3. View All Officers
4. Search Officer
i. By Officer ID
ii. By Officer Name
5. Update Officer
6. Delete Officer
Updated Database -
Complaint Management Module
1. Complain Management Module Menu
2. File New Complaint
3. View All Complaints
4. Update Complaint Status
5. Delete Complaint
6. Search Complaint
i. By complaint ID
ii. By citizen name
Generate Complaint Report
Contents of [Link]