Travel Desk Management System Abstract z3ad

Travel Desk Management System

ABSTRACT The Travel Desk is required to maintain considerable information of the employees, their ports, and visa related information, travel information etc. Presently these are maintained in Microsoft Excel form, in standalone mode. When a new employee s into the company his information is stored in the database by the travel desk. When a request is generated by the Senior Managers for an employee’s visit to a foreign country then his information is processed for port and visa details and relevant data and application are ed on to him and are processed by the Travel Desk. Existing System The existing system of the company uses Microsoft Excel form to store data. It is in a standalone mode. To store each type of details different form is used. The same data is stored in different forms. To check the status of any employee we have to go through out the excel sheet and cross check each and every individual record. If an employee’s port or visa is going to expire we cannot have information pertaining to it in advance, unless and until all the records in those particular sheets are checked.

CreativeSoft (Corporate Office) # 412, Annpurna Block,Aditya Enclave,Ameerpet,Hyderabad – 500016 Tel : +91-40-40159158Mobile : 91-9247249455

Page 1

Travel Desk Management System Proposed System: The proposed system for the company will store the data in a central location, the database (oracle) employee of the company by using a provided to him. Some senior managers and the travel desk employees will have the access to update the records. Report generating facility will be available which will help to know the information in advance like expiries of port or visas.

Scope Of The System: The scope of the project is within the network. The project is developed using client server architecture. The s of the project are travel desk employees of the organization. Module Description: The modules are 1. Employee details: Allows the travel desk to store, retrieve, update and delete the details of the employee. 2. port details: Allows the travel desk to store, retrieve, update and delete the details of the employee’s port. 3. Visa details: Allows the desk to store, retrieve, update and delete the details of the employee’s visa. CreativeSoft (Corporate Office) # 412, Annpurna Block,Aditya Enclave,Ameerpet,Hyderabad – 500016 Tel : +91-40-40159158Mobile : 91-9247249455

Page 2

Travel Desk Management System 4. Travel details: Allows the travel desk to store, retrieve, update and delete the details of the employee’s travel details. 5. Travel agent details: Allows the travel desk to store, retrieve, update and delete the details of the travel agent details. Features To Be Implemented: 

Normalized database



Client-server architecture



Exception handling

Software Requirement Specification: Software Requirements: 

Programming Language: Java



Database Connectivity API: JDBC



Backend Database: Oracle/SQL Server/MY SQL/MS Access



Operating System: Windows XP/2000/2003, LINUX, Solaris



IDEs: Eclipse with My Eclipse plugins/Net Beans/RAD

Hardware Requirements: Processor

:

Intel P-III based system

Processor Speed

:

250 MHz to 833MHz

CreativeSoft (Corporate Office) # 412, Annpurna Block,Aditya Enclave,Ameerpet,Hyderabad – 500016 Tel : +91-40-40159158Mobile : 91-9247249455

Page 3

Travel Desk Management System RAM

:

512 MB

Hard Disk

:

2GB to 30GB

CreativeSoft (Corporate Office) # 412, Annpurna Block,Aditya Enclave,Ameerpet,Hyderabad – 500016 Tel : +91-40-40159158Mobile : 91-9247249455

Page 4