Bus Reservetion System.. help me please../

Reservation System

Page 1 of 1

1 Replies - 2018 Views - Last Post: 10 November 2008 - 11:27 PM Rate Topic: -----

#1 micouris   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 10-November 08

Bus Reservetion System.. help me please../

Posted 10 November 2008 - 10:57 PM

under my system analysis and design subject
we are required to do a project.
i chose the bus reservation system but im having a hard time coding my proposed system.
would anyone please help me?

this are te requirements:

The bus reservation system would allow any user to make a reservation and, eventually pay for the ticket. As a result, a reservation record is created and the user can select a seat. There are different models of buses therefore a bus configuration interface has to be created. Based on a particular bus configuration, an itinerary will be selected. There can be a variety of itineraries; therefore an Itinerary interface would have to be created.

A combination of an itinerary and bus configuration for a particular date is called a trip. Tickets can be bought for one way.

Bus Configuration

The Bus configuration interface would allow to enter the fleet of buses available for a particular company. The following are characteristics of buses:

1. Name
2. Number of seats.
3. Number of seats per row.
4. Has TV
5. Has Air Conditioning

Itinerary Configuration

The Itinerary configuration would allow to enter all the possible itineraries available for this company.
1. Identification (Kansas City, Laredo)
2. Start Day (Monday, Tuesday)
3. length (72 hours)
4. Stops (1 through 99)
5. Itinerary Stops
a. Stop Id (1,2,)
b. Stop City
c. Arrival Time
d. Departure Time
e. Trip Price

Trip File

The Trip File has information about each portion of an itinerary.

1. Id
2. From
3. To
4. Departure Date
5. Departure Time
6. Trip Length (Hours & Minutes)
7. Itinerary ID
8. Bus ID

Reservations File

The reservations File contains a reservation for each trip or combination of trips.

1. Record ID
2. Reservation Id
3. Trip ID
4. Client ID
5. Amount
6. Paid Amount
7. Paid Date
8. Receipt Number
9. Change Seat Approve


A client may make a reservation for a particular trip or several trips at the same time. There will be several records in the reservation file with the same reservation ID. There has to be a way to make sure that the seat will be available for the whole duration of the trip. If the passenger needs to change seats during the trip, a warning has to be displayed for the passenger to approve it.

Reservation Interface

The reservation interface will first display the itineraries for a departure date and time, the departure city and arrival city. The system will display an itinerary or a portion of itinerary. (i.e. for the itinerary Oklahoma City to Laredo with stops in Dallas, Austin, San Antonio), the passenger only wants to travel from Austin to San Antonio.

The system will search the trip database to select all records that stop in San Antonio and Austin with the same itinerary ID and will list the times.

The passenger will select one and continue to the seat assignment interface. If there are seats available for the entire segment that the passenger requests, only those seats will be displayed. If the seat has to change in the middle of the trip, it has to be marked in the seat assignment interface.

The seat assignment interface has to show graphically the layout of the bus.

Ajax has to be used as much as possible for this interface and also for the selection of the departure and arrival city.

There will be an opening and closing of day procedures based on the sales. Any standard procedure suggested will be accepted.

thank you

Is This A Good Question/Topic? 0
  • +

Replies To: Bus Reservetion System.. help me please../

#2 n8wxs   User is offline

  • --... ...-- -.. . -. ---.. .-- -..- ...
  • member icon

Reputation: 972
  • View blog
  • Posts: 3,878
  • Joined: 07-January 08

Re: Bus Reservetion System.. help me please../

Posted 10 November 2008 - 11:27 PM


This post has been edited by n8wxs: 10 November 2008 - 11:28 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1