Customer Query Track

ABSTRACT

This project is mainly used to track the queries of the customers in the organization and resolve the queries. This Project also sends the services to the customer to find out the customer satisfaction and employee performance. The system has a major problem in finding the product support and service activities that are undertaken by the employees. Once the products have installed at the client’s site, the cycle of warranty maintenance starts. To keep the customers in a proper chain of satisfaction the system needs the data to be organized in a proper relational way. The project is to maintain the relational communication among the project is to maintain this relational communication among the data, such that consistency, reliability and integrity can be achieved. The major technicality within the system lies in managing the coordination among the sales and service departments, which is the major hold upon the system to gain or achieve profits.

The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the “SQL Connection” methodology. The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.

The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage. The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The total front end was dominated using the ASP.Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest “SQL Connection” technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely.

INTRODUCTION TO PROJECT

The project is to maintain the relational communication among the project is to maintain this relational communication among the data, such that consistency, reliability and integrity can be achieved. The major technicality within the system lies in managing the coordination among the sales and service departments, which is the major hold upon the system to gain or achieve profits.

PURPOSE OF THE PROJECT

This project is mainly used to track the queries of the customers in the organization and resolve the queries. This Project also sends the services to the customer to find out the customer satisfaction and employee performance. The system has a major problem in finding the product support and service activities that are undertaken by the employees. Once the products have installed at the client’s site, the cycle of warranty maintenance starts. To keep the customers in a proper chain of satisfaction the system needs the data to be organized in a proper relational way.

PROBLEM IN EXISTING SYSTEM

  • Cannot Upload and Download the latest updates.
  • No use of Web Services and Remoting.
  • Risk of mismanagement and of data when the project is under development.
  • Less Security.
  • No proper coordination between different Applications and Users.
  • Fewer Users - Friendly.

SOLUTION OF THESE PROBLEMS

The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.

1.   User friendliness is provided in the application with various controls.

2.   The system makes the overall project management much easier and flexible.

3.   Readily upload the latest updates, allows user to download the alerts by clicking the URL.

4.   There is no risk of data mismanagement at any level while the project development is under process.

5.   It provides high level of security with different level of authentication.

PROPOSED SYSTEM

To debug the existing system, remove procedures those cause data redundancy, make navigational sequence proper. To provide information about audits on different level and also to reflect the current work status depending on organization/auditor or date. To build strong password mechanism.

NEED FOR COMPUTERIZATION

We all know the importance of computerization. The world is moving ahead at lightening speed and every one is running short of time. One always wants to get the information and perform a task he/she/they desire(s) within a short period of time and too with amount of efficiency and accuracy. The application areas for the computerization have been selected on the basis of following factors:

·         Minimizing the manual records kept at different locations.

·         There will be more data integrity.

·         Facilitating desired information display, very quickly, by retrieving information from users.

·         Facilitating various statistical information which helps in decision-making?

·         To reduce manual efforts in activities that involved repetitive work.

·         Updating and deletion of such a huge amount of data will become easier.

NUMBER OF MODULES

The system after careful analysis has been identified to be presented with the following modules:

The Modules Involved in the project are:

1. Customer’s Module

2. Employee’s Module

3. Search

4. Authentication

1. Customer’s Module:

The Customer’s Module is designed to provide the following services.

i) Posting a Query:

  • Customers should be free to post their queries to the concern department.
  • The system must identify each query with an automatically generated Query Id, for future references.

ii) Survey Details:

  • Customers should be able to post the survey details on a department by simply selecting the department and post the survey details to the organization.
  • In survey details service the system provides the rate of satisfaction of the customer on a particular employee.
  • The rate of satisfaction can be known by giving ratings to the employee.

iii) Status

  • Customers should be allowed to check the status of their query, by using the unique Query Id provided by the system.
  • The system must display the answers along with the Query to the customer, after posting the query.

2. Employee’s Module:

In this Employee’s Module we have two services, which are

i). Posted Queries:

  • The employees should be able to see the posted queries, which are posted by the customers.
  • An employee can visit the queries posted to that department only.
  • The employee should post back the solution to the queries he has received.
  • An employee cannot only see his rating but also rating of other employees who are working in other departments.

ii). Survey:

  • The employees should be able to see the survey details posted by the customers.
  • He can able to see the survey details of all the departments.
  • This system should also provide registration of new customers for the organization.
  • The customers should be able to see the frequently asked question asked by the customers.

A password protection with secure mode option is provided to guard from un-authorized access to database.

PROJECT INSTRUCTIONS:

Based on the given requirements, conceptualize the Solution Architecture. Choose the domain of your interest otherwise develop the application for ultimatedotnet.com. Depict the various architectural components, show interactions and connectedness and show internal and external elements. Design the web services, web methods and database infrastructure needed both and client and server.

Provide an environment for upgradation of application for newer versions that are available in the same domain as web service target.

HARDWARE SPEDIFICATIONS

HARDWARE REQUIREMENTS:

  • PIV 2.8 GHz Processor and Above
  • RAM 512MB and Above
  • HDD 20 GB Hard Disk Space and Above

SOFTWARE REQUIREMENTS:

  • WINDOWS OS (XP / 2000 / 200 Server / 2003 Server)
  • Visual Studio .Net 2005 Enterprise Edition
  • Internet Information Server 5.0 (IIS)
  • Visual Studio .Net Framework (Minimal for Deployment)                          
  • SQL Server 2000 Enterprise Edition