Tours and traveling

Report as inappropriate Your report has been received

Shared by: ndodariya

Tags

Tours, and, traveling, project, report

Stats

views:: 98
posted:: 11/30/2012
language:
pages:: 28

Public Domain

Document Sample

HOLIDAY TRAVELS

PREPAID BY:-
Sojitra Vimal.
Thaker Siddharth.
1
Tours & Travelling

Tours & Travelling
College Information

Name : T.N. Rao College of IT, Rajkot.

Project Details

Project Title: Tours & Travelling

Platform : Asp.Net & SQL server.

Guide By

Miss. Madhvi Bera

T.N.Rao college, MCA-5th 2
Tours & Travelling

College Certificate

T.N.Rao college, MCA-5th 3
Tours & Travelling

INDEX

1. INTRODUCTION
1.1 Project summary
1.2 Purpose
1.3 Scope
1.4 Technology & Literature Review
2. SYSTEM REQUIREMENTS STUDY
2.1 Hardware & Software Requirements
3. SYSTEM ANALYSIS
3.1 Feasibility study
3.2 Cost study
4. FUNCTION OF SYSTEM
4.1 Use cases
5. DATA FLOW DIAGRAM
5.1 Context level
5.2 Zero level
5.3 First level
6. SYSTEM DESIGN
6.1 Database Design
6.2 Input/Output and Interface design
7. CONCLUSION

T.N.Rao college, MCA-5th 4
Tours & Travelling

1. INTORDUCTION

1.1 PROJECT SUMMARY
Travel Booking is basically a web application which is developed in ASP.NET 2005. We
have used C# language for server side coding and SQL Server for the database. Internet helps people
to move around the world.

Internet use has made communication faster, provides information from the corners of the world,
made our work trouble-free and speedy. Today’s life is so busy and people have no time for standing
in queue, or waiting for anything. So, to make life easy for people we make a small web service for
travel management. It gives facility to book bus tickets online easily and speedy.

In the Travel Booking there are two levels of users. Administrator and User. Here administrator can
add or modify data. User can view, booked and purchasing the Tickets

1.2 PURPOSE
Using this web based application user can make online searching and purchasing from any place.
The main objective is user convenience. HolidayTravel.com provides easy user interface, simple
processing, and easy to use application.

 To reduce the manual work of task allocating, gathering reply from the employee.
 Increase the efficiency and accuracy of administration.
 Record the total work done report of the organization.
 Online allocation of the tasks to the employees.
 Reduce the stationary costs and miscellaneous costs of administration department.

1.3 SCOPE

HolidayTravel.com is a web application from which any person can reserve seats online without
physically presence of person. All the related information of the travel and its schedule can be

T.N.Rao college, MCA-5th 5
Tours & Travelling

provided by this website so the person can get each and every information of the travel. Also the
user can get the information related to site.

1.4 TECHNOLOGY AND LITERATURE REVEIEW

In developing the Travel Booking, we have used ASP.NET 2005. In which C# is used for server side
coding. SQL Server is used for as the database.

FrontEnd Contains:

-- Asp.NET

BackEnd Contains:

-- Microsoft SQL Server 2005

About ASP.NET (Front-End)

ASP.NET is the latest Microsoft programming framework that allows for the rapid
development of powerful web applications:
The reasons why one should use ASP.NET:

 Faster web applications:
Two aspects of ASP.NET make it fast—compiled code and caching. In the past, the code
was interpreted into “machine language” when your website visitor viewed your page.
Now, with ASP.NET the code is compiled into “machine language” before your visitor
ever comes to your site.

 Memory leak and crash protection:
ASP.NET automatically recovers from memory leaks and errors to make sure that your
website is always available to your visitors.

T.N.Rao college, MCA-5th 6
Tours & Travelling

 Multiple Language Support:
Programmers can actually write their code in more than 25 .NET languages (including VB.NET,
C# and JSCRIPT.NET). This allows programmers to develop your site in the language they know
best and it means that you can more easily find programmers to support the work on your site.

 Powerful web controls:
In ASP.NET we can use Tab Strip, Tree view, List view control, User control and Data grid control
using which we can do ADD/EDIT/DELETE in the grid itself, also it is having the advantages of
inbuilt sorting & paging logic.

 XML Support

You can use XML data in a variety of ways in ASP.NET. An XML data source control exposes XML data to
be used either as hierarchical or tabular data. You can bind a TreeView control to XML data to provide a
hierarchical view for users, or you can bind a list control such as the GridView control to display XML in a
traditional way.

 Data Display Controls

ASP.NET also includes enhanced support for displaying and updating data with controls on Web pages.
All controls can now use data source controls as data source instead of working directly against a
dataset or other store. You can also take advantage of the following new controls that are specifically
built to make data access easier:

The GridView , DetailsView , password. You can display user information with the LoginName control,
and present a Login or Logout button using the LoginStatus control. The LoginView control allows you to
mark content in a page that is visible only to authenticated users.

ASP.NET role management helps you manage authorization, providing high-level ways for you to define
and check roles for users.

Both the membership and role management systems use the new ASP.NET provider model, which
separates the functionality of the systems from the data store that supports them. For example,
membership allows you to store user information in Microsoft SQL Server or Microsoft Access. If these

T.N.Rao college, MCA-5th 7
Tours & Travelling

default options are not suitable for your requirements, you can create your own provider that accepts
calls from membership and then fulfills them using your custom data logic.

About SQL server 2005(Backends)

Microsoft SQL Server 2005

Microsoft® SQL Server™ 2005is a set of components that work together to meet the data
storage and analysis needs of the largest Web sites and enterprise data processing systems. The
topics in SQL Server Architecture describe how the various components work together to
manage data effectively.

Microsoft® SQL Server™ 2005data is stored in databases. The data in a database is organized
into the logical components visible to users. A database is also physically implemented as two or
more files on disk.

Each instance of SQL Server has four system databases (master, model, tempdb, and msdb)
and one or more user databases(hmd_db, Address_Book, payroll, sales, employees). Some
organizations have only one user database, containing all the data for their organization. Some
organizations have different databases for each group in their organization, and sometimes a
database used by a single application. For example, an organization could have one database for
sales, one for payroll, one for a document management application, and so on. Sometimes an
application uses only one database; other applications may access several databases.

It is not necessary to run multiple copies of the SQL Server database engine to allow multiple
users to access the databases on a server. An instance of the SQL Server Standard or Enterprise
Edition is capable of handling thousands of users working in multiple databases at the same time.
Each instance of SQL Server makes all databases in the instance available to all users that
connect to the instance, subject to the defined security permissions.

2. SYSTEM REQUIREMENT STUDY
T.N.Rao college, MCA-5th 8
Tours & Travelling

THE SOFTWARE REQUIREMENT SPECIFICATION IS PRODUCED AT THE CULMINATION OF THE
ANALYSIS TASK. THE FUNCTION AND PERFORMANCE ALLOCATED TO SOFTWARE AS A PART OF

SYSTEM ENGINEERING ARE REFINED BY ESTABLISHING A COMPLETE INFORMATION

DESCRIPTION , A DETAILED FUNCTIONAL DESCRIPTION , A PRESENTATION OF SYSTEM BEHAVIOR ,

AN INDICATION OF PERFORMANCE REQUIREMENTS AND DESIGN CONSTRAINTS , APPROPRIATE

VALIDATION CRITERIA , AND OTHER INFORMATION PERTINENT TO THE REQUIREMENTS .

THE INTRODUCTION TO THE SOFTWARE REQUIREMENTS SPECIFICATION STATES THE GOALS

AND OBJECTIVES OF THE PROJECT, DESCRIBING IT IN THE CONTEXT OF THE COMPUTER -BASED

SYSTEM. THE PROJECT WHICH WE HAVE DEVELOPED IS THE SYSTEM THAT MANAGES AN ENTIRE
BOOKING TASK. IT DEALS LOT OF WORK STARTING FROM SEARCH BUS ROUTE , BOOKING , GIVE

TICKET ID , ADMIN CAN MANAGE HOLE SYSTEM ETC .

THE MAIN GOAL OF THIS PROJECT WAS TO MAKE THE ENTIRE MANAGEMENT COMPUTER -

BASED. ALL THE FUNCTION SPECIFIED ABOVE ARE TO BE IMPLEMENTED BY A SINGLE CLICK OF
MOUSE OR A SINGLE ENTER OF KEYBOARD RATHER THAN MAINTAINING A HUGE AMOUNT OF

PAPER WORK. THIS MAKES THE WORK EASIER , FASTER AND MORE ACCURATE. THE ULTIMATE

RESULT IS THE SAVING OF TIME AND REDUCTION OF HUMAN EFFORTS . THE PROJECT IS MADE

THAT FLEXIBLE SO THAT IT CAN ACCOMMODATE ANY CHANGES OR ANY REQUIREMENTS

EASILY.

2.1 HARDWARE AND SOFTWARE REQUIREMENTS

Minimal Hardware Requirements:

 Intel Pentium 4 1GHz processor
 500MB SDRAM
 20GB Hard disk space
 Internet Connection

T.N.Rao college, MCA-5th 9
Tours & Travelling

Minimal Software Requirements:

 Windows XP SP2 or later
 Microsoft Visual Studio 2005
 Microsoft .Net Framework v2.0
 SQL server 2005

3. SYSTEM ANALYSIS

FEASIBILITY STUDY

A feasibility study is undertaken to determine the possibility or probability of either improving
the existing system or developing a completely new system.

T.N.Rao college, MCA-5th 10
Tours & Travelling

It helps to obtain an overview of the problem and to get rough assessment of whether feasible solution
exists.

Need for Feasibility Study:-

The feasibility study is needed to

(1) Answer the question whether a new system is to be installed or not?
(2) Determine the potential of the existing system.
(3) Improve the existing system.
(4) Know what should be embedded in the new system.
(5) Define the problems and objective involved in a project.
(6) Avoid costly repairs at a later stage when the system is implemented.
(7) Avoid crash implementation of a new system.
(8) Avoid the ‘Hardware Approach’ i.e. getting a computer first and then deciding how
to use it.

1. Technical Feasibility: -

Technical feasibility corresponds to determination of whether it is technically feasible to develop
the software.

 Necessary technology exists to do what is suggested and required by the organization.
 The hardware needed to develop and implement the system is adequate.
 The software guarantees accuracy, reliability and ease of access and data security.
2. Economical Feasibility: -
A system that can be developed and that will be used if installed must still be a good investment for the
organization. Financial benefits must equal or exceed the costs.

The financial and economical issues raised are as under:

 No extra cost is incurred for developing the system. As required software are already used by
the department.
 No extra cost for the modification or addition of software and hardware will require in case of
future expansion of the current system.

T.N.Rao college, MCA-5th 11
Tours & Travelling

 The company will be at profit if they implement this system because of the cost of
implementation is nominal as compared to the profit they will be earning in terms of efficiency.
Considering above factors project is economically feasible.

3. Operational Feasibility: -
Operational feasibility focuses on whether the system will work when it is developed and installed.
Operationally the system is feasible because:

 There is sufficient support for the project from management and user. The system is well liked
and used to the extent that persons will not be able to see reasons for change.
 The users have been involved in the planning and development of the project. This reduces the
chances of resistance to the system.
 The proposed system will not cost any harm to the existing system and its users.
 No special training required for the user as it has a self explanatory interface. Validation of data
input is taken care of by the system and not by the user.

COST STUDY

 There are mainly two types of costs.
 Direct cost
 Indirect cost

 Direct cost:
 In direct cost, cost of the software’s and toll are included. In our project we use
Visual Studio 2005 and Microsoft SQL Server 2005. The prices of all of this are
shown below.
 Microsoft Visual Studio 2005 – 800$
 Microsoft SQL Server 2005 – 400$
 Indirect cost
 In indirect cost, cost of man power is included for requirement analysis, project
development and training of the project given to the user.
 For requirement analysis we spend 15 days of time in starting of project.
 For development we spend 4 hours per day for 2 months.
 And for training of the project we will provide 1 week of one trainer to the user.
So the cost of all this are also included in the project.

T.N.Rao college, MCA-5th 12
Tours & Travelling

4. FUNCTION OF SYSTEM

4.1 USE CASE DAIGRAM

T.N.Rao college, MCA-5th 13
Tours & Travelling

4. DFD (DATA FLOW DIAGRAM)

T.N.Rao college, MCA-5th 14
Tours & Travelling

DFD SYMBOLS

External Entity

Process

Data Store

Data Flow

T.N.Rao college, MCA-5th 15
Tours & Travelling

CONTEXT LEVEL DFD

ZE
RO LEVEL DFD

T.N.Rao college, MCA-5th 16
Tours & Travelling

FIRST LEVEL DFD

6. SYSTEM DESIGN

6.1 DATABASE DESIGN

For Our project we have use the SQL as back-end tool. There are following tables are
included.

1. Table Name –Admin_Login
This table is used to login for administrator. It is also use to ticket id
T.N.Rao college, MCA-5th 17
Tours & Travelling

2. Table Name- Booking_Master
This table is used to maintain the information of Passengers.

3.Table Name- Bus_Detail

This table is used to maintain the information of the new buses.

T.N.Rao college, MCA-5th 18
Tours & Travelling

4.Table Name - Office_Detail

This table is used to maintain the information of Offices at different locations.

5. Table Name -Route_Master

This table is used to maintain the information of the new route and contains the source and
destination

T.N.Rao college, MCA-5th 19
Tours & Travelling

6. Table Name –Registration

This table used to user for login and registration.

7. Table Name – Route_Detail

This table is used to maintain the detailed information of the route. It manages the bus on that
route its time and fare etc…

T.N.Rao college, MCA-5th 20
Tours & Travelling

8. Table Name – Station_Master

This table is used to maintain the information of the new station.

6.2 Input/Output and Interface Design

Welcome Form:-

This is the main page of website. The HOME PAGE. It contains the links to all functionalities of
the website.

T.N.Rao college, MCA-5th 21
Tours & Travelling

This is the LOGINPAGE. Admin and user can login from this page.

This is register page. New user can registered first and then he/she can login.

T.N.Rao college, MCA-5th 22
Tours & Travelling

This web page is use to search a ticket. User must enter his source, destination, type, date and
no of seats and then it find the bus.

T.N.Rao college, MCA-5th 23
Tours & Travelling

Admin is login .

This is admin HOME PAGE.

T.N.Rao college, MCA-5th 24
Tours & Travelling

This is Station Report.To add a new station.

From this page admin can modify station.

T.N.Rao college, MCA-5th 25
Tours & Travelling

Admin can add a new bus.

T.N.Rao college, MCA-5th 26
Tours & Travelling

The admin can edit any route if it wants.

T.N.Rao college, MCA-5th 27
Tours & Travelling

7.CONCLUSION

The application Holiday travel works satisfactorily. Using it the users and the administrator
can perform the function appropriately. The result of the application is pleasing.

The website gives accurate and desired results in various ways. Overall the performance of
the application is near to perfection. It works according to user’s demand.

T.N.Rao college, MCA-5th 28

Shared by: Nikhil Dodariya