A
Project Presentation On
Online Bus Booking System
Submitted By
Barot Alok T. 13084231001 Dayani Yash K. 13084231033 M.Sc. (CA & IT) Semester-III
Internal Guided By Amit B. Suthar
Submitted to
Department of Computer Science,
Ganpat University, Ganpat Vidyanagar - 384012
Sr. No
Title
1 Project Profile 2 Existing System
3 Need for New System 4 Function Specification
5 Hardware &Software Requirements 7 System Flowchart
8 Timeline Chart 9 E-R- Diagram
10 Use case Diagram 11 Activity Diagram 12 Class Diagram 13 Sequence Diagram 14 Collaboration Diagram 15 Data Dictionary
INDEX
Sr. No
Title
16 Input design 17 Out put design 18 Testing
19 Post implementation review 20 Future enhancement
Project-Profile
Project title:- Online Bus Booking System
Objectives:- Customer can easy book their Tickets And Cancel
Choice and provide Information about Bus.
Front End Tool:- Asp.net with c# Framework3.5
Back End Tool:- Sql Server 2005
Type Of Application:- Web Application
Internal Guide : Mr. Amit B. Suthar
Time Duration:- 90 days
Existing System
•
The work is done manually.
•
Those who are interested in inquiring about the Bus Type, its Tickets
Price, available seats, facility of the bus etc. has to walk to the
Booking office.
•
This creates a huge Relief for the Customer of the Office on
weekends to save their time.
•
A new system is helpful to both employees as well as the
customers.
•
New system provides help to the customer as they can inquire
about the Bus model, its Ticket price, available Seats, facility of
the bus etc. and they don’t need to walk to the office.
•
There is login and password service for employee and Regular
customers to use this system .
FUNCTIONAL SPECIFICATION
•
This Project basically provides a Bus information and
regarding bus information .
•
First of all, in our website any user or visitor are view our
system and also search the bus and how many seats are
available in our buses.
•
user can also registered its own seats in bus this website .
User can post a comment on different Bus Services.
But user can compulsory registered first in the system.
•
Search Bus category wise .
•
In this system admin can maintain all the Bus information and
also maintain Bus category , comments etc.
•
In this system admin can maintain the registered users ,
manage news ,and also admin can generates a reports and
manage the whole system .
MODULE SPECIFICATION
Login:
Login Module includes various utilities like User
Authentication, Change Password and Forgot Password.
Registration:
In this website provide a some facility user can Registered in
this website. user can use this facility so user can make a
registration
.
Book the Ticket:
In this module admin can add new bus category using this
module. Bus Category contains like Volvo, Slipper coach, Ac
Coach etc.
10
Update Bus Information:
In this module admin can add or Update Bus using this module.
It contains the information about the Bus type , photo,
description, Location of tour, Available Seats in Bus etc.
Cancel the Booking Ticket:
In this Module User can Cancel the booking Ticket.
Comments:
In this Module User can Post the Comment on a particular Bus .
Report Generation:
Hardware Requirement(Minimum)
Processor
1 GHZ
RAM 2 GB
Disk Space 10 GB Of Free Space
Minimum Server Requirement :
Minimum Client Requirement :
Processor 2 GHZ
RAM 1 GB
Software
Requirement(Minimum
)
Server Software Requirement :
Operating System
Windows server 2003
Web Server
Front End
Back End
IIS 6.0
ASP.NET with c#
SQL Server 2005
Client Software Requirement :
Operating System
Windows Xp or Any
equivalent OS
Web browser
Internet Explorer 6.0 or
Any compatible Browser
START
Yes
Login
Valid UserId & Password
ADMIN User
A B
Registration
System Flow Chart
no C VISITOR Is Admin ? View Website If Register ? no Yes Yes no
A B
View Bus information
STOP Update Bus Information
View Booking details
Cancel the Booking Ticket
Log out
Book the Ticket Receive Payment Information C Manage comment Post comment Generate Reports
Days
0 15 30 45 60 75 90 12 15 18 25 11 9 Preliminary InvestigationReq. Gathering & System Analysis
System Designing Coding Testing Implement & Deployment A C TI VI T Y
Timeline Chart
Admin User Bus_Master View View Booking_Master Manage Manage M M Can M M 1 1 1 1 Reg_id Bus_id Book_id
ER Diagram
1 M City price Mobileno Select Bus Username Feedback View Can 1 M M 1 F_id Reg_idReg_MASTER
No Field Name Data type Constraint Description
1 Reg_id Int Primary Key It store Registration id.
2 First_Name Nvarchar(30) Not Null It store Customer First Name. 3 Last_Name Nvarchar(30) Not Null It store Customer Last name. 4 Email_id Nvarchar(20) Not Null It store the Email_id.
5 Address Nvarchar(20) Not Null It store customer Address.
6 City Nvarchar(20) Not Null It store customer city.
7 Pincode Nvarchar(6) Not Null It store customer Pincode.
8 ContactNo Numeric(10) Not Null It store customer Contactno
Description: The information about Registration of costumer Primary Key : Reg_id
Foreign Key :
-Data Dictionary
:-LOG_MASTER
No Field Name Data type Constraint Description
1 u_id Int Primary Key It is store User ID 2 Username Nvarchar(30 ) Not Null It store Username. 3 Password Nvarchar(20) Not Null It store Password.
4 Type Nvarchar(10) Not Null It store Type of admin or user.
Description: The information about Login. Primary Key : U_id
Foreign Key :
:-Booking_MASTER
No Field Name Data type Constraint Description
1 Book_id Int Primary Key It store Booking id
2 Reg_id Int Foreign Key Give references to Reg_master 3 Bus_id Int Foreign Key Give references to Bus_master 3 Fname Nvarchar(20) Not null It store First Name .
4 Lname Nvarchar(20) Not null It store Last Name 5 Email Nvarchar(20) Not Null It store E-mail id. 6 Contactno Numeric(10) Not Null It store Mobile no.
7 Address Nvarchar(20) Not Null It store customer Address. 8 City Nvarchar(20) Not Null It store City.
9 SeatNO Nvarchar(20) Not Null It store Bus seat no. 10 Date Nvarchar(20) Not Null It store Travelling date.
Description: The information about Booking Ticket detail Primary Key : Book_id
Foreign Key : Reg_id , Bus_Id
:-Bus_MASTER
No Field Name Data type Constraint Description 1 Bus_id Int Primary key It store Bus id.
2 BusNumber Nvarchar(20 ) Not null It store Bus Number. 3 BusType Nvarchar(20) Not Null It store Bus Type.
4 TotalSeat int Not Null It store Total Seat of Bus. Description: The information about Bus Ticket price.
Primary Key : Bus_id Foreign Key :
:-Feedback
No Field Name Data type Constraint Description
1 F_id Int Primary Key It is store Feedback ID 2 Username Nvarchar(30) Not Null It is store Username 3 Feedback Nvarchar(30 ) Not Null It store Feedback.
4 Date Nvarchar(20) Not Null It store Date of given Feedback
Description: The information about Feedback. Primary Key : -F_id
Foreign Key : Reg_id
Description:- This is the Home page of user ,Admin and Visitor.
Home page
Description:- in this page visitor serch the bus details
Visitor search page
Description:- This is the login page for user and Admin
Login page
Description:- when user enter wrong password then the error occur.
Login page
Description:- This is the the Registration page .
Registration page
Description:- User & Admin Forget Password Then Reset Password.
Reset Password page
Description:- This is the login page for Admin side and user side
Login page
Description:- This is the home page for Admin
Admin home page
Description:- This is the Admin can Add bus schedule.
Bus schedule
Description:- This is the Admin can Add Bus .
Add Bus
Description:- This is the Admin can Add the pickup stand.
Pickup stand
Description:- This is the page news update by Admin.
News update
Description:- Admin can change the password.
Change password
Description:- Admin can manage User details.
View user details
Description:- Admin can manage feedback
View feedback
View report
Description:- This is the Home page of user.
Home page for user
Description:- Use can change the password.
Change password page
Description:- user can search the bus and see time schedule .
Search bus page
Description:- user can select the seat and pickup stand.
Reservation page
Description:- Reservation confirm page .
Reservation confirm page
PayPal page
Description:- User can print the ticket
Ticket print
Description:- user can give feedback
Feed back page
Update password
Description
:-
Admin can view Bookreport
Description
-
Admin can view registration report
TESTING
Unit
Testing:-This is the testing process which we can do manually because in this testing program is a tested individually using dummy record to see whether that program produce satisfied output as the company and validation also.
Validation
Testing:-In this requirements established as part of software requirements analysisare validated against the software that has been constructed. Validation testing provides finalnAssurance that software meets all functional, behavioural and performance requirements. Validation can be define in many ways but a simple definition is that validation succeeds when software Function in a manner that can be reasonably by the customer.
1. Validation test criteria 2. Configuration review
System
Testing:-System testing is actually a series different test whose primary purpose is to full exercise the computer base system .Where the software and other system elements are tested as whole .To test computer software ,we spiral out along streamlines that broadens the scope of testing with each turn.
The last higher-order testing step falls outside the boundry of software Engineering and in to the broader context of computer system engineering.Software,once validated,must be combining with order system Elements(e.g.hardware,people,databases).System testing verifies that all the elements Mesh properly and that overall system function/performance is achieved.
1.Recovery Testing 2.Security Testing 3.Stress Testing
Admin Cases:
Case ID Test case Expected Output Actual Output Pass/Fail Remarks
01 Login Test Login with proper details
and role. Successfully Pass Good
02 Managing details
Manage information
properly stored successfully Pass Good
03
Add &update Bus information
Add &update Bus info
properly successfully pass Good
04 Exception Handling
Proper error message
should display. Not Successfully Fail Poor
05
View tickets booking information
View booking info properly Successfully pass Good
06 View Payment information
View payment request
properly successfully pass Good
Register Customer Test Cases:
Case ID Test case Expected Output Actual Output Pass/Fail Remarks
01 Login Test Login with proper details Successfully Pass Good
02
Register Information
Proper Register with
exception handling Successfully Pass Good
03
View bus Information
Proper Bus Information Successfully Pass Good
04
search information
Search information
Properly Successfully Pass Good
05
Book Ticket Information
Book bus tickets
Post Implementation Review
After the system is implemented and conversion is completed a review of system is usually conducted by user and analyst. This is called post implementation review.
The most fundamental concern post implementation review to determining whether the system has met its objective; that is analysts want to know if the performance the performance level of improved and if the system is producing the result intended .If neither is happening ,one may question whether the system can be considered successful
The new system needs less manpower, provide facility for Book Tickets and Latest News for bus information.
Future Enhancement
We think that not a single project is ever considered as complete forever.Because our mind is always thinking something new and our necessities also are growing day by day.We always want something more than what we have.Our application also ,
If you see at the first glance then you find it to be complete but we want to make it still mature and fully automatically.
The future perspective of our project can linking our booking system with other centralized bus services so that user has an ease of booking and travelling. Other then this for long route journeys food facility and its variety can be added.
With the use of GPS every traveler can get advance map of route to be followed during journey.
Making a mobile app for the user is also a first step development.
Bibliography
During the development of our system, we have taken the reference from Books and journals, which we would like to mention in this section.
These books acted as our tutors during the system development..
•ASP.NET UNLEASHED Stephen Walther • ASP.NET WITH C# Shyam N. Chawda
Besides these we were referring the online manuals from the sites.
www.google.com www.GSRTC.com www.neeta.com www.gujrat.com
