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