Are you looking for a basic yet functional project to enhance your Python skills? The Simple Complaint Management System is an ideal mini project designed specifically for beginners. It’s an easy-to-use console-based application that enables users to add and view complaints, making it an excellent introduction to working with databases and user input in Python.
Table of Contents
About the Project
The Simple Complaint Management System project is developed in Python, and its functionality is simple but effective. The project files include key Python scripts such as main.py, db.py, and listComp.py. This mini project focuses on core functionalities such as adding new complaints and viewing existing complaints, providing a straightforward experience for users without complex logins or registration.
Add Complaints: Users can submit complaints quickly and easily. When adding a complaint, users are prompted to provide:
Full Name
Gender (chosen from options)
Complaint/Comments This data is stored in the external database, making the system efficient for keeping records of all submitted complaints.
List Complaints: Users can view all submitted complaints, displayed with their respective details, including:
ID number (auto-generated)
Name
Gender
Complaint
This makes it easy for an administrator or user to view the list of complaints, making the system useful for small-scale organizations or educational environments looking to manage feedback or issues.
This project’s utilization of an external database is one of its highlights. Instead of keeping the data temporarily in memory, all complaints are stored permanently in a database, allowing users to retrieve and view complaint lists anytime. This feature provides a strong learning experience for beginners in Python, giving them exposure to database connections and data management.
Why This Project is Perfect for Beginners
This Simple Complaint Management System serves as a perfect stepping stone for those new to Python programming. It introduces essential concepts such as:
Handling user inputs through the console
Database connectivity and storage
Displaying data in a user-friendly format
By working on this project, beginners will get hands-on experience with creating a basic management system, giving them the confidence to tackle more complex projects down the road.
The Simple Complaint Management System in Python is free to download and use for educational purposes. It’s a great tool for learning the basics of Python, database integration, and console-based application development. It is not intended for commercial use, but can serve as a valuable learning resource.
Project Features
Add new complaints
View complaint list
Permanent database storage for complaints
Simple and easy-to-use interface
Here’s the source code for the Simple Complaint Management System in Python. This project includes the essential features of adding complaints and viewing complaint lists, with basic database interaction.
This is the main file that runs the application and interacts with the user.
import db # Import the database module
import listComp # Import the module for listing complaints
def menu():
print("\nSimple Complaint Management System")
print("1. Add Complaint")
print("2. View Complaints")
print("3. Exit")
choice = input("Enter choice: ")
return choice
def add_complaint():
print("\nEnter Complaint Details")
full_name = input("Full Name: ")
gender = input("Gender (M/F): ")
comments = input("Complaint: ")
# Store the complaint in the database
db.add_complaint(full_name, gender, comments)
print("Complaint added successfully!\n")
def view_complaints():
print("\nList of Complaints:")
listComp.show_complaints()
if __name__ == "__main__":
while True:
choice = menu()
if choice == "1":
add_complaint()
elif choice == "2":
view_complaints()
elif choice == "3":
print("Exiting the system.")
break
else:
print("Invalid choice! Please try again.")
2. db.py
This module handles database-related operations, such as adding complaints and fetching them.
import sqlite3
# Connect to the SQLite database (or create it if it doesn't exist)
connection = sqlite3.connect('complaints.db')
cursor = connection.cursor()
# Create the complaints table if it doesn't exist
cursor.execute('''
CREATE TABLE IF NOT EXISTS complaints (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
gender TEXT NOT NULL,
comments TEXT NOT NULL
)
''')
connection.commit()
# Function to add a complaint to the database
def add_complaint(name, gender, comments):
cursor.execute('''
INSERT INTO complaints (name, gender, comments)
VALUES (?, ?, ?)
''', (name, gender, comments))
connection.commit()
# Function to fetch all complaints from the database
def get_complaints():
cursor.execute('SELECT * FROM complaints')
return cursor.fetchall()
3. listComp.py
This module is responsible for displaying the list of complaints.
import db # Import the database module to fetch complaints
# Function to display the complaints
def show_complaints():
complaints = db.get_complaints()
if len(complaints) == 0:
print("No complaints found.")
else:
print("\nID | Name | Gender | Complaint")
print("-" * 40)
for complaint in complaints:
print(f"{complaint[0]} | {complaint[1]} | {complaint[2]} | {complaint[3]}")
Simple Complaint Management System in Python
Simple Complaint Management System in PythonSimple Complaint Management System in PythonSimple Complaint Management System in Python
How to Run the Project
Copy and save each code block into separate Python files: main.py, db.py, and listComp.py.
Ensure you have SQLite installed (which comes built-in with Python).
