InfowareServices

This project will be designed and developed for university of Pittsburgh 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 InfowareServices 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 “Info ware Services” 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 Info ware 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.

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 between   6-7 times in a day

   Category C:  If the question frequency is between  3-5 times in a day

   Category D:  If the question frequency is 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.

DATA DICTIONARY

            The logical characteristics of current systems data stores, including name, description, aliases, contents, and organization.  Identifies processes where the data are used and where immediate access to information needed.  Serves as the basis for identifying database requirements during system design.

Uses of Data Dictionary:

1.      To manage the detail in large systems

2.      To communicate a common meaning for all system elements

3.      To Document the features of the system

4.      To facilitate analysis of the details in order to evaluate characteristics and determine where system changes should be made.

5.      To locate errors and omissions in the systems

HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS                               

PROCESSOR    :        Intel 2.0 GHz or above

HARD DISK     :        80 GB

RAM                  :    512 MB RAM.

   SOFTWARE REQUIREMENTS

OPERATING SYSTEM            : WINDOWS XP with SP2. 

LANGUAGE (FRONT END)   : JAVA (JDK1.5/1.6)

SERVER                                     : APACHE TOMCAT 5.5/6.0

WEB TECHNOLOGY              : HTML, JAVASCRIPT, CSS.

DATABASE (BACK END)        : ORACLE 10G.

ARCHITECTURE                      : 3-TIER ARCHITECTURE.