Scribd
Upload
64 views

Query Handling System

The document describes a proposed query handling system for universities. The system would allow students to post questions to various departments, and it would maintain a database of frequently asked questions that could be accessed by all students. Administrators in each department would be responsible for answering student questions and updating the database. The system aims to make the query process more efficient and convenient compared to the existing manual system. It would allow administrators to handle more students and easily maintain a database of questions.

Uploaded by

sangeetha s
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
64 views

Query Handling System

The document describes a proposed query handling system for universities. The system would allow students to post questions to various departments, and it would maintain a database of frequently asked questions that could be accessed by all students. Administrators in each department would be responsible for answering student questions and updating the database. The system aims to make the query process more efficient and convenient compared to the existing manual system. It would allow administrators to handle more students and easily maintain a database of questions.

Uploaded by

sangeetha s
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 4

Query Handling System

ABSTRACT

This project will be designed and developed for universities of about QUERY HANDLING
SYSTEM are posted to various departments. The University examination branch wants to
maintain all the frequently asked questions in the database subject wise, to avail them to all the
students. And they will update the questions as and when required. The primary goal of a Query
Handling System is to provide an environment that is both convenient and efficient to use in
retrieving and storing database information.
The database system must provide for the safety of the information stored, despite system
crashes or attempts at unauthorized access. If data are to be shared among several users, the system
must avoid possible anomalous results.

Problem Statement

Problem statement is one of the basic and important phases of project phase. When the basic
problem is determined, it is documented and the symptomatic problem is analyzed, then the
current list of basic problem is completed. A system is simply a set of components that interact to
accomplish some purpose.
In “Query Handling System ” maintaining the details of various frequently asked questions
posted by the students to the administrators of consult department are to be kept in a data base and
also can be retrieved easily when the admin answers that question.

Actually the process going on here is when the students wants to clear their queries they
personally contacts with the concerned person in the university.

The difficulty in the present system is students face some difficulties to contact the concerned
person in the university.
This project is developed using Java Programming Language under Windows.
Existing System

The existing system is a manual one. When the student wants to clear his query he personally
contacts the concerned person in the university. The concerned person will clear his doubt.

Disadvantages:

 Difficulty in contacting the concerned person.


 Difficult to handle more students for administrator.
 Difficulty of maintaining frequently asked questions in a data base

Proposed System

The Query Handling system is to replace the existing manual system with a software solution.

The University examination branch wants to maintain all the frequently asked questions
in the database subject wise, to avail them to all the students. And they will update the questions
as and when required in online.
The proposed system has one super user to control the data, appointing the administrators in
each department. The administrator is responsible to answer all the questions posted by students.

When the student post a question in certain department the respective administrator will
answer the question and a copy of the answer will be sent to the student.

Merits of This System

 Faster processing when compared to existing one.


 Maintaining frequently asked questions
 Modifications of answers can be carried out immediately
 Administrator can handle more number of students.
 Easy maintenance of administrator details.
MODULE DESCRIPTION

The project contains three modules

 Super User:
 Administrator
 Student

Module 1: Super User


The responsibility of the super user is to centrally control the data, appoint administrators to all
the departments and shifting the administrators one department to other and replacing with others
when there is a vacancy in any departments.

The super user can also have a right to change the questions like adding deleting the records
from the database.

The super user provides the login names and password for entire administrators
department wise.

Module 2: Administrator
Each department will have one or more administrator; some departments may have more than
one administrator. The major responsibility of administrator is to answer all the questions posted by
students on a regular basis.

The administrator can add, modify or remove questions from all the

Categories (about the question categories described below).

All the questions posted by the students will be added to the list of existing questions
only when the administrator answers that question, simultaneously a copy of answer is sent to
student who initiated that question.
Administrator also reserves a right to post a question into a particular category even if it is not a
question frequently asked.
The administrators have the capability of changing his password as when he requires.

Module 3: Students

These are the users at the lower level of our abstraction. Before posting a question, the student
has to select the department to which it belongs. A copy of the answer will be sent to the student
after the administrator answered his question.

Software Interfaces

 Operating System: Windows 20


 Database : mysql
 Server : Tomcat 5.0
 Explorer : Microsoft Internet Explorer

HARDWARE REQUIREMENTS

 Hard Disk : 40 GB IDE Hard disk


 RAM : 256 MB
 Processor: Pentium- III

You might also like