Query Handling System

ABSTRACT This project is be designed and developed to handle Frequently Asked Questions posted to various departments in a university. The University examination branch wants to maintain all the frequently asked questions in the database subject wise, to avail them to all the students whenever necessary. They will update the questions as and when required. The primary goal of the Query Handling Service is to provide an environment that is both convenient and efficient to use in retrieving and storing the information into database.. The database system must provide the safety to the information stored, despite system crashes or attempts of unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results. 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 in maintaining frequently asked questions manually Proposed System The Query Handling Services 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. Modules: • Super User • Administrator • Student Super User: super user to control the data, appointing the administrators in each department,appointing the administrator to a particular department for that he register the admin,adding a new departments like computer science, chemistry, physics, maths, etc.. At the same time he can delete the departments, adding a new topic to particular department. At the same time he delete the added topics also, adding the question with answers and storing the data in database. Administrator:  Admin can add the question with answers and it will be stored in database for students to retrieve it.  Admin will modify the answers.  The student post a question in certain department the respective administrator will answer the question and a coRead less