FAQ-O-Matic System (Java projects)

ABSTRACT

This project will be designed and developed for universities of about FAQ 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 FAQ-O-Matic 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. System Analysis is first stage according to System Development Life Cycle model. This System Analysis is a process that starts with the analyst.

            Analysis is a detailed study of the various operations performed by a system and their relationships within and outside of the system.  One aspect of analysis is defining the boundaries of the system and determining whether or not a candidate system should consider other related systems.  During analysis, data are collected on the available files, decision points, and transactions handled by the present system.Logical system models and tools that are used in analysis.  Training, experience, and common sense are required for collection of the information needed to do the analysis.

 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

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 administrator’s 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

SYSTEM REQUIREMENT SPECIFICATION:

Software Requirements:

Operating System:  Windows 20

Database              :  Oracle 9i

Server                   :  Tomcat 5.0

Explorer                :  Microsoft Internet Explorer

Hardware Requirements:

Processor         :           Pentium- III

Cache              :           256 KB Cache

FDD                :           1.44 MB Floppy drive

Hard Disk       :           40 GB IDE Hard disk

RAM               :           1GB