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
"Tours and traveling"