Travel And Tourism Management System 2v4u13

Travel and Tourism Management System Submitted of particle fulfillment to the requirements For the award of the degree of Bachelor of computer Application

Guide: Submitted by: o ANJALI KUMARI o BHAWNA KUMARI  NIDHI PRAKASH

o PRIYANKA KUMARI

Submitted to

B.N MANDAL UNIVERSITY, MADHEPURA D.S COLLEGE, KATIHAR

TABLE OF CONTENTS ACKNOWLEDGEMENT SELF CERTIFICATE SYNOPSIS MAIN REOPRT o INTRODUCTION  Basic introduction of Project  Objective and Scope  Project Section  Tools and Technologies used o SYSTEM ANALYSIS  Preliminary analysis & Information gathering  Input/outputs  Feasibility Study  System Requirements Specification  Software Engineering Model Used o SYSTEM DESIGN  Project Planning  Modules  Data Flow Diagram  E-R Diagram  Data Base Design o SCREEN SHOT o CODE o CONCLUSION  ANNEXURE o Company Profile o References    

3 4 5-8 9-112 9-13

13-16

17-22

23-31 32-110 111 112

ACKNOWLEDGEMENT I would like to express my sincere gratitude and regards to my external guide Mr.. .…. ………………….for his/her constant inspiration, supervision and invaluable guidance during the training. I would also like to thank Ms.…. ………………….of (name of organization) for giving me such an opportunity to continue my training in the (name of organization) and providing the facility. At last I would also like to extend my sincere gratitude to all my faculty and specially Mr.……………………………………… (Internal Guide) for giving their valuable suggestions.

With regards

Signature of Student

(Sign of HOD)

(Sign of Internal Guide)

SELF CERTIFICATE This is to certify that the dissertation / project report entitled “Travel and Tourism Management System” has been done by me, which is an authentic work carried out for the partial fulfillment of the requirements for the award of the degree of bachelor of computer Application under the guidance of ________________ the mater embodied in this project work has not been submitted earlier for award of any degree or diploma to the best of my knowledge and belief.

Signature of the student Name of the student Roll no. Collage Name

SYNOPSIS Introduction The Travel and Tourism Management System is a web based application and maintains a centralized repository of all related information. The objective of this project is to develop a system that automates the processes and activities of a travel agency. The purpose is to design a system using which one can perform all operations related to traveling and sight-seeing. In the present system a customer has to approach various agencies to find details of places and to book tickets. This often requires a lot of time and effort. A customer may not get the desired information from these offices and often the customer may be misguided. It is tedious for a customer to plan a particular journey and have it executed properly. PROJECT OBJECTIVE 1. To develop a web based application which includes 2. To provide best travelling services to the customers and travel agents. 3. To provide a search platform where a tourist can find their tour places according to their choices. 4. To promote responsible and interesting tourism so that people can enjoy their holidays at their favorable places.

5. To develop tourism with different cultures so that they enrich the tourism experience and build pride. 6. To create and promote forms of tourism that provide healthy interaction opportunities for tourists and locals and increase better understanding of different cultures, customs, lifestyles, traditional knowledge and believes. 7. To provide a better way to connect with various events. Scope of Project The main purpose of “Travel at Glance” is to provide an alternate and convenient way for a customer to book hotels, flight, train and bus for tour purposes. In this project, we aim to choose that particular experience which will shape vision of the country by visiting our website. We will make an easier task of searching places and for booking train, flight or bus. We provide a Judgment and approach skills to critically examine how a tourist visits and its ability to operate in an appropriate way when dealing with the consequences of tourism, locally, regionally, and nationally including visitor security and ecological influences. Section of project:Modules of the software: MODULES: The system is proposed to have the following modules: 1. 2. 3. 4. 5. 6.

module Travels module routes module reservations module Testimonials module. Tracking Module

MODULE: This module provides related functionality. manages all information and has access rights to add, delete, edit and view the data related to places, travels, routes, bookings, etc. TRAVELS MODULE: This module provides the details of various travel agencies. A can select the appropriate agency depending on convenience and accessibility.

ROUTES MODULE: This module provides information related to various routes connecting sources and destinations. For each route, information such as source, destination, fare, reservation details, pick up points etc are provides. Only can add, delete, edit and manage the data. s can only view the information. RESERVATIONS MODULE: This module provides functionalities that allow a to book tickets or cancel previously booked tickets. The module maintains the details of all reservations made so far and allows to either confirm or reject the bookings.

TESTIMONIALS MODULE: s of this application can post their opinions, complaints and suggestions regarding this portal and services to the . Accordingly, the can take various steps to act on the complaints and suggestions. Tracking Module The Tracking Module will track the customer by dates, hotels, vehicles etc. MIS Reports where generated to keep track of the revenue, agent’s performance, etc., Voucher where generated for the customer for all the accommodation and transport facilities asked by the customer. First Level DFD:-

Software Requirement 

Visual Studio 2012 or 2010



Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silver light. It can produce both native code and managed code.



SQL Server 2008 Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent s. Its primary query languages are T-SQL and ANSI SQL.



.Net framework 3.5 .NET Framework (pronounced dot net) is a software framework developed by Microsoft that runs primarily on Microsoft Windows. It includes a large class library known as Framework Class Library (FCL) and provides language interoperability (each language can use code written in other languages) across several programming languages. Programs written for .NET Framework execute in a software environment (as contrasted to hardware environment), known as Common Language Runtime (CLR), an application virtual machine that provides services such as security, memory management, and exception handling. FCL and CLR together constitute .NET Framework.

HARDWARE REQUIREMENTS:  Processor: Intel dual core or above  Processor Speed:1.0GHZ or above  RAM: 1 GB RAM or above  Hard Disk: 20 GB hard disk or above CONCLUSION: 1. Security:-The security of subsystem s the dividing s into several groups. Each group has its own set of rights for viewing or changing data. 2. The highest reliability: - Data management system is based on transactions. Transactional system never allows your data to be lost or corrupted because of accidents Double Asking before changing: - will be asked twice before the program deletes any your data. 3. Simplicity:-The intuitive interface allows you start to work with the program easily.

MAIN REPORT Project Name: Travel and Tourism Management System Introduction: The Travel and Tourism Management System is a web based application and maintains a centralized repository of all related information. The objective of this project is to develop a system that automates the processes and activities of a travel agency. The purpose is to design a system using which one can perform all operations related to traveling and sight-seeing. In the present system a customer has to approach various agencies to find details of places and to book tickets. This often requires a lot of time and effort. A customer may not get the desired information from these offices and often the customer may be misguided. It is tedious for a customer to plan a particular journey and have it executed properly. PROJECT OBJECTIVE 8. To develop a web based application which includes 9. To provide best travelling services to the customers and travel agents. 10. To provide a search platform where a tourist can find their tour places according to their choices. 11. To promote responsible and interesting tourism so that people can enjoy their holidays at their favorable places. 12. To develop tourism with different cultures so that they enrich the tourism experience and build pride. 13. To create and promote forms of tourism that provide healthy interaction opportunities for tourists and locals and increase better understanding of different cultures, customs, lifestyles, traditional knowledge and believes. 14. To provide a better way to connect with various events.

Scope of Project

The main purpose of “Travel at Glance” is to provide an alternate and convenient way for a customer to book hotels, flight, train and bus for tour purposes. In this project, we aim to choose that particular experience which will shape vision of the country by visiting our website. We will make an easier task of searching places and for booking train, flight or bus. We provide a Judgment and approach skills to critically examine how a tourist visits and its ability to operate in an appropriate way when dealing with the consequences of tourism, locally, regionally, and nationally including visitor security and ecological influences.

Modules of the software: MODULES: The system is proposed to have the following modules: 

module



Travels module



Manager module



Mechanic module



Reservations module



Driver module



Customer module



TESTIMONIALS MODULE

Salient Features: 1 Reduce complexity through automation. 2 -friendly environment to operate on. 3 Compatible to all platforms. 4 Improve istration department’s efficiency 6 Exchange of data between different departments. 6 Improve Management reporting, maintaining capabilities. 7 Enhance s satisfaction and productivity

System Analysis

FUNCTIONAL REQUIREMENTS A common database maintained & updated time to time. Data is made consistent through data only being entered at one source. The system environment provides for, tan easy to reporting/enquiry tool for ad-hoc use.             

Customer Registration Tour Packages And Holiday Online Ticket Reservation Online Flight Reservation Tour Package Creation Facility Listing Schedule arrangement Customer registration Package selection Cancellation facility Hotel adding facility Offer details Tour Cancelation .

NON FUNCTIONAL REQUIREMENTS They are the quality requirements that stipulate how well software does what it has to do.  Performance No. of terminals to be ed is dependent on the server that we will use at the time of deployment. The web application server used should provide good performance and ability to manage performance with techniques such as for caching. After completing the exam, the entire score of the student will be calculated as per the rules in less than a second.  Availability Online Examination site has 24*7 availability. It can be accessed for 24 hours a day. For this UPS must be on the server site with a backup of at least 8 hours in case of power failure. Students can take exam only during the previously allotted time slots, however can open site anytime to access other information. Colleges can for the exam anytime.  Reliability It means the extent to which program performs with required precision. The website developed should be extremely reliable and secure so that information about any questions etc. is not leaked before the actual exam is held.

 Usability The website should be friendly and should require least effort to operate.  Portability The website is made using HTML, etc.which are platform independent and can be transported to other servers with minimum effort.  Flexibility It is effort required to modify operational program. The whole website should be made using independent modules so that any changes done in 1 module should not affect the other one and new modules can be added easily to increase functionality.

FEASIBILITY STUDY 



     

The feasibility study is a formal proposal for a new system. Before the project is to begin, the project is studied to determine what exactly the wants depending upon the result of initial investigation. The survey is expanded to more detailed study. Feasibility study can be understood by giving the answer/solution of these their requirements: -What are the ’s demonstrable needs and how does a candidate system meet them? Our new system covers all the basic of the for e.g.: as mentioned earlier that our database is Ms access, which does not have any limitation to store data. And one of the major advantages of new system is that it avoids redundancy means there is no repetition of the data. A feasibility analysis involves a detailed assessment of the need, value and practicality of a proposed enterprise, such as systems development. The process of deg and implementing record-keeping systems has sufficient ability and resource implications for an organization. Feasibility analysis will help you make inform and transparent decision at crucial points during the developmental process to determine whether it is operationally, economically and technically realistic to produce with a particular course of action. TECHNICAL FEASIBILITY This is concerned with specifying equipment and software that will successfully satisfy the requirement. Technical needs of the system include: Facility to produce outputs in a given time Response time under certain conditions Ability to process a certain volume of transaction at a particular period Facility to communicate data to distant location In examining technical feasibility, configuration of the system is given more importance than the actual make of hardware. Configuration should give the complete picture about the system’s requirements: how many workstations are required, how these units are interconnected so that they could operate and communicate smoothly. What speeds of input and output should be achieved at particular quality of printing.

    



       





OPERATIONAL FEASIBILITY This is mainly related to human organization and political aspects. The points to be considered are: What changes will be brought with the system? What organizational structures are disturbed? What new skills will be required? Do the existing staff have these skills? If not, can they be trained in due course of time. This feasibility study is carried out by a small group of people who are familiar with information system techniques, who understand the parts of business that are relevant to the project and are skilled in system analysis and design process. ECONOMIC FEASIBILITY Economic justification is generally the “Bottom Line” consideration for most systems.Economic justification includes a broad range of concerns that includes cost benefit analysis. In this we weight the cost and the benefits associated with the candidate system and if it suits the basic purpose of the organization i.e. profit making, the project is making to the analysis and design phase. The financial and the economic questions during the preliminary investigation are verified to estimate the following: The cost to conduct a full system investigation. The cost of hardware and software for the class of application being considered. The benefits in the form of reduced cost. The proposed system will give the minute information, as a result the performance is improved which in turn may be expected to provide increased profits. This feasibility checks whether the system can be developed with the available funds. The System does not require enormous amount of money to be developed. This can be done economically if planned judicially, so it is economically feasible. The cost of project depends upon the number of man hours required. Cost-Benefit Analysis Since cost plays an important role in deciding the new system, it must be identified and estimated properly. Benefits are also of different types and can be grouped onthe basis of advantages they provide to the management. Cost-saving benefit leads to reduction in istrative and operational costs. Cost-avoidance benefits eliminate future istrative and operational costs improved-service-level benefits are those where the performance of the system is improved by a new computer based method e.g. servicing a student in two minutes rather than five to ten minutes is an example of this type of benefit.Improved-information benefits are where computer based methods lead to better information for decision making. Direct Or Indirect Cost Benefit



 

      



Direct costs are those which are directly associated with a system. They are applied directly to the operator. Direct benefits also can be specifically attributable to a given project. Indirect costs are not directly associated with a specific activity in the system. They are often referred to as overhead expenses. For example cost of space to install a system, maintenance of computer center, heat, light and air-conditioning are all tangible costs but their proportion is difficult to calculate to a specific activity like report. Indirect benefits are realized as by-products of another system. We can define cost-benefit analysis as: That method by which we can find and estimate the value of the gross benefits of a new system specification. That method by which we find and determine the increased operating costs associated with the gross benefits The subtraction of these operating costs from the associated gross benefits to arrive at net benefits. That method by which we find and estimate the monetary value of the development costs that produce the benefits Those methods by which we show the time-relationship between net benefits and development costs as they relate to cash flow, payback on investment, and time-in process taking into operation factors such as inflation etc. Input Specification Interface of the System The Interface of the System will be developed in International standard so that should not to take more time to be familiar with it. Validation and Verification of data should giving Every input field will be under the Data Validation technique and after input of data another procedure will work for Data Verification. Minimize data redundancy Maximum unnecessary data from the main system will be redundant. Because this unnecessary data’s will keep more place and made the system chaos. So, some temp table will use in database for performing some tasks, after completing the task, all record will deleted automatically.

SYSTEM DESIGN 1 INPUT DESIGN The design of input focuses on controlling the amount of input required, controlling the errors, avoiding delay, avoiding extra steps and keeping the process simple. The input is designed in such a way so that it provides security and ease of use with retaining the privacy. Input Design considered the following things:



What data should be given as input?



How the data should be arranged or coded?



The dialog to guide the operating personnel in providing input.



Methods for preparing input validations and steps to follow when error occur.

6.2 OUTPUT DESIGN A quality output is one, which meets the requirements of the end and presents the information clearly. In output design it is determined how the information is to be displaced for immediate need and also the hard copy output. It is the most important and direct source information to the . Efficient and intelligent output design improves the system’s relationship to help decision-making. Deg computer output should proceed in an organized, well thought out manner; the right output must be developed while ensuring that each output element is designed so that people will find the system can use easily and effectively. When analysis design computer output, they should: 

Identify the specific output that is needed to meet the requirements.



Select methods for presenting information.



Create document, report, or other formats that contain information produced by the system.

MODULES AND THEIR DESCRIPTOIN Modules of the system: MODULE:

This module provides related functionality. manages all information and has access rights to add, delete, edit and view the data related to places, travels, routes, bookings, etc. TRAVELS MODULE: This module provides the details of various travel agencies. A can select the appropriate agency depending on convenience and accessibility. ROUTES MODULE: This module provides information related to various routes connecting sources and destinations. For each route, information such as source, destination, fare, reservation details, pick up points etc are provides. Only can add, delete, edit and manage the data. s can only view the information. RESERVATIONS MODULE: This module provides functionalities that allow a to book tickets or cancel previously booked tickets. The module maintains the details of all reservations made so far and allows to either confirm or reject the bookings. TESTIMONIALS MODULE: s of this application can post their opinions, complaints and suggestions regarding this portal and services to the . Accordingly, the can take various steps to act on the complaints and suggestions. Tracking Module The Tracking Module will track the customer by dates, hotels, vehicles etc. MIS Reports where generated to keep track of the revenue, agent’s performance, etc., Voucher where generated for the customer for all the accommodation and transport facilities asked by the customer. MODULE: This module provides related functionality. manages all information and has access rights to add, delete, edit and view the data related to places, travels, routes, bookings, etc.

TRAVELS MODULE: This module provides the details of various travel agencies. A can select the appropriate agency depending on convenience and accessibility. ROUTES MODULE: This module provides information related to various routes connecting sources and destinations. For each route, information such as source, destination, fare, reservation details, pick up points etc are provides. Only can add, delete, edit and manage the data. s can only view the information. RESERVATIONS MODULE: This module provides functionalities that allow a to book tickets or cancel previously booked tickets. The module maintains the details of all reservations made so far and allows to either confirm or reject the bookings. TESTIMONIALS MODULE: s of this application can post their opinions, complaints and suggestions regarding this portal and services to the . Accordingly, the can take various steps to act on the complaints and suggestions.

Tracking Module The Tracking Module will track the customer by dates, hotels, vehicles etc. MIS Reports where generated to keep track of the revenue, agent’s performance, etc., Voucher where generated for the customer for all the accommodation and transport facilities asked by the customer

FRONT END ASP. NET

1. The pages developed using asp.net are compiled, providing better performance than with scripting languages. 2. It provides a programming model, and infrastructure to create scalable, secure and stable applications faster as well as more easily than with previous web technologies.

3. It is more than the next version of Active Server Pages, it is a unifies web development platform that provide the services necessary for developers to build enterprise- class web applications 4. It is a compiled, .NET – based environment. 5. Accessing database is made easier.

BACK END MICROSOFT SQL SERVER Microsoft SQL Server is a relational database management system developed by Microsoft. It provides an environment used to generate databases that can be accessed from workstations, the web or other media such Its primary query languages are MS-SQL and T- SQL SQL Server s different data types, including primary types such as integer decimal, float , char (including character strings), Varchar (variable length character strings), binary, Text (for textual data) among others. Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. SQL Server allows multiple clients to use the same database concurrently. As such, it needs to control concurrent access to shared data, to ensure data integrity - when multiple clients update the same data, or clients attempt to read data that is in the process of being changed by another client. The main mode of retrieving data from an SQL Server database is querying for it.

External Software Description 

Visual Studio 2008 or 10 or 12



Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silver light. It can produce both native code and managed code. Visual Studio s different programming languages and allows the code editor and debugger to (to varying degrees) nearly any programming language, provided a

language-specific service exists. Built-in languages include C, C++ and C+ +/CLI (via Visual C++), VB.NET (via Visual Basic .NET), C# (via Visual C#), and F# 

SQL Server 2008 Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent s. Its primary query languages are T-SQL and ANSI SQL.



.Net framework 3.5 or 4.0 .NET Framework (pronounced dot net) is a software framework developed by Microsoft that runs primarily on Microsoft Windows. It includes a large class library known as Framework Class Library (FCL) and provides language interoperability (each language can use code written in other languages) across several programming languages. Programs written for .NET Framework execute in a software environment (as contrasted to hardware environment), known as Common Language Runtime (CLR), an application virtual machine that provides services such as security, memory management, and exception handling. FCL and CLR together constitute .NET Framework.

HARDWARE REQUIREMENTS:  Processor: Intel dual core or above  Processor Speed:1.0GHZ or above  RAM: 1 GB RAM or above  Hard Disk: 20 GB hard disk or above

E-R DIAGRAM

CONTEXT FLOW DIAGRAM(DFD 0)

Database Design: