Turn: using the car ticketing system to talk about Database Structure Design

Many of my friends hope that this PDM file can be put on the Internet. I have obtained this file for your learning and hope you can make common progress.
Download PDM:/files/wxj1020/sample.rar

I attended the advanced database training last week and felt that I had benefited a lot from the high level of speakers. The database design tool uses powerdesigner. This tool has never been used before and is not very familiar with it. It is very helpful for me to study it with examples. Now I have organized this part of information online so that beginners can learn like me.

The requirements of the ticketing system are analyzed as follows:

Introduction

The ticket sales system is mainly used for daily ticket handling at the station. The ticketing system is the main source of data in the station information management system. Its business directly affects the finance, ticket checking, and scheduling systems. The ticket sales system provides functions such as ticket sales, remote ticket sales, invalid tickets, cancel invalid tickets, change tickets, refund tickets, cancel refund functions, make up tickets, query tickets, and fill in tickets.

Description

Ticket sales

All trains and tickets on this site will be sold normally and printed as required.

Remote ticket sales

All trains and tickets are sold normally at the remote station and printed out as required by the remote station.

Invalid ticket

During normal ticket sales, tickets may be voided due to incorrect operations or printing of mechanical faults.

Cancel invalid ticket

When the ticket is canceled, it is found that the ticket is not abolished, that is, the ticket is normal.

Remote Toll Collection

Processing of void tickets for sold remote tickets.

Refund

Return the ticket within the normal refund time, and charge a certain amount of service fees according to the refund rules.

Remote refund

Refund the sold remote ticket.

Cancel refund

When a refund is returned, it is found that the refund should not be returned, that is, the normal ticket, you need to cancel the refund.

Change ticket

For a passenger or station, you must change the number of times for the sold ticket. Only one change is allowed.

Remote Change ticket

Change the sold remote ticket.

Cancel ticket

Delete some ticket records used by the debugging program and their impact.

Pass-

It can only be carried out after the ticket sales time limit is exceeded, and before the departure, pay attention to the handling of non-microcomputer ticket tickets (for example, scissors ticket) in statistics ).

Ticket sales Query

With a certain amount of authorization and configuration, the conductor can query the sales, cancellation, change, and refund of tickets within the specified time range or before the number of tickets, the service can be used to accumulate bills for persons with permissions.

Bill settlement

After the ticket is sold out every day, the conductor enters the daily settlement form for financial personnel to query.

Relay ticket

During normal ticket sales, the ticket may be re-printed due to incorrect printing due to mechanical faults or other reasons.

Ticket sales type

(1The format and content of the printed face.

All stations use a ticket format. Tickets are in the Primary and Secondary Contact format. The secondary contact is not used for automatic bar code inspection, when you purchase a ticket, the model of the ticket is subject to the settings of the station where the train count is located.

Ticket Style

A ticket has a forward Association (a passenger is used as a travel credential) and a pair of one or two links (a ticket is generated at a station without automatic ticket check and reconciliation with the ticket conductor ). All the information in the ticket shall be the vehicle count, start and end site, fare, departure date and time, and the information specific to the ticket conductor's employee ID, Ticket Gate, whether to change the ticket, and the information on the ticket: the inherent ticket number, the computer-printed ticket number, and the ticket code (only used for automatic ticket inspection stations ).

The secondary link can be printed or not printed according to system settings, and the barcode can be printed or not printed (or printed directly) According to system settings.Click ).

(2) Ticket type

1) normal shift Ticket: the one-day or pre-sold normal shift ticket for sale.

2) remote ticketing: the ticket for the sale of remote station trains is printed in the same format as that for remote stations.

3) flow Ticket: the flow ticket for sale.

4) Refund and change:

Refund is divided

A. Normal refund. Refund within the refund time specified in the handling standard.

B. forcibly return the ticket. After the time limit is exceeded, the ticket is forcibly returned.

Pass-:A pass-by ticket can only be made after the ticket time limit is exceeded and must be made before departure.

Ticket Booking:Set the validity period of the ticket, reserve the seats within the validity period, and release the seats outside the validity period.

Ticket Type Definition

① Full price ticket

② For a half-price ticket, you can set the available flag and define the name as needed.

③ Free of charge: only available logos can be set.

④ Discount tickets 1-3 allow you to set available logos and define names freely.

⑤ Discount tickets give discounts based on the original fare and have strict permission control.

Ticket attributes

Whether the station ticket type to which the train fare belongs is changed to the ticket status, whether to reserve a non-flow fare, whether the non-change fare has been sold, not reserved, the ticket to be previewed is a long-distance ticket, half-pass change, the ticket has been refunded, the reserved ticket is free of charge, and the discount ticket 1-3 has been changed to the discount ticket window.

You can separate and combine the ticket window, refund window, and refund window by setting permissions and modes.Ports are separated.

Overall Function Structure

According to the above requirements, the design entities are as follows:(If you want to use powerdersigner to design a database, do not read the following content for the moment ):

The design table is as follows:

Create a database based on The TSL model:

I hope this part of information will be helpful to some beginners.