Scribd
Upload
474 views5 pages

Bus Ticket Management System Overview

The document describes a bus ticket management system database project created by 5 group members. It includes tables to store data on buses, routes, schedules, fares, passengers and ticket sales. The system uses queries and reports to provide operators real-time data on seat availability, ticket sales and passengers. It can also generate reports, send notifications and integrate with other systems to improve efficiency and the passenger experience.

Uploaded by

Mr Fisher
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
474 views5 pages

Bus Ticket Management System Overview

The document describes a bus ticket management system database project created by 5 group members. It includes tables to store data on buses, routes, schedules, fares, passengers and ticket sales. The system uses queries and reports to provide operators real-time data on seat availability, ticket sales and passengers. It can also generate reports, send notifications and integrate with other systems to improve efficiency and the passenger experience.

Uploaded by

Mr Fisher
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Page |1

Bus Ticket
Management System

Introduction to Database
Section – D

GROUP MEMBERS :

NAME ID CONTRIBUTION
1.Safkat Khan 22-46392-1 20%

2. Fahim Foysal 22-47824-2 20%


3.Sajjad Hossain Tushar 21-44969-2 20%

4.Safwan Bin Nayeem 22-47555-2 20%

5.Kamruzzaman 21-44701-1 20%


Page |2

Contents
Topic Page

1. Introduction 3
2. Scenario Description 4
3. ER Diagram 5
Page |3

Introduction

The bus ticket management system database typically includes tables for
storing data related to buses, routes, schedules, fares, passengers, and
ticket sales. The system uses queries and reports to provide bus
operators with real-time information on seat availability, ticket sales,
and passenger information, allowing them to make informed decisions
about scheduling and operations.

In addition to managing and storing data related to ticketing and


operations, a bus ticket management system in a database may also
include features for generating reports, sending notifications, and
integrating with other systems, such as GPS tracking or online payment
gateways. These features can help bus companies improve their
operational efficiency and provide a better experience for their
passengers.

Overall, a bus ticket management system in a database can provide bus


companies with an effective way to manage and track ticket sales and
operations, improve efficiency, and provide a better experience for
passengers.
Page |4

Scenario Description

In our bus ticket management system, a user can


book many tickets. One ticket can be used by
just one passenger. A user is identified by id.
Name, phone number and address are also
stored for user. Address is composed of house
number, street number and city. A ticket is
identified by id as well. Price, departure date and
validity period for the ticket is stored as well. A
passenger is identified by id and the name is also
stored. Tickets have different categories. Each
category has bus type and seating type.
Category is identified by class. While booking the
transaction date and is stored.
Page |5

ER Diagram

You might also like