10-04-2017, 09:02 PM
ABSTRACT
This project will be designed and developed for university of Ballarath about FAQ s 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.
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 FAQ-O-Matic 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.
SYSTEM ANALYSIS
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
Proposed System
The FAQ-O-Matic 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.
Question categories:
All the questions are categorized into five categories (A, B, C, D & E)
Category A: If the question frequency is more than seven times in a day
Category B: If the question frequency is more than 6-7 times in a day
Category C: If the question frequency is more than 3-5 times in a day
Category D: If the question frequency is more than 1-2 times in a day or
if the administrators feel that the question in category E is
an important he can push that question from category E to D
Category E: As soon as the student posted a question to the administrator,
immediately the E Category will register it.
HARDWARE AND SOFTWARE
REQUIREMENTS
Hard ware Specification:
Processor : Intel P-II based system
Processor Speed : 250 MHz to 833MHz
RAM : 256 MB to 512 MB
Hard Disk : 10GB to 30GB
Key Board : 104 keys
Software Specification:
Language : J2SDK1.4
Database : Oracle8i
Operating System : WindowsNT/2000