Orignal Tour And Travel Agency Management Project.docx

Tour And Travel Management

Final Project GCUF LoCATION FINDER

Project Supervisor Sir Shahbaz Nazeer

Submitted By

Saeed Anwer

14629

Muhammad Bilal Akhtar

14644

Muhammad Awais Salam

14615

1

Tour And Travel Management

EXORDIUM

In the name of Allah, the Compassionate, the Merciful. Praise be to Allah, Lord of Creation, The Compassionate, the Merciful, and King of Judgment-day! You alone we worship, and to you alone we pray for help, Guide us to the straight path The path of those who you have favored, Not of those who have incurred your wrath, Nor of those who have gone astray. DEDICATION

We dedicate our first project to our beloved parents and supported friends.

2

Tour And Travel Management

Index Chapter No:1 Introduction 1. Manually Working 2. project Scope 3, Project Advantage 4. Hardware And Software Requirements

Chapter No:2 Structure 1. Table Structure 2. Forms 3. Reports 4. UML

Chapter No:3 Project Implementation 1. Testing And Its Type 2. Client Side Run

Chapter No:4 Project Overview 1. Final Run Project Overview

3

Tour And Travel Management

Chapter No: 1 Introduction: T ’n’ T Travel is an irresistible word when it comes to tour and travel packages. We offer tour and travel services including ticket bookings, hotel reservations , rental car services, holiday tour packages, domestic tour packages. We provide the most suitably designed as well as the customized travel packages to the customers. We offer everything related to travelling services under one roof. Today's extremely exhausting work environment dictates that individuals requires some joyful holiday. We provide stress-free joyful refreshing holidays with cost competitive and customized packages according to their requirements. We provide services in almost each and every city of India. We want to serve our customers with best possible service and provide them the kind of comfort they want. We also want to customize our tours as per our customers requirement without reducing joy or quality of tour. People of all ages and backgrounds will come to enjoy the unique, upscale, joyful, and refreshing environment that T ’n’ T Travel provides. We provide the transportation through its Airways, Railways and busses. According to the tour packages we provide the facilities to customers such as hotels, guesthouses, rental cars. It may vary from customer to customer and packages according to need. We offer new products and concepts from time to time. Keeping the effect of change of seasons on the human mind and body, we revise our itineraries regularly. This is because the comfort and the satisfaction of our customers are paramount to us. T ’n’ T Travel offer a large range of travel opportunities. Whether you're looking for a weekend getaway to relax and indulge, a special holiday with friends and family, a trip to your favorite chill out spot or a new adventure, you've come to the right place. T ’n’ T Travel offers great deals and discounts on flights, railways, hotels, holiday packages, car rental and travel activities everything you need to plan, shop and book your trip. Don't miss out . T ’n’ T Travel best value deals on top destinations.

4

Tour And Travel Management

Scope of the Project: The Website is developed based on real life. It is very helpful in business applications. Today's extremely exhausting work environment dictates that individuals requires some joyful holiday. The website will provides a stress-free joyful refreshing holidays with cost competitive and customized packages according to their requirements. As it is web based it can provide services in almost each and every city of India. It offer tour and travel services including ticket bookings, hotel reservations , rental car services, holiday tour packages, domestic tour packages only in one click. It provide the most suitably designed as well as the customized travel packages to the customers. A traveler can find everything related to travelling services under one roof by this website. The site will help to estimate the benefits and calculate the requirement very easily. The benefits will be in terms of speedy query .Smooth and faster operations at all levels improve the working atmosphere of the entire organization. Maintaining the database as required. Database can be modified accordly. Future Scope Of The Project: There is a wide scope for future implementation of ‘Travel and tourism’ towards an interesting experience of modern technologies. T ‘n’ T Travels is an ‘ One Stop Shops’ for all kinds of tour and travel products to serve the domestic and international tourists at any time, any moment and any where in any parts of the India.Not being sticky to make packages within India only , it can be global-a “Global tourism” through a comprehensive infrastructure.Now a days, traveling between two places is not a point of discussions,as modern technogies have made travel pleasure comprising speed With comfort.so people are not willing to be bound within only a small geographiocal area.So there is place to make them experience the taste Of ‘Global Tourism’.

5

Tour And Travel Management

6

Tour And Travel Management Manually Working: Create Tables Queries: create table TourManager ( managerId

number(10)

managername

varchar2(20),

mobileno

number(10),

address

varchar2(20),

dateofbirth

number(10),

emailid

varchar2(20),

not null,

primary key(managerid));

create table PackageTour ( packageid

number(10)

not null,

managerId

number(10)

not null,

packagename

varchar2(20),

category

varchar2(15),

curdate

DATE,

validtill

number(10),

primary key(packageid), constraint fk_managerid_t foreign key(managerid) REFERENCES TourManager(managerid));

7

Tour And Travel Management Create table PackageTourBooking ( PackageBookingId

number(10)

not null,

packageid

number(10)

not null,

Package Name

varchar2(10),

Category

varchar2(10),

Date

number(10),

Primary key (packagebookingid), constraint fk_packageid_p foreign key(packageid) REFERENCES PackageTour(packageid));

Create table Travelers ( User no

number(10)

not null,

packageid

number(10)

not null,

T Name

varchar2(20),

Address

varchar2(20),

Mobile Number

number(15),

Email Id

varcha2(30),

User Type

varchar2(10),

Date Of Birth

number(10),

Sex

varchar2(20),

Primary key(userno), constraint fk_packageid_p foreign key(packageid) REFERENCES PackageTour(packageid));

8

Tour And Travel Management Create table Bus Booking Details ( busticketnumber

number(10)

not null,

userno

number(10)

not null,

Passenger Name

varchar2(20),

Busid

number(5),

Primary key(busticketnumber), Foreign key(userno) references Travelers (userno));

Create table Bus Cancelation Details ( buscancelationcode

number(10)

not null,

user no

number(10)

not null,

busticketnumber

number(10)

not null,

Payment Mode

number(10),

busnumber

number(10),

ticketnumber

number(10),

refundamount

number(10),

primary key (buscancelationcode), Foreign key(userno) references Travelers (userno); Foreign key(busticketnumber) references Bus Booking Details (busticketnumber));

9

Tour And Travel Management

Create table FlightBookingDetails ( FlightBookingCode

number(10)

not null,

FlightTransactionCode

number(10)

not null,

userno

number(10)

not null,

FlightNumber

number(10),

TicketNumber

number(10),

AirLines

varchar2(10),

Class

varchar2(20),

Primary key (FlightBookingCode,FlightTransactionCode) , Foreign key(userno) references Travelers (userno));

10

Tour And Travel Management

Create table Flight_Cancelation_Details ( FlightCancelationCode

number(10)

not null,

userno

number(10)

not null,

FlightBookingCode

number(10)

not null,

TicketNumber

number(10) ,

AirLines

varchar2(20),

PaymentMode

varchar2(20),

RefundAmount

number(10) ,

Status

varchar2(10),

Primary key(FlightCancelationCode), constraint fk_userno_t foreign key(userno) REFERENCES Travelers(userno), constraint fk_FlightBookingCode_f foreign key(FlightBookingCode) REFERENCES FBD(FlightBookingCode)); Commit;

11

Tour And Travel Management Create table TrainBookingDetails ( Train Booking Code

number(10)

not null,

Train Id

number(10)

not null,

user no

number(10)

not null,

Passenger Name

varchar2(20) ,

Class

varchar2(10),

Destination

varchar2(20),

Primary key (Train Booking Code,Trainid), Foreign key(userno) references Travelers (userno)); Create table TrainCancelationDetails ( TrainCancelationCode

number(10)

not null,

TrainBookingCode

number(10)

not null,

userno TrainNumber

number(10) number(10),

not null,

TicketNumber

number(10),

Destination

varchar2(20),

PaymentMode

varchar2(20),

RefundAmount

number(10),

Status

varchar(20),

Primary key (TrainCancelationCode ), Foreign key(TrainBookingCode)references TrainBookingDetails (TrainBookingCode), Foreign key(userno) references Travelers (userno));

12

Tour And Travel Management Create table HotelBookingDetails ( Hotel Transaction Code

number(10)

not null,

Hotel Booking Code

number(10)

not null,

user no

number(10)

not null,

Hotel Id

number(10),

Hotel Name

varchar2(20),

Check In Date

number(10),

Rate

number(10),

Primary key(Hotel Transaction Code), Primary key(Hotel Booking Code), Foreign key(userno) references Travelers (userno)); Create table Hotel Cancelation Details ( Hotel Cancelation Code

number(10)

not null,

Hotel Booking Code

number(10)

not null,

user no

number(10)

not null,

Hotel Id

number(10),

Address

varchar2(10),

Payment Mode

varchar2(20),

Refund Amount

number(10),

Primary key (Hotel Cancelation Code), Foreign key (Hotel Transaction Code) References (Hotel Transaction Code), Foreign key(userno) references Travelers (userno));

13

Tour And Travel Management

Data Insert Into Tables Quries 1. insert into TOUR_MANAGER VALUES (2,'Nouman',0334324564,'Multan',03-01-2016,'[email protected]'); Commit;

2. insert into PACKAGE_TOUR VALUES (12,'Family','Economy','12-jan-96',121,1); Commit;

3. insert into PACKAGE_TOUR_BOOKING VALUES (123,'Family','Business','12-jan-2016',12); Commit;

4. insert into TRAVELERS VALUES(121,'Salman','Multan',03326342165,'[email protected]','Economy', 01-02-1968,'Male',12); Commit;

5. insert into TRAIN_BOOKING_DETAILS VALUES(123,200,121,'Waseem','Business','Multan'); Commit;

14

Tour And Travel Management 6. insert into TRAIN_CANCELATION_DETAILS Values(123,121,32,23,'FSD','Cash',2000,930); commit;

7. insert into HBD VALUES(200,300,121,2575,'MoonHotel',12-03-1997,50); Commit; 8. insert into HCD VALUES(12,300,121,2575,'Jhag','Cash',2000); Commit;

9. insert into FBD VALUES(55,44,121,88,567,'Dubai','Economy'); Commit;

10. insert into FCD values(121,55,88,32,'Dubai','Cash',2000,'Evening'); Commit;

11. insert into BBD VALUES (256, 121,'Naeem', 15); Commit;

15

Tour And Travel Management 12. Insert into BCD Values (12, 121,256,'Cash',323,145); commit;

16

Tour And Travel Management

DESIGN SPECIFICATIONS & REQUIREMENT Software & Hardware Specification: Specification must reflect the actual application to be handled by the system and include system objective, flowchart, input-output requirement, file structure and cost.

1) Reliability: Software reliability brings up the concept of modularity. A package with a high degree of modularity has the capacity to operate in many machine configurations and perhaps across manufacture product lines. This software with high potential can work or can be operated in P1 based configuration computers. 2) Functionality: It is a definition of the facilities, performance and other factors that the user requires in the finished product. This software provides the facility of having the complete infrastructure of the house, etc. The performance of the software includes the flexibility of the software. 3) Flexibility: One feature of the flexibility is adaptability, which is of the ease of extending the product. In the field of flexibility, the software covers all factors to be considered. For example: knowing the astrological sign, KUA number, and etc. of a particular person.

17

Tour And Travel Management 4) Usability: The points to be considered while thinking of usability are portability and understandability.While designing this software, we always try to make it more portable, should not consume more space as well. As we are using HTML s a front-end, which is very user friendly, so it scores full marks in understanding. 5) Security: Security control and access of software or data file should be maintained in this software. 6) Capacity: The software, when under development should be developed in such a way that the number of files, data elements, etc. and size of each of them should be considered. It should not affect the users system, so that he/she can make up gradations or degradations in the system hardware or software. 7) Performance: The language, in which the package is developed, should be well known or say should be aware to the programmers. The operating system may also affect its performance. These both factors are important for consideration. This software should be economical for buying and should be user friendly. In our project, we have considered all above factors and developed such a project hat can run in all environments but may be supported by Apache server.

18

Tour And Travel Management HARDWARE SPECIFICATIONS: Processor :

Intel Pentium or more

Ram :

128 MB or more

Cache :

512 KB

Hard disk :

16 GB hard disk recommended

SOFTWARE REQUIREMENTS: Operating system :

Windows 2000 or later

Front End :

Asp.Net

Back End :

SQL Server 2000 .

Language:

C#

19

Tour And Travel Management

Chapter No: 2 Class Diagram: Train Booking Details

Flight Booking Details

Flight Cancelation Details

Train Booking Code Passenger Name User no Class Destination

Flight Booking Code Flight Transaction Code Flight Number Ticket Number Air Lines User no Class Status

Flight Booking Code Flight Cancelation Code Flight Number Ticket Number Air Lines User no Payment Mode Refund Amount Status

Train Cancelation Details Train Booking Code Train Cancelation Code Train Number Ticket Number Destination User no Payment Mode Refund Amount Status

Tour Manager Travelers Package Tour

User no Package Id T Name Address Mobile Number Email Id User Type Date Of Birth

Package Id Package Name Category Curate Valid Till Manager Id

Manager Id Manager Name Mobile No Address DOB Email Id

Hotel Booking Details Hotel Booking Code User no Hotel Name Check In Date Rate

Bus Booking Details Package Tour Booking Bus Ticket Number User no Passenger Name Bus Id

Hotel Cancelation Details

Bus Cancelation Details

Hotel Booking Code Hotel Cancelation Code Address User no Payment Mode Refund Amount

Bus Ticket Number Bus Cancelation Code Bus Number Ticket Number User no Payment Mode Refund Amount

20

Package Booking Id Package Name Category Date Package Id

Tour And Travel Management

Stracture Of Tables: Tour Manger

Package Tour

21

Tour And Travel Management Package Tour Booking

Travelers

22

Tour And Travel Management

Train Booking Details

Train Cancelation Details

23

Tour And Travel Management

Bus Booking Details

Bus Cancelation Details

24

Tour And Travel Management

Flight Booking Details

Flight Cancelation Details

25

Tour And Travel Management

Hotel Booking Details

Hotel Cancelation Details

26

Tour And Travel Management

RelationShip Diagram:

Forms: 27

Tour And Travel Management

Log In

28

Tour And Travel Management

Menu

29

Tour And Travel Management

Tour Manger

30

Tour And Travel Management

Package Tour

31

Tour And Travel Management

Package Tour Booking

32

Tour And Travel Management

Travelers

33

Tour And Travel Management

Flight Booking Details

34

Tour And Travel Management

Flight Cancelation Details

35

Tour And Travel Management

Train Booking Details

36

Tour And Travel Management

Train Cancelation Details

37

Tour And Travel Management

Bus Booking Details

38

Tour And Travel Management

Bus Cancelation Details

39

Tour And Travel Management

Hotel Booking Details

40

Tour And Travel Management

Hotel Cancelation Details

41

Tour And Travel Management Software Maintenance: Maintenance comes under the support phase. Maintenance accounts for more effort than any other software engineering activity. It focuses on change associated with error correction, adaptations required as the software's environment evolves, and changes due to enhancements brought about by changing customer requirements. Four types of changes are encountered during the support phase: •Corrective Maintenance: Even with the best quality assurance activities, it is likely that the customer will uncover defects in the software. Corrective maintenance changes the software to correct defects. •Adaptive Maintenance: Over time, the original environment (e.g., CPU, OS, rules, external product characteristic) for which the software was developed is likely to change. Adaptive maintenance results in modification to the software to accommodate changes to its external environment. •Perfective Maintenance As the software is used, the customer will recognize additional functions that will provide benefit. Perfective maintenance extends the software beyond its original functional requirements. •Preventive Maintenance: Computer software deteriorates due to change, and because of this, preventive maintenance, often called software reengineering, must be conducted to enable the software to serve the needs of its end users.

Chapter No: 3

Software Testing Techniques Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design, and code generation. The increasing visibility of software as a system element and the attendant costs

42

Tour And Travel Management associated with a software failure are motivating forces for well planned, through testing. The main objectives of testing are listed below: 

Testing is a process of executing a program with the intent of finding an error.



A good test case is one that has a high probability of finding an as-yetundiscovered error.



A successful test is one that uncovers an as-yet-undiscovered error. Software is tested from two different perspectives: (1) internal program logic is exercised using "white-box" test case design techniques. (2) Software requirements are exercised using "black-box" test case design techniques. In both cases, the intent is to find the maximum number of errors with the minimum amount of effort and time.

Following are the two types of techniques, which have been used to test this project:



White-box testing



Black-box testing

Software Testing Strategies

Unit Testing 43

Tour And Travel Management It focuses on the smallest unit of software design - the software component or module. Using the component level design description as a guide, important control paths are tested to uncover errors within the boundary of the module. The relative complexity of tests and uncovered errors is limited by the constrained scope established for unit testing. The unit test is white-box oriented, and the step can be conducted in parallel for multiple components. The tests that occur as part of unit tests are listed below: 

Module Interface is tested to ensure that information properly flows into and out of the program unit under test. Tests of data flow across a module interface are required before any other test is initiated. If data does not enter and exit properly, all other tests are moot.



Local Data Structures are examined to ensure that data stored temporarily maintains its integrity during all steps in an algorithm's execution.



Boundary Conditions are tested to ensure that the module operates properly at boundaries established to limit or restrict processing.



Independent Paths are exercised to ensure that all statements in a module have been executed at least once.



Error Handling Paths are also tested.

Selective testing of execution paths is an essential task during the unit test. Basis path and loop testing are effective techniques for uncovering a broad array of path errors.Among the more common errors in computation are

44

Tour And Travel Management 

misunderstood or incorrect arithmetic precedence,



mixed mode operations



incorrect initialization



precision inaccuracy



incorrect symbolic representation of an expression.

Comparison and control flow are closely coupled to one another (i.e., change of flow frequently occurs after a comparison). Test cases should uncover errors such as 

comparison of different data types



incorrect logical operators or precedence



expectation of equality when precision error makes equality unlikely



incorrect comparison of variables



improper or nonexistent loop termination



failure to exit when divergent iteration is encountered



improperly modified loop variables

Among the potential errors that should be tested when error handling is evaluated 

Error description is unintelligible



Error noted does not correspond to error encountered



Error condition causes system intervention prior to error handling



Exception-condition processing is incorrect

45

Tour And Travel Management 

Error description does not provide enough information to assist in the location of the cause of the error.

Boundary testing is the last (and probably most important) task of the unit test step. Software often fails at its boundaries. That is, errors often occur when the nth element of an n-dimensional array is processed, when the ith repetition of a loop with i passes is invoked, when the maximum or minimum allowable value is encountered.

Why is System Analysis Necessary: During system analysis some activities are carried out, such as problem definition, design, implementation. Before designing the actual system/project, we should know, 1. What is the problem? 2. How to solve it? 3. What are the technical factors required? 4. What are its features and limitations? If a system is designed without considering above activities then the system will not work properly to the satisfaction of user requirement.A system Canot be designed Without Any Analysis.We should have a clear idea about what is to be made and how?If the System is properly analysed then the system will be effective and proper. Analysis is the preleminary factor while designing a software. So system analysis is necessary to design perfect and accurate system, which satisfies the user requirement.

46

Tour And Travel Management

system analyst: System analysis is central to the whole of system development. It includes gathering the necessary data and developing plans for new system. This is not an easy task because many people need to be satisfied and many conflicts resolved. The system analyst is the person who guides the analysis, design and implementation and maintenance of a given system. In performing these four tasks, the analyst must always match the information system objectives with the goals of organization. 1. System analyst must determine the requirements of user of a new system so that during analysis they can discuss with users how to design a new system that meets the requirements. 2. System analyst has to provide different solutions to the problem, to satisfy user requirements. 3. The system analyst must be a able to find out the details about the system itself. To do this, the analyst will have to look at such things as forms (input, output formats), data used by the organization. 4. System analyst must also be able to work in environments that have considerable ambiguity and uncertainty. 5. System analyst must also be creative and imaginative in producing new solutions to meet user requirements The multifaceted role of the analyst: The analyst plays his role in many characters. These various roles played by him are: Change agent

47

Tour And Travel Management Monitor Architect Psychologist Sales person Motivator Politician.

Change agent: The analyst is called as change agent because sometimes he changes the entire policy of industry or organization to improve overall working as well as profit of the organization. The change is brought implementing new software based computer system. In order to make this change successful the analyst should give user as much participation as possible while designing the system. Investigator and monitor: The analyst finds out why user is not satisfied with the not present system he is using. What are the drawbacks of pitfall in the present system, that user wants to remove by replacing it with new system. The analyst also monitors the activities going on while designing a new system. The activities to be monitored include successful completion of programs with respect to time, cost and quality. Architect: System analysts are like architects. He must work with user to identify the goals and shapes of new system. Architect first prepares a plan and according to that plan he develops a building. A system analyst also creates several plans and develops or builds system according to that plan.

48

Tour And Travel Management Psychologist: Analyst plans the role of psychologist in the way he/she reaches people interprets their behavior and draws conclusion from their interactions. Sales person: The analyst works as a sales person by giving oral presentation of the system at each stage of development. The analyst should be very good in communication and in putting his ideas before the user. Also he should be able to clarify the issues raised by the user at the time of presentation.

Motivator: The analyst work as a motivator after the system is implemented. It is the responsibility of the analyst to motivate the users to use the new system. it is directly dependent how much user participation is given in the project design and how much efforts are taken to train the user, that the user can be motivated to use the new system. Politician: A politician should be a good diplomat, should have proper good control on his party members and should have good influence on the people. It is true for becoming a successful system analyst. While designing a new system, the analyst should not only think about the technical side but also keeping good relations, good control and good influences on the people with and around him. Identification of need: As the tourism industry’s popularity grows, the image of travel and tourism begins to evolve. With a simple click of the button, your entire nine-day itinary to India could be planned, booked and paid for. When a trip is organized with online tour groups or packages, it produces a view of the country that is for the consumption of the tourist. Tourism has become too much of a service. It is geared towards what the tourist would find familiar or comfortable. It takes away from the true mission of travel. Tour groups and itineraries are structured to offer the most efficiency throughout your travel. But travel in large groups, walking from bus to bus, hotel to hotel provides a very narrow experience of the country.

49

Tour And Travel Management

Travel service providers, operating from distant locations and providing specific services to customers, can only meet a portion of customer requirements. For instance, if a traveler needs to tour Agra, a travel agent may be able to manage the airline reservation for the traveler, but perhaps, not the hotel reservations. Similarly, another tour operator may offer the hotel bookings service but the costs may not be feasible for a traveler. On one hand, travelers need to search for multiple travel agents to plan a single tour and on the other hand, travel agents are confined to their specific areas of operations. After identifying and isolating these problems in the travel industry, T ’n’ T Travels wanted to develop a solution that would act as a ‘single point of contact’ for travelers, while allowing travel agents the opportunity to grow & expand their business, without incurring any extra costs. In addition, the solution would allow customers to search for travel service providers and book tours online. We make ticket bookings, hotel reservations ,car rental services, holiday tour packages, domestic tour packages to make your trip hassle free. Our travel packages designed especially for the needs of the corporate sector, assures that our clients have a stress free business/leisure tour, with the nitty-gritty associated with traveling left to the experts. Client Application Development 

Client applications are the closest to a traditional style of application in Windows-based programming. These are the types of applications that display windows or forms on the desktop, enabling a user to perform a task. Client applications include applications such as word processors and spreadsheets, as well as custom business applications such as data-entry tools, reporting tools, and so on. Client applications usually employ windows, menus, buttons, and other GUI elements, and they likely access local resources such as the file system and peripherals such as printers.



In the past, developers created such applications using C/C++ in conjunction with the Microsoft Foundation Classes (MFC) or with a rapid application development (RAD) environment such as Microsoft® Visual Basic®. The .NET Framework incorporates aspects of these existing products into a single, consistent development environment that drastically simplifies the development of client applications.The Windows Forms classes contained in the .NET Framework are designed to be used for GUI development. You can easily create command windows, buttons, menus, toolbars, and other screen

50

Tour And Travel Management elements with the flexibility necessary to accommodate shifting business needs.

SQL SERVER: A database is a structured collection of data. Data refers to the characteristics of people, things and events. SQL Server stores each data item in its own fields. In SQL Server, the fields relating to a particular person, thing or event are bundled together to form a single complete unit of data, called a record (it can also be referred to as raw or an occurrence). Each record is made up of a number of fields. No two fields in a record can have the same field name.During an SQL Server Database design project, the analysis of your business needs identifies all the fields or attributes of interest. If your business needs change over time, you define any additional fields or change the definition of existing fields. SQL Server makes it very easy to link the data in multiple tables. Not only does SQL Server allow you to link multiple tables, it also maintains consistency between them. Ensuring that the data among related tables is correctly matched is referred to as maintaining referential integrity. FEATURES OF SQL SERVER (RDBMS): 

SQL SERVER is one of the leading database management systems (DBMS) because it is the only Database that meets the uncompromising requirements of today’s most demanding information systems. From complex decision support systems (DSS) to the most rigorous online transaction processing (OLTP) application, even application that require simultaneous DSS and OLTP access to the same critical data, SQL Server leads the industry in both performance and capability

51

Tour And Travel Management 







SQL SERVER is a truly portable, distributed, and open DBMS that delivers unmatched performance, continuous operation and support for every database. SQL SERVER RDBMS is high performance fault tolerant DBMS which is specially designed for online transactions processing and for handling large database application. SQL SERVER with transactions processing option offers two features which contribute to very high level of transaction processing throughput, which areThe row level lock manager Enterprise wide Data Sharing. The unrivaled portability and connectivity of the SQL SERVER DBMS enables all the systems in the organization to be linked into a singular, integrated computing resource.

Chapter No: 4 THE COMPLETE STRUCTURE: T ‘n’ T Travels is an ‘ One Stop Shops’ for all kinds of tour and travel products to serve the domestic and international tourists at any time, any moment and any where in any parts of the India. It is a complete online travel solution portal in the sense that the travelers need not require moving to different travel agents for different services involved in the entire travel process. Sitting at one place, travelers can enquire, navigate and ask for everything related to travel services. The major list of online travel services include online flight booking, online hotel booking, online cruise booking , online car/bus booking.The entire system is user-friendly that guides the travelers automatically while making their reservation. Overall Description: T ’n’ T Travels arranges holidays for customers. It offer tour and travel services including ticket bookings, hotel reservations, rental car services, holiday tour packages, domestic tour packages. Bookings are made online directly by customers. The customer has to register himself/herself as our registered customer. Now he/she can select package tours provided by us or can customize his/hers own

52

Tour And Travel Management tour. When a customer select his tour venue, then he/she may selects other accommodations from flight details,railway details, cruise details, bus details and hotel details according to their will. The registered customer can also reserve tickets only or book hotel only through our site. They can also choose rental car services and guide facility also according to their requirements. We provide full freedom to our customer to make their choice from the vast information provided by us according to their comfort and finances. The details are entered onto a Provisional Booking file. The customer must confirm this booking within three days by sending a deposit of 10% of the costs. On receipt of the deposit, Reservations transfer the details from the Provisional Bookings file to the Confirm Bookings file. Four weeks before the Tour is due, we send an invoice to the customer for the remaining costs. The Customer is notified when the full payment is received via Email or Sms , and Customer Services then send tickets and other instructions and informations to the customer via email. The tickets are then send to the customers by mail. Customer can also cancel their reservation online. The register customer log into our site and can confirm their reservation. The cancelation is confirmed by the administrator and then refund amount is send to the customer within 5 days deducting the cancelation charges.

53

Tour And Travel Management Functional Description: T ‘n’ T Travels impeccable services and well researched & planned out tour itineraries have drawn us a veritable list of clients from the world over. We believe in a simple philosophy that reads as "Give the customer what they ask for---an excellent travel entertainment with complete peace of mind and satisfaction". In the short span of time we have generated huge number of clients who enjoys our flawless services and facilities. The different Modules involved in online Tour And Travel management system are as follows. Customer Registration Tour Packages And Holiday Online Ticket Reservation Online Flight Reservation Online Railway Reservation Online Bus Ticket Reservation Online Hotel Reservation Rental Car Services Cancelation Online Flight Cancelation Online Railway Cancelation Online Bus Ticket Cancelation Online Cruise Line Cancelation Online Hotel Cancelation Tour Cancelation

54