1

Topic: Booking of Bus Excursion

All greetings. Council of clever people is necessary. I write an aaplet by request of excursions. There was a necessity to make something of type of bus booking to these excursions. Is to three table in a DB: Clients, excursions, buses. The bus is anchored to each excursion with N th amount of seats. I can not think, as it is better to implement it.  who met any similar examples

2

Re: Booking of Bus Excursion

triamera977 wrote:

I can not think, as it is better to implement it.

And in what a problem to reduce an amount of accessible seats at booking?

3

Re: Booking of Bus Excursion

triamera977;
Than place booking differs from ticket sale (with its possible reset later)?

4

Re: Booking of Bus Excursion

Dimitry Sibiryakov;
Further it certainly too it to be necessary. But I stuck at the initial stage. I can not think, for example at adding of the new bus about basis how to write down places, rows. That further it was possible to plant for example the client on the selected place...
There is an example from a site... On the first screen there is a bus.

5

Re: Booking of Bus Excursion

6

Re: Booking of Bus Excursion

triamera977;
http://www.sql.ru/forum/db-design

7

Re: Booking of Bus Excursion

Funny....
Where Kaliningrad, and where Pleasant, Moscow:-D

8

Re: Booking of Bus Excursion

Buses (the name and characteristics, type, whether are the second floor, whether there is an air conditioner, capacity)
Allocation of numbers (the bus, number and characteristics of places, type, a floor, at pass, at a window)
Flights (the name, date, the bus, whence-where)
The sold tickets for flight (number, the price to whom sold)
If single clients - the data on them it is possible to write that directly at design/booking in tickets, i.e. the sense in the separate table is not present.

9

Re: Booking of Bus Excursion

Allocation of numbers is one number registers in basis one record. And in the interface at creation of the new bus it is already possible to add buttons for fast adding of n th amount of places. Not on one to import.

10

Re: Booking of Bus Excursion

triamera977 wrote:

Dimitry Sibiryakov;
Further it certainly too it to be necessary. But I stuck at the initial stage. I can not think, for example at adding of the new bus about basis how to write down places, rows. That further it was possible to plant for example the client on the selected place...
There is an example from a site... On the first screen there is a bus.

On a screen - buses generally can be two-floor, and there at the first and the second a floor different plans will be
Total - to begin with undressed entities.
If speech about "Booking of Bus Excursion" - stupidly you sell the ticket and you put it in queue on recheck. If about one hour  it is not redeemed - you remove  and you return in sale.
E speech about "That further it was possible to plant for example the client on the selected place" - that simply tables
1) "flight number" - "date-time" - "route number" - "bus number" or "bus model"
2) "flight number" - place number (linear, from 1 to Max at this model of the bus) - ID the buyer-passenger - on taste sign of temporal pre-sale (armor), number of the sold cash register and other possible signs
If speech about drawing of beautiful plans... That it already the third task:-D
It is possible to be played with XLS-tables either with HTML tables or with a SVG-drawing
Only I finally wrote to a DB not "rows", and each place separately. A floor, and TRect

11

Re: Booking of Bus Excursion

JaDi wrote:

the Sold tickets for flight (number, the price to whom sold)

The price, it appears, is written in advance, even before sale
And it is normal on weigh flight at once, all places equally stand

12

Re: Booking of Bus Excursion

Arioch;
I do not know into the account of buses, and here at  tickets for trains stand differently, and there also on time depends, and not just from a location in a coach. Without speaking already about discounts everyones and to that similar buns and bonuses.

13

Re: Booking of Bus Excursion

Surrenders to me that to term paper  this all has no relation.

14

Re: Booking of Bus Excursion

triamera977 wrote:

Is to three table in a DB: Clients, excursions, buses.

These are reference manuals.
And now the label  Armorings is necessary: what client, what excursion and by what bus

15

Re: Booking of Bus Excursion

triamera977 wrote:

I can not think, for example at adding of the new bus about basis how to write down places, rows.

It is necessary a label describing places in the bus

16

Re: Booking of Bus Excursion

All thanks. I will understand.
Arioch, Pleasant not only is in Moscow. In the Kaliningrad region there is a resort settlement. smile

17

Re: Booking of Bus Excursion