The document describes an online bus ticket reservation system that allows customers to book tickets, check availability, and track reservations online instead of having to visit booking counters in person. It includes requirements for functionality like maintaining customer profiles and booking details in a database, calculating fares automatically based on distance and age, and providing search, booking and cancellation features for employees to manage reservations. Tables to store information about buses, routes, bookings and more are also outlined.
This document describes the design and implementation of an online bus ticket booking system. It includes entity relationship diagrams and data flow diagrams to model the system. The system allows users to register accounts, view bus schedules and book tickets online. It also allows administrators to manage bus routes, timetables and fares. The system was developed using C# and SQL Server for the backend database. Screenshots of some of the web pages like the register, login, change password, add bus and add route pages are included.
The document presents an online bus ticket management system, outlining three main use cases - ticket reservation, user authentication, and viewing detailed trip information - and proposing user interface designs for the home page, admin panel, sign-in, and seat reservation screens. Key system requirements include booking and canceling tickets, authenticating users, and providing admin controls.
The document describes an online bus reservation system project report submitted for an M.Sc. IT program. The project aims to develop a system that allows users to register, search and book bus tickets online. It includes requirements like managing bus, route and booking information as an admin and allowing users to select seats, book tickets and cancel bookings. The system was built using technologies like ASP.NET MVC, SQL Server 2012 and deployed on a Windows server with Chrome as the preferred browser. It features functionalities for registration, login, booking management, report generation and admin controls.
The document describes an Online Bus Ticket Reservation System (OBTRS) created by Ashwin Sharma, Nikhil Vyas, and Nilesh Soni. The system allows users to reserve seats, cancel reservations, and access various inquiries. It maintains user, bus, reservation, booking, and customer details. The system was designed to computerize the traditional paper-based process and make ticket booking and tracking easier online.
Tourism is a big growth business in all countries. Bus Reservation System deals with maintenance of records details of each passenger. It also includes maintenance of information such as timetable and details in each bus.
This document provides an overview of a bus ticket reservation system application. It includes sections on the problem statement, hardware/software requirements, screenshots of the application interface, and an entity relationship diagram. The application allows users to manage bus data including routes and seats, inquire about seat availability, register and search tickets, cancel tickets, and view fare lists. Administrators can manage user and bus data while employees can book tickets and change passwords.
This document describes an online railway reservation system. It includes sections on the problem statement, functions for users and administrators, database tables and normalization, triggers, and snapshots. The problem statement indicates the system needs to store and retrieve transaction information about rail travel. Sections on functions list features like ticket booking, checking status, and cancellation for users, and adding/removing trains and users for administrators. Tables shown include users, trains, tickets, and payments, along with normalization to third normal form. Triggers are described to update fields when payment is made or an account is cancelled/created.
This document describes the design and implementation of an online bus ticket booking system. It includes entity relationship diagrams and data flow diagrams to model the system. The system allows users to register accounts, view bus schedules and book tickets online. It also allows administrators to manage bus routes, timetables and fares. The system was developed using C# and SQL Server for the backend database. Screenshots of some of the web pages like the register, login, change password, add bus and add route pages are included.
The document presents an online bus ticket management system, outlining three main use cases - ticket reservation, user authentication, and viewing detailed trip information - and proposing user interface designs for the home page, admin panel, sign-in, and seat reservation screens. Key system requirements include booking and canceling tickets, authenticating users, and providing admin controls.
The document describes an online bus reservation system project report submitted for an M.Sc. IT program. The project aims to develop a system that allows users to register, search and book bus tickets online. It includes requirements like managing bus, route and booking information as an admin and allowing users to select seats, book tickets and cancel bookings. The system was built using technologies like ASP.NET MVC, SQL Server 2012 and deployed on a Windows server with Chrome as the preferred browser. It features functionalities for registration, login, booking management, report generation and admin controls.
The document describes an Online Bus Ticket Reservation System (OBTRS) created by Ashwin Sharma, Nikhil Vyas, and Nilesh Soni. The system allows users to reserve seats, cancel reservations, and access various inquiries. It maintains user, bus, reservation, booking, and customer details. The system was designed to computerize the traditional paper-based process and make ticket booking and tracking easier online.
Tourism is a big growth business in all countries. Bus Reservation System deals with maintenance of records details of each passenger. It also includes maintenance of information such as timetable and details in each bus.
This document provides an overview of a bus ticket reservation system application. It includes sections on the problem statement, hardware/software requirements, screenshots of the application interface, and an entity relationship diagram. The application allows users to manage bus data including routes and seats, inquire about seat availability, register and search tickets, cancel tickets, and view fare lists. Administrators can manage user and bus data while employees can book tickets and change passwords.
This document describes an online railway reservation system. It includes sections on the problem statement, functions for users and administrators, database tables and normalization, triggers, and snapshots. The problem statement indicates the system needs to store and retrieve transaction information about rail travel. Sections on functions list features like ticket booking, checking status, and cancellation for users, and adding/removing trains and users for administrators. Tables shown include users, trains, tickets, and payments, along with normalization to third normal form. Triggers are described to update fields when payment is made or an account is cancelled/created.
This document certifies that six students - Debanjan Ghosal, Anusrita Dey Sarkar, Arnab Sengupta, Oyindrila Bhattacharjee, Dwaipayan Sinha, and Priyanka Kashyap - completed a project on an Online Railway Reservation System under the guidance of Mr. Sandip Adhikary for their Bachelor of Computer Application degree. It thanks their subject teacher Mr. Adhikary and other faculty members for their guidance and support in completing the project. It also provides details about the hardware, software, user interface, and operating system used in developing the project.
The document proposes an online bus ticket reservation system for Udankhatola, a private bus transportation company. Currently, customers must visit ticket counters and wait in long lines to purchase tickets or check schedules. The proposed system would allow customers to book tickets and check availability online 24/7 via the Internet. It would also enable online payments and email ticket delivery. The system design involves modules for login, routes, bus info, and payments. Data flow diagrams and use cases are also included in the design. The goal is to provide a more convenient and efficient reservation process for customers.
This is a project documentation titled: Online Railway Reservation System.
This documentation was submitted by me as my assignment in my 6th sem (2013) in APIIT SD INDIA, Panipat along with a full-fledged working system i.e., a website built using ASP.NET & SQL SERVER 2008
This is a presantation on railway reservation system project in php. project report and source code will be available soon . you can find it at www.avhishekblog.wordpress.com . hope this is useful to you
The document describes a railway reservation system that allows users to perform enquiries, reservations, cancellations, and check statuses. It outlines essential parameters like train details, passenger information, and stations. The reservation process acquires passenger details, checks seat availability, and issues tickets if available. Cancellations remove tickets if the number is valid, and enquiries display appropriate train information. Statuses show if a reservation is reserved or not reserved. The system utilizes structures, files, arrays of strings, and pointers.
The document describes an online railway reservation system project completed by Prince Kumar for his Database and Web Database Systems module. It includes a certificate signed by Prince Kumar and his module lecturer, Ms. Sulekh Sharma, acknowledging completion of the individual assignment. It also includes an acknowledgement from Prince Kumar thanking various people and organizations for their support during the project. The table of contents provides an overview of the sections in the project report, which describe aspects of designing and developing the online railway reservation system such as entity relationship diagrams, database design, form design, and database queries.
This document describes an online reservation system created by Rakesh Kunwar for railway ticket reservations and cancellations. It allows passengers to reserve and cancel seats on trains through a computerized system, which is more efficient than handling the vast Indian railway system manually. The system securely stores train, passenger, and reservation information and generates tickets and reports.
This document outlines an online bus booking system called DreamTravel.com. It describes the objectives, existing system limitations, proposed new system features, and technical specifications. The proposed system aims to address limitations in refund speed and customer service in existing systems. It will offer special discounts, message alerts on delays, and standardized pricing throughout the year. The technical specifications include Windows-based front-end software using HTML, C#, and a MySQL backend database.
The document describes an e-ticketing project for online railway reservation. It includes sections on abstract, introduction, modules with examples and UML diagrams, and interfaces. The project aims to develop software for online railway ticket booking, reservation, cancellation and checking availability. It provides key features like booking tickets from home, payment options, and transaction security. UML diagrams like use case diagram, class diagram, sequence diagram and activity diagrams are used to model different aspects of the system.
The document describes the existing manual airline reservation system used by Overseas Travels Pvt. Ltd. and proposes developing a computerized system to address limitations of the manual process. The existing system is time-consuming, prone to errors, and has high costs. The proposed computerized system using Visual Basic and Oracle aims to increase efficiency, accuracy, security and reduce costs by automating reservation, cancellation and reporting processes. Stakeholder interviews and documentation reviews were conducted to understand system requirements and gather necessary facts for developing the new system.
The document outlines requirements for a railway reservation system. The system would allow customers to view train schedules and availability, reserve tickets, pay for reservations, and cancel tickets. It describes functions for maintaining train data, the reservation process, billing, and cancellation. The system needs to be reliable, available, and secure. Development will use Visual Basic for the front end and MS Access for the back end, with approval required from the Ministry of Railways.
Use Case, Activity, Sequence, Class Diagram of Bus Ticket Management System.
Poster Design of Bus Ticket Management System.
By- CSE Students of East West University
This document outlines the design of an online bus ticket reservation system (OBTRS) for Udankhatola travels. The system allows customers to book tickets online instead of having to visit booking counters. It describes the system requirements, design which includes modules for login, routes, bus info, and payment. Sequence diagrams and UI screens are presented. The system aims to provide an efficient, user-friendly, and accurate online reservation service available 24/7.
Project report RAILWAY TICKET RESERVATION SYSTEM SADNitesh Singh
This document provides a project report on developing a railway ticket reservation system. It includes sections that outline the system's requirements and functions for booking and cancelling tickets, checking PNR status and train details. It also includes data flow diagrams, decision tables, a decision tree, sequence diagram, use case diagram, activity diagram, structure chart, and Ishikawa diagram to model and design the system. Key terms used in the system like PNR, DFD, e-ticket, and i-ticket are defined in a glossary.
The document summarizes Faisal Khan's presentation on the Phase 2 of an Airline Reservation System project. It includes an agenda that discusses completing action items from Phase 1, presenting the architecture design using class and sequence diagrams, formal requirements specification, a test plan covering different types of testing, and an architecture prototype. Formal technical inspection letters were also submitted by two reviewers.
The document provides a software requirement specification for an online railway reservation system called Reserve-All. It outlines the following key points:
1. The system will provide features for user registration and login, train and seat availability inquiries, ticket booking including Tatkal tickets, cancellation and refund facilities, and transaction history.
2. The admin requirements include user database management, payment management, and syncing with the official railway reservation system.
3. The user needs basic computer and internet knowledge. The system requires a secure internet connection and Java-enabled browser.
4. The performance goals are a response time of around 2 seconds and handling over 1,000 concurrent users. Security and fault tolerance are also design constraints.
The document describes an online bus ticket management system. It includes a class diagram showing the main classes like Customer, Route Details, Payment etc. and their relationships. It also includes two test cases for admin registration and user registration with valid and invalid login details. A third test case checks user login with valid and invalid credentials. A fourth test case covers searching and booking a reservation with valid and invalid route/bus details.
Process control system of bus ticket booking (closed loop)Jigar Nayak
The document discusses an online bus ticket booking system created for Udankhatola, a bus transportation company in India. Currently, customers must visit ticket counters to purchase tickets or check schedules, leading to long wait times. The proposed solution is an online booking system allowing customers to purchase tickets 24/7 from any location and check availability before purchasing. It also allows customers to pay during travel rather than with cash at time of purchase. Data flow diagrams at the 0 level and for registered and guest users are provided to illustrate how customer data and reservations will flow through the system.
The KAP Cabs application allows students at IIT Kharagpur to book taxis online. Users can choose between vehicle types and provide pickup details to make a booking. Both users and drivers receive SMS notifications with booking and user details. Administrators can manage the taxi fleet by updating vehicle availability and fares collected. The application generates reports on fares by taxi and booking trends by user.
A mobile-based application that works with a centralized network management system is known as an online bus booking app.
This system allows users to monitor bus seat availability, purchase tickets, make secure online payments, and, if necessary, cancel tickets all from a single platform.
This document certifies that six students - Debanjan Ghosal, Anusrita Dey Sarkar, Arnab Sengupta, Oyindrila Bhattacharjee, Dwaipayan Sinha, and Priyanka Kashyap - completed a project on an Online Railway Reservation System under the guidance of Mr. Sandip Adhikary for their Bachelor of Computer Application degree. It thanks their subject teacher Mr. Adhikary and other faculty members for their guidance and support in completing the project. It also provides details about the hardware, software, user interface, and operating system used in developing the project.
The document proposes an online bus ticket reservation system for Udankhatola, a private bus transportation company. Currently, customers must visit ticket counters and wait in long lines to purchase tickets or check schedules. The proposed system would allow customers to book tickets and check availability online 24/7 via the Internet. It would also enable online payments and email ticket delivery. The system design involves modules for login, routes, bus info, and payments. Data flow diagrams and use cases are also included in the design. The goal is to provide a more convenient and efficient reservation process for customers.
This is a project documentation titled: Online Railway Reservation System.
This documentation was submitted by me as my assignment in my 6th sem (2013) in APIIT SD INDIA, Panipat along with a full-fledged working system i.e., a website built using ASP.NET & SQL SERVER 2008
This is a presantation on railway reservation system project in php. project report and source code will be available soon . you can find it at www.avhishekblog.wordpress.com . hope this is useful to you
The document describes a railway reservation system that allows users to perform enquiries, reservations, cancellations, and check statuses. It outlines essential parameters like train details, passenger information, and stations. The reservation process acquires passenger details, checks seat availability, and issues tickets if available. Cancellations remove tickets if the number is valid, and enquiries display appropriate train information. Statuses show if a reservation is reserved or not reserved. The system utilizes structures, files, arrays of strings, and pointers.
The document describes an online railway reservation system project completed by Prince Kumar for his Database and Web Database Systems module. It includes a certificate signed by Prince Kumar and his module lecturer, Ms. Sulekh Sharma, acknowledging completion of the individual assignment. It also includes an acknowledgement from Prince Kumar thanking various people and organizations for their support during the project. The table of contents provides an overview of the sections in the project report, which describe aspects of designing and developing the online railway reservation system such as entity relationship diagrams, database design, form design, and database queries.
This document describes an online reservation system created by Rakesh Kunwar for railway ticket reservations and cancellations. It allows passengers to reserve and cancel seats on trains through a computerized system, which is more efficient than handling the vast Indian railway system manually. The system securely stores train, passenger, and reservation information and generates tickets and reports.
This document outlines an online bus booking system called DreamTravel.com. It describes the objectives, existing system limitations, proposed new system features, and technical specifications. The proposed system aims to address limitations in refund speed and customer service in existing systems. It will offer special discounts, message alerts on delays, and standardized pricing throughout the year. The technical specifications include Windows-based front-end software using HTML, C#, and a MySQL backend database.
The document describes an e-ticketing project for online railway reservation. It includes sections on abstract, introduction, modules with examples and UML diagrams, and interfaces. The project aims to develop software for online railway ticket booking, reservation, cancellation and checking availability. It provides key features like booking tickets from home, payment options, and transaction security. UML diagrams like use case diagram, class diagram, sequence diagram and activity diagrams are used to model different aspects of the system.
The document describes the existing manual airline reservation system used by Overseas Travels Pvt. Ltd. and proposes developing a computerized system to address limitations of the manual process. The existing system is time-consuming, prone to errors, and has high costs. The proposed computerized system using Visual Basic and Oracle aims to increase efficiency, accuracy, security and reduce costs by automating reservation, cancellation and reporting processes. Stakeholder interviews and documentation reviews were conducted to understand system requirements and gather necessary facts for developing the new system.
The document outlines requirements for a railway reservation system. The system would allow customers to view train schedules and availability, reserve tickets, pay for reservations, and cancel tickets. It describes functions for maintaining train data, the reservation process, billing, and cancellation. The system needs to be reliable, available, and secure. Development will use Visual Basic for the front end and MS Access for the back end, with approval required from the Ministry of Railways.
Use Case, Activity, Sequence, Class Diagram of Bus Ticket Management System.
Poster Design of Bus Ticket Management System.
By- CSE Students of East West University
This document outlines the design of an online bus ticket reservation system (OBTRS) for Udankhatola travels. The system allows customers to book tickets online instead of having to visit booking counters. It describes the system requirements, design which includes modules for login, routes, bus info, and payment. Sequence diagrams and UI screens are presented. The system aims to provide an efficient, user-friendly, and accurate online reservation service available 24/7.
Project report RAILWAY TICKET RESERVATION SYSTEM SADNitesh Singh
This document provides a project report on developing a railway ticket reservation system. It includes sections that outline the system's requirements and functions for booking and cancelling tickets, checking PNR status and train details. It also includes data flow diagrams, decision tables, a decision tree, sequence diagram, use case diagram, activity diagram, structure chart, and Ishikawa diagram to model and design the system. Key terms used in the system like PNR, DFD, e-ticket, and i-ticket are defined in a glossary.
The document summarizes Faisal Khan's presentation on the Phase 2 of an Airline Reservation System project. It includes an agenda that discusses completing action items from Phase 1, presenting the architecture design using class and sequence diagrams, formal requirements specification, a test plan covering different types of testing, and an architecture prototype. Formal technical inspection letters were also submitted by two reviewers.
The document provides a software requirement specification for an online railway reservation system called Reserve-All. It outlines the following key points:
1. The system will provide features for user registration and login, train and seat availability inquiries, ticket booking including Tatkal tickets, cancellation and refund facilities, and transaction history.
2. The admin requirements include user database management, payment management, and syncing with the official railway reservation system.
3. The user needs basic computer and internet knowledge. The system requires a secure internet connection and Java-enabled browser.
4. The performance goals are a response time of around 2 seconds and handling over 1,000 concurrent users. Security and fault tolerance are also design constraints.
The document describes an online bus ticket management system. It includes a class diagram showing the main classes like Customer, Route Details, Payment etc. and their relationships. It also includes two test cases for admin registration and user registration with valid and invalid login details. A third test case checks user login with valid and invalid credentials. A fourth test case covers searching and booking a reservation with valid and invalid route/bus details.
Process control system of bus ticket booking (closed loop)Jigar Nayak
The document discusses an online bus ticket booking system created for Udankhatola, a bus transportation company in India. Currently, customers must visit ticket counters to purchase tickets or check schedules, leading to long wait times. The proposed solution is an online booking system allowing customers to purchase tickets 24/7 from any location and check availability before purchasing. It also allows customers to pay during travel rather than with cash at time of purchase. Data flow diagrams at the 0 level and for registered and guest users are provided to illustrate how customer data and reservations will flow through the system.
The KAP Cabs application allows students at IIT Kharagpur to book taxis online. Users can choose between vehicle types and provide pickup details to make a booking. Both users and drivers receive SMS notifications with booking and user details. Administrators can manage the taxi fleet by updating vehicle availability and fares collected. The application generates reports on fares by taxi and booking trends by user.
A mobile-based application that works with a centralized network management system is known as an online bus booking app.
This system allows users to monitor bus seat availability, purchase tickets, make secure online payments, and, if necessary, cancel tickets all from a single platform.
Transport Plus is a software system that helps companies manage transportation for employees. It has four types of users: administrators, approvers, transport people, and employees. Administrators can add employee and transportation information and approve transportation requests. Approvers can also approve requests. Transport people can view transportation details and approve or deny requests. Employees can submit requests to use buses or cabs, which are then approved or declined. The system tracks transportation usage and provides reports to manage the process.
Online Bus Ticketing System is an automated system for purchasing online bus tickets. This system is a user-friendly method to manage the whole bus system. Most importantly, the online bus ticketing system has made everything easier for businesses and passengers as well.
IRJET- Online Facility of Ticket Booking and Generating Buspass using QR CodeIRJET Journal
This document summarizes a research paper that proposes an online system for bus pass booking and ticket generation in Nagpur, India using QR codes. The system aims to address issues with the current manual process that causes long wait times for passengers. It allows users to register online, book and pay for tickets, renew bus passes, and receive notifications. The system has modules for registration, authentication, payment, pass/ticket generation, renewal, and notifications. It also includes a scanning module for conductors to validate passes by scanning the QR codes. The proposed system is expected to make the process more efficient and convenient for passengers to book tickets and renew passes online.
Wunder Shuttle Service Mobile App- Concept by Kheema PandeyKheema Pandey
The document outlines a proposed shuttle driver app called Wunder Shuttle Driver. It aims to provide a seamless system to connect passengers and drivers through technology. Currently, traditional shuttle services lack online/mobile booking and require much manual effort. The app would allow passengers to request rides through an app and drivers to accept requests and optimize routes. User research was conducted through interviews and online articles to understand pain points like finding parking, traffic issues, and checking passenger information. Prototypes were created for driver and passenger user flows, screens and personas to address these pain points and improve the shuttle experience.
The project is developed using android and web. The application provide solution for student bus pass, route pass and bus ticket, route information and scan QR code verification for the bus pass.
This document describes a vehicle management system that allows companies to manage transportation for employees. It has four main modules: bus management, route management, employee management, and passenger management. The system allows administrators to create user accounts, manage employee and transportation category information, and add/update routes. Employees can request transportation and approve transportation requests. The system tracks transportation usage and costs through reports. It was developed using Java and is meant to help companies efficiently manage fleet vehicles and transportation for employees.
Are you an investor or an Entrepreneur looking to invest in Mobile Apps? Traditional Taxi Industry was shakened by Ride Hailing Services like Uber. Here are Top features, a Cab Booking App must have.
The document discusses the features and functionality of a taxi booking app. It outlines 10 core features including login/signup, location tracking, cab booking, ride scheduling, payments, feedback, customer support, security, push notifications, and viewing booking history. It then provides more details on the sign up/login process, how location tracking and maps work, how users can book and schedule rides, contact drivers, select payment options, provide feedback, contact support, and access security, notifications and trip history reports. The conclusion encourages entrepreneurs and investors looking to develop a customized taxi app to contact an experienced taxi app development company.
This document summarizes a project to develop a web application called Traffic Congestion Tracking Control. The application would allow users to book and purchase bus tickets online, track buses using GPS, and manage transportation company data and operations. A group of three students - Zunera Latif, Kiran Mustafa, and Noshaba Khalil - propose developing the application to address problems with current manual ticket booking systems and improve the transportation experience. The document outlines the project scope, features, requirements and implementation tools and languages.
This document provides information about a database prototype created for Virgin Trains to manage the process of booking train tickets online. It includes a level 0 and level 1 data flow diagram showing the steps a customer takes to book a ticket and how data flows between the customer, Virgin Trains staff, and various databases. An entity relationship diagram displays the relationships between customers, train information, tickets, and invoices. Finally, screenshots show the front-end menu and four tables - Customers, Train Information, Reservations, and Invoices - that were created in a Microsoft Access database to store customer, journey, and payment details for ticket purchases.
This document outlines plans for an online bus ticket reservation system called ORB. It will allow customers to book tickets online for several bus companies. The system will be developed using a custom software and installed on the distributor company's server. Customers can book tickets by visiting the website, searching schedules, and entering payment and travel details. Tickets will be issued electronically and can be printed or saved. The system aims to provide a convenient service for customers and increase efficiency for bus companies.
The document proposes a Hyperbus system using web technology to provide real-time bus tracking and improve the bus transportation experience. The system would allow passengers to track bus locations, view estimated arrival times, buy tickets online, and book seats. It aims to reduce wait times and anxiety for passengers by ensuring they have accurate bus information. The system provides benefits for both passengers and bus operators by modernizing services and making them more efficient. It incorporates features like online ticket purchasing, real-time tracking, seat booking, and a mobile app to provide updates. The goal is to improve sustainability of public transportation by maximizing passenger satisfaction and convenience.
Taxi App Development Company, our mobile taxi app developers serving custom taxi booking app development and a ready made taxi booking app solution for your taxi cab company to grow and expand business.
This document describes several online systems for different purposes:
1. An online event management system to help event managers schedule and organize festivals and events more efficiently. It includes modules for service coordinators, section managers, employees, and clients.
2. An online movie ticket reservation system that allows customers to reserve and purchase tickets online for a particular cinema hall. It includes modules for administrators, clients, movie distributors, and theatre owners.
3. An online blood bank system to connect blood donors with those needing donations. It includes modules for administrators and two types of clients - acceptors and donors. Clients can search for blood availability and register as acceptors or donors.
This document describes a railway reservation system project built with PHP and MYSQL. The system allows users to register accounts, log in, book and pay for tickets online, check PNR status, and cancel reservations. It stores train schedules and availability, manages bookings and payments, generates ticket numbers, and handles refunds according to rules. The system is for use by passengers to reserve seats and by administrators to maintain train and fare details.
The document proposes a system to provide transportation information to residents and visitors of a city. The existing system does not provide comprehensive transportation details. The proposed system would allow users to view public transportation schedules, routes, fares and real-time updates. It would also give registered users the ability to provide feedback and allow city employees to update transportation content in the centralized database. The system would be built using Java and deployed on a Tomcat server with an Oracle database.
Similar to Online Bus Ticket Reservation System (20)
3. INTRODUCTION
Online Bus Ticket Reservation System is Windows based application that works within
centralized network. The software program “Online Bus Reservation System” provides bus
transportation system, a facility to reserved seats, cancellation of seats and different types of
enquiry which need an instant and quick reservation. OBTRS is built for manage and
computerize the traditional database, ticket booking and tracking bus and travel made easy. It
allows counter employee check bus ticket availability and make reservation on particular
customer. It maintains all datas of employees, users , bus details, reservation details, booking
details, customer details.
Default username is admin and password is root.
REQUIREMENT
Introduction :
SRC Travel Agencies is a domestic privatized transportation company that runs the vehicles all
over the country. They have several branches at different locations of the country, so that they
can provide the transportation facilities between the places. They want an online application to
be developed, where the details of the bookings done and the customer will be updated from
time to time and one can track the details of the available seats immediately.
Problem statement :
Customers have to go to the counter to buy bus ticket or ask for bus schedule. Customers need
to pay cash when they buy bus tickets and sometimes needs to queue up for hours to get bus
tickets. Besides that, customers are also not allowed to buy bus tickets through telephone
because the bus company's telephone line is always busy.
4. Existing Scenario :
SRC Travel Agencies is the agency that provides the transportation facility to the customers
based on their requirements. They provide different buses like Express, Luxury, and Volvo (Has
two types A/C and Non A/C). The charges are different for different buses. The charges are in
the below mentioned format.
Express < Luxury < Volvo (Non A/C) < Volvo (A/C)
The charges also depend on the distance the customer wants to travel and as well on the age of
the customer. The charges also depends on the age, i.e., up to the age of 5 years there will not
be any charges, in between 5 12 there will be half charges and for above twelve the charges will
be full till the age of 50 and for the age above fifty they will get a discount of 30%. They
implement this in order to attract the customers. They maintain all the records of the bus
reservation counter through Online service itself but the application is only accessed by the
Admin and the Employers Alone. Until now they used to issue the tickets in the buses alone as
it is difficult to track the details of the bookings done as it provides the service allover the
country.
Proposed Solution :
Now they want incorporate an online service application where they can maintain the records
of the buses along with the details of the customers. The customer can now book the tickets by
visiting the booking counters at their place (near by) to the respective destination as required.
They want the application to be linked with the database, so that what ever details are entered
like the details of the customers, buses, and bookings can be viewed by the other centers as
well as it is an online application. They also want to incorporate some feature which performs
the tasks that they actually perform, and an application where the customer can register with
the site and then book the tickets online instead of visiting the booking counter A database
should be maintained where the bus details along with the bus number, route, the places it
covers through out the distance and also the timings are needed to be maintained. Also the
details of the customers that are entered at the time of booking the tickets are needed to be
gathered in the database. So that they can track the details of the customer at any time using
5. the search option based on the starting place, age, name, destination place and Date and Time
and even based on the bus they had chosen.
The database should also maintain the list of the Employers as they alone book the tickets with
the username and password. The list that is to be maintained is personal details, contact
details, location, qualification, age, etc are needed to be gathered. There should be buttons like
New, Update and Cancel are to be included. Based on the button chosen the respective action
is needed to be performed. Also if the Employee record is entered (The Employee details will be
maintained by the Admin alone), it should automatically generate a six digit code, and it will ask
for the username and the password (the password can be changed by the Employee) through
which he can login in to the a/c so as to perform the booking tasks. Also for canceling the ticket,
there is a limit like, if cancelled before 2 days then the whole money will be returned, and if
done one day before, then 15% is debited from the total amount and the remaining amount is
returned and if done on that day 30% is debited from the total amount and the remaining is to
be returned back. This action is also to be performed by the application alone. They want the
application to be maintained in different details like the buses and the bookings information.
When they try to book a ticket it should ask for the customer details like the name of the
customers for whom the tickets are booked, Date and Time, Starting and Destination place and
the age ( as the charges depends on the age). Also the Bus no. and the seat no. for which the
ticket (s) booked are to be entered so that they can keep track of the bookings done. Whenever
a customer enquires for the availability they can check through the Enquiry form where the
details like Destination Place, Starting Place, Date and Time are asked, by entering these details
(all fields are not mandatory) the availability details should be displayed. Also there should be a
search option through which the records of the customers and the buses can be known easily
with the same above options. After the ticket is booked, one should be able to print the ticket,
including the details like age, name, Date and time for which the ticket is booked and as well
the destination and Starting locations and the charges for the ticket including the taxes. The
application alone should be able to calculate the payments as per the age criteria and the
distance. Also it has to be updated in the site.
Note :
To book the ticket or to fetch the details (Search and Enquiry) first they need to
Login and only then they will be able to perform such actions.
This application is solely for the booking department to book the tickets and is
purely maintained by them. It is not applicable for the customers and they
(customers) cannot book the tickets online by themselves.
The Admin maintains the list of the buses and as well the Employees which
cannot be accessed by the Employee. The Employee can alone change his
Password from the booking window)
Non-Financial :
An online application needed to be developed which is to be solely used and maintained by the
booking department alone (regarding the bookings like booking, Enquiry and Updating and
canceling). It is implemented so as to automate the process. Also the total authority is taken
care of by the admin (Employee, Buses and charges)
6. Also for booking or to perform other actions one has to login with the username and the
password assigned.There will be a new, Update, Cancel, search buttons available on each page
with which the employee details The customer needed to visit to the booking to enquire or
book the tickets and he can collect the tickets in the bus alone. It also maintains a database that
consists of the list of buses along with the five digit code that will be assigned to each bus for
easy reference. Also the application should develop a unique six digit code whenever a new
employee detail is entered. Employee s personal, contact, age, qualifications etc are needed to
be collected. There will be an Enquiry form, Booking Form, and the also a page where the
search options will be available. Also the Price list is to be maintained separately, where one
can access the details of the price by entering the details of the Place of starting and
destination, age, number of seats, etc. The charges are as per the age, bus type and thedistance
and are to be maintained by the application alone.
Financial :
The charges vary depending on the type of the bus opted, distance of travel and as well the age
of the customer, which is to be calculated by the application alone. The price list can be
updated by the Admin alone. Also the Reimbursement of the amount will also be as defined by
the admin and is calculated by the application alone by considering the above parameters.
Functional Requirements :
1. The details of the buses, Price list, and Employee details are to be maintained and
controlled solely by the (Manager) Admin alone.
1. The Employer can change alone the password assigned to him.
2. Also first the employer needed to login first in order to perform the booking
actions.
3. Calculations of the charges and the reimbursements are to be implemented by the
application alone as designated by the Admin
4. The details of the buses and seats available are to be maintained and can be
updated regularly (of course only by the admin)
5. Enquiry form, Booking form and the pricing list are to be maintained in separate
pages.
6. 7. There should be new, update, cancel and search options available
7. TABLES
Table : busDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
busId int no 4 10 0 no (n/a) (n/a)
busRegNo varchar no 50 yes no yes
busType varchar no 20 yes no yes
busCapacity smallint no 2 5 0 yes (n/a) (n/a)
Table : cityDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
cityId int no 4 10 0 no (n/a) (n/a)
cityName varchar no 50 yes no yes
Table : customerDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
custId bigint no 8 no (n/a) (n/a)
custFirstname varchar no 100 yes no yes
custLastname varchar no 100 yes no yes
custDob datetime no 8 yes (n/a) (n/a)
custEmail varchar no 50 yes no yes
custAddress varchar no 100 yes no yes
custPhone bigint no 8 yes (n/a) (n/a)
Table : freqDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
freqId int no 4 10 0 no (n/a) (n/a)
mon int no 4 10 0 yes (n/a) (n/a)
tue int no 4 10 0 yes (n/a) (n/a)
8. wed int no 4 10 0 yes (n/a) (n/a)
thu int no 4 10 0 yes (n/a) (n/a)
fri int no 4 10 0 yes (n/a) (n/a)
sat int no 4 10 0 yes (n/a) (n/a)
sun int no 4 10 0 yes (n/a) (n/a)
Table : groupDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
groupId int no 4 10 0 no (n/a) (n/a)
groupName varchar no 100 yes no yes
permissionId int no 4 10 0 yes (n/a) (n/a)
Table : permissionDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
permissionId int no 4 10 0 no (n/a) (n/a)
userAdd smallint no 2 5 0 yes (n/a) (n/a)
userEdit smallint no 2 5 0 yes (n/a) (n/a)
userDelete smallint no 2 5 0 yes (n/a) (n/a)
travelAdd smallint no 2 5 0 yes (n/a) (n/a)
travelEdit smallint no 2 5 0 yes (n/a) (n/a)
travelDelete smallint no 2 5 0 yes (n/a) (n/a)
routeAdd smallint no 2 5 0 yes (n/a) (n/a)
routeEdit smallint no 2 5 0 yes (n/a) (n/a)
routeDelete smallint no 2 5 0 yes (n/a) (n/a)
busAdd smallint no 2 5 0 yes (n/a) (n/a)
busEdit smallint no 2 5 0 yes (n/a) (n/a)
busDelete smallint no 2 5 0 yes (n/a) (n/a)
groupAdd smallint no 2 5 0 yes (n/a) (n/a)
groupEdit smallint no 2 5 0 yes (n/a) (n/a)
groupDelete smallint no 2 5 0 yes (n/a) (n/a)
reservationRead int no 4 10 0 yes (n/a) (n/a)
reservationAdd int no 4 10 0 yes (n/a) (n/a)
reservationEdit int no 4 10 0 yes (n/a) (n/a)
reservationDelete int no 4 10 0 yes (n/a) (n/a)
reportRead int no 4 10 0 yes (n/a) (n/a)
9. enquiry int no 4 10 0 yes (n/a) (n/a)
userRead int no 4 10 0 yes (n/a) (n/a)
groupRead int no 4 10 0 yes (n/a) (n/a)
travelRead int no 4 10 0 yes (n/a) (n/a)
routeRead int no 4 10 0 yes (n/a) (n/a)
busRead int no 4 10 0 yes (n/a) (n/a)
Table :purchaseDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
purchaseId bigint no 8 no (n/a) (n/a)
custId bigint no 8 yes (n/a) (n/a)
purchaseAmt money no 8 19 4 yes (n/a) (n/a)
purchaseDate datetime no 8 yes (n/a) (n/a)
Table : reservationDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
custId bigint no 8 yes (n/a) (n/a)
travelId bigint no 8 yes (n/a) (n/a)
purchaseId bigint no 8 yes (n/a) (n/a)
resId bigint no 8 yes (n/a) (n/a)
resDate datetime no 8 yes (n/a) (n/a)
resNoOfSeat int no 4 10 0 yes (n/a) (n/a)
departureDate datetime no 8 yes (n/a) (n/a)
Table : routeDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
routeId int no 4 10 0 no (n/a) (n/a)
routeDistance bigint no 8 yes (n/a) (n/a)
routeFromId int no 4 10 0 yes (n/a) (n/a)
routeToId int no 4 10 0 yes (n/a) (n/a)
10. Table : travelDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
travelId bigint no 8 no (n/a) (n/a)
busId int no 4 10 0 yes (n/a) (n/a)
routeId int no 4 10 0 yes (n/a) (n/a)
travelDepartureTime datetime no 8 yes (n/a) (n/a)
travelArrivalTime datetime no 8 yes (n/a) (n/a)
travelFare money no 8 19 4 yes (n/a) (n/a)
travelFreqId int no 4 10 0 yes (n/a) (n/a)
Table : userDetail
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
userId bigint no 8 no (n/a) (n/a)
userFirstname varchar no 100 yes no yes
userLastname varchar no 100 yes no yes
userUsername varchar no 100 yes no yes
userPassword varchar no 100 yes no yes
userDob datetime no 8 yes (n/a) (n/a)
userGender varchar no 15 yes no yes
userDesignation varchar no 100 yes no yes
userEmail varchar no 100 yes no yes
userContactNo bigint no 8 yes (n/a) (n/a)
userAddress varchar no 100 yes no yes
groupId int no 4 10 0 yes (n/a) (n/a)
userJoinDate datetime no 8 yes (n/a) (n/a)