GENERAL : Office correspondence and auto questionnaire software’s are developed as per the requirements of the mechanical department.
Mechanical department deals with different type of letters. The letters which are received by the mechanical department are incoming letters and the letters which are sending through the department are the outgoing letters.
The different types of letters received and send by the mechanical department are as follows:
- Local letters
- Head quarters letters
The letters received from and send to other departments of Vijayawada division are termed as local letters.
INCOMING LOCAL LETTERS
The letters received from other departments of Vijayawada division are termed as incoming local letters.
OUTGOING LOCAL LETTERS
The letters send to other departments of Vijayawada division are termed as outgoing local letters.
HEAD QUARTER LETTERS
Secundrabad division is head quarters of the Vijayawada division. So the letters received from and send to secundrebad division are termed as head quarters letters.
INCOMING HEAD QUARTER LETTERS
The letters received from secundrebad division are termed as incoming head quarter Letter.
OUTGOING HEAD QUARTER LETTERS
The letters send to secundrebad division are termed as outgoing head quarters Letters.
The letters received from and send to the divisions other than Vijayawada and secundrebad are termed as other letters.
INCOMING OTHER LETTERS
The letters received from the divisions other than Vijayawada and secunderabad are termed as incoming other letters.
OUTGOING OTHER LETTERS
The letters send to the divisions other than Vijayawada and secundrebad are termed as outgoing other letters.
If the reply for the above letters is to be given immediately then those letters are marked as demi official letters.
So different types of demi official letters can be
- Incoming Local demi official letter
- Outgoing Local demi official letter
- Incoming Head quarters demi official letters
- Outgoing Head quarters demi official letters
- Incoming Other demi official letters
- Outgoing Other demi official letters
All the incoming letters are received by the chief office superintendent and are marked to different sections of the mechanical department with the authorized signature of the senior divisional mechanical engineer. Then the respective task is performed by section accordingly to the letter which is received by it and sends the reply to chief office superintendent. Then the chief office superintendent with authorized signature of the senior divisional mechanical engineer sends the letter as outgoing letter.
Mechanical department consists of seven sections.
- Carriage & wagon staff
- Rolling stock
The test to avail the promotion is conducted for the employees of the vijayawda division. The question bank offered to the employees for preparation comprises of the following type of questions.
- Long answers
- Short answers
- Fill in the blanks
- Multiple choices
STATEMENT OF THE PROBLEM
To maintain the details of different types of letters, to show the status of the letter and also to generate the reports.
To maintain the questions and to generate the questions randomly when appropriate type of question is selected.
In the existing system the details of the letter is being maintained manually by entering different types of letters in different books. To know the present status of the letter, it is very difficult in the existing system because one has to verify all the entries in that particular book. So it is time consuming.
In the existing system question paper is set manually by selecting the type of questions from the printed question bank. It is very difficult and time consuming to set question paper manually because when selecting a question one has to verify whether it was previously given or not. One has to tally the maximum marks for which paper was given and marks allotted for each question and he should also consider the choices for each type of question.
The proposed System is a web-based application. It maintains details of all the letters within the mechanical department. The present system shows the pending letters and reports.
In the proposed system the question paper is set automatically by selecting random questions when appropriate number of question type is selected.
OBJECTIVES OF STUDY
- Automating the manual work.
- To generate status of the letter
- reminder provision for pending letters
- To generate the question paper quickly from the available database.
- The user can add the details of all the letters into the database and view the pending letters.
- The authorized user can edit the details of the letters and delete the letters from the database.
- The authorized person can add, delete and update the questions in the database.
SYSTEM DESIGN SPECIFICATION
Operating system : Windows XP professional
Programming Language : JAVA
Web Technology : J2EE (JDBC, Servlets, JSP, HTML)
Browser : Internet Explorer
Web application server : Apache Tomcat
Model Design : Rational rose
IDE : Net Beans 6.7.1
Data Base : Oracle 10g, MS Access.
Processor : Intel p4
RAM : 256MB RAM
Hard disk : 20GB or more
- Oracle 9i
- Netbeans 6.7.1
- Mozilla Firefox
Instructions to Deploy:
1. Install the required software’s
2. Open Netbeans and open the project from source code
3. Configure database connections from DBConn package of Source Packages under the root PPO & Technical
4. Right click on CreateTab.java under Test Packages under the root PPO & Technical and click on run
5. Right click on root and click on run
Note: In case of reference problems right click on root and click on resolve reference problems, and select the library files.