Complaint Management System
Description
The Complaint Management System is a robust full-stack Java-based web application designed to streamline and enhance the process of handling complaints within an organization. This comprehensive system employs a stack of technologies, including Java, Servlets, JSP, HTML, CSS, MySQL, JDBC, and Tomcat Server 9.0, ensuring efficient functionality and user-friendly interfaces for employees, administrators (Admin/HODs), and engineers.
Roles and Responsibilities
Admin/HOD
- Login/Logout: Admins have secure access to the system, ensuring data integrity.
- Complaint Management: Admins can view all complaints raised by employees, facilitating centralized oversight.
- Assignment and Updates: They have the authority to assign and update engineers to specific complaints, expediting issue resolution.
- Engineer Management: Admins can register or remove engineers from the database as necessary, maintaining an up-to-date workforce.
- Engineer Tracking: Admins can view working engineers categorized by department for resource allocation.
Employee
- Registration/Login/Logout: Employees can securely sign up and log in to the system.
- Complaint Registration: Employees can easily register complaints, providing comprehensive details for effective communication.
- Complaint Tracking: They have access to monitor all complaints they have raised and can search for specific ones, promoting transparency.
- Password Management: Employees have the capability to change their passwords, enhancing account security.
Engineer
- Login/Logout: Engineers securely access the system for efficient operations.
- Complaint Updates: Engineers can update the status of the complaints they are handling, ensuring timely resolution and effective communication.
- Solved Complaints: Engineers can access records of all solved or partially solved problems, maintaining accountability and reference.
- Password Change: Engineers have the option to change their passwords, adhering to account security standards.
Screenshots
ER Diagram
Complaint List
Engineer List
Assign Engineer
Register Engineer
Newly Assigned Query to Engineer
Attempted Query
Change Password
