GRIEVANCE HANDLING SYSTEM

Presented By : Nitika Gupta

Pooja Gupta

Arun Kr Bhardwaj

Yugank

INTRODUCTION OBJECTIVE

TOOLS AND TECHNOLOGY

PROBLEM DEFINITION REQUIREMENT SPECIFICATION NON FUNCTIONAL REQUIREMENT

SCOPE OF THE SOLUTION

CONTENTS

COMPLETE STRUCTURE - MODULE DISCRIPTION

FUTURE SCOPE

INTRODUCTION

“Grievance” means “grieve” or “complain”. So, main motto of our site is to handle the problem of user, by saving the time and money of the user. User has to simply log-in into our site and post his/her queries. Administrator checks all the queries and reply to the relevant problems.

The Grievance Handling System is online software that stores the whole information about the grievance that helps the User as well as Administrator to handle the grievance process.

It provides the details about different kind of services in different department like electricity, engineering, health, taxation and water department to the user.

This system handles the details of grievances received, action taken and status of the grievances. Users with access to the Web can enter their grievances and find out the status of its processing. Each grievance will be assigned a unique id for reference.

OBJECTIVES

To manage all the user details who get in touch with the site.

All the information should be accepted online. All the information regarding various users should be

stored in a well prepared manner. Retrieval of data from the database should be easy

and there should be no database problem. Valid check should be implemented. To provide all the information about there grievance

and report the action taken about the user report. To provide the facility of reminder about grievance

time to time. To provide update and latest information to the

customers. To provide secure environment to data.

TOOLS & TECHNOLOGY :

o What is .Net ?

oWhat is ASP.Net Framework ?

oWhat is SQL Server ?

Administrator can perform the following tasks:

He/she has a login-id & password. Change the password Check the grievance through date or

department. Add comments on the grievance. Set the status of the form. Read the feedback form. Reply to the queries of the visitor. Can watch the reminder form.

AUTHORITIES OF ADMIN :

ER DIAGRAM FOR USER AND ADMIN

user Has Login1 1

Grievance

Post

M

1

Submit

1

M

reminder

Feedback1

Get

1

M Help

Administrator

View

M

1

Resolve/view

1

M

Read

1

M

Login Has 11

response

1

1 User comment

PincodePhone_noE_mail

sex

Mobile_no

dob

Sec_pue

answer

U-address

U_name

User_id

password

User_id

Comment

Comp_no

Compt_titleCompt_loc

address

Dos

Dept

U-name

phone

Mobile_no

email

complain

Status

Pin_code

Admin_idpassword

name

E_mail

date suggestion

Admin_id

password

Compt_no

comment

DATA STRUCTURE OF ADMIN :

Field Type Description Constraint

admin_id nvarchar2 Login name for administrator

Not null

Pwd nvarchar2 Password for security Not null

.Primary key: admin_idForeign key: none

TABLE 1: AdminpasswordPURPOSE: This table is used for storing the login id and password of the Administrator

Field Type Description Constraintscomp_no nvarchar2 Grievance no randomly generated Not Null

Dos nvarchar2 Date of the grievance submitted Not Null

Dept nvarchar2 Department to which problem belong Not Null

Name nvarchar2 Name of the sender Not NullAddress nvarchar2 Address of the sender Not null

Pincode nvarchar2 Pin-code of the sender Not null

ph_no Integer Phone number of the sender Not null

Integer Mobile number of the sender Not nul

e_mail nvarchar2 E-mail address of the sender Not null

comp_loc nvarchar2 Location of the complaint Not null

comp_title nvarchar2 Title of the complaint Not null

Status nvarchar2 Status of the grievance Not null

Complaint nvarchar2 Complaint send to administrator Not null

TABLE 2: Grievance

PURPOSE: This table stores the information related to the grievance filled by the user and fetched by the administrator.

Primary key : comp_noForeign key: none

MODULE DESCRIPTION

•Manage Grievance•Manage user

Sub modules of ADMIN.