Docstoc

Tours and traveling

Document Sample
Tours and traveling Powered By Docstoc
					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.

Login From:-




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

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:98
posted:11/30/2012
language:
pages:28
Nikhil Dodariya Nikhil Dodariya Love is Everything http://143loveu.blogspot.in
About I am simple and collage student. and always ready for the hard and new work.