Management Plan for AGS Project
Main Data Structures and Algorithms
Main Data Structures and Algorithms
Data Structures:
The batch processing subsystem maintains tables that track information about everything the gas station does. The following tables and related fields are maintained by the batch processing subsystem and are used to generate the reports and supply information to the interactive login subsystem:
Transactions - This table keeps track of all the transaction information submitted by the pumps.
The table contains the following fields:
Date/Time of transaction
ID of Pump from which gas was pumped
Type of gas (obtained from list)
Quantity of gas (in litres)
Price/litre charged for transaction
Tax percentage charged per transaction
Total tax amount charged for the transaction
Customer's first and last name
Credit card type and account number
We would like the total of the transaction as well.
Deliveries - This table records all delivery information.
Date and time of delivery ID/Name of delivery person Type of gas delivered ID of tank gas was delivered toNumber of litres added to tank
We would also like to know the total street value of the fuel delivered.
Statistics -
Current prices for each type of gas
Current tax rate
Quantity of gas currently in each tank
Credit Cards - This table tracks credit cards that were refused authorization.
The table contains the following fields:
Status of card
Action taken
Name of Customer
Credit card number
Plus the name of the credit card company or bank.
Algorithms:
The batch processing subsystem generates reports in the following way. First it searches through the table adding each record to the report it is generating. Once a report has been successfully generated the current table is backed up to another location and renamed with the date and time of the generated report. Then an empty table is created in it's place that is used to track information for the next report.
Send Comments to
This is essentially right, but it must be able to handle the possibility
of a sale being in progress when the report is generated.
Last Updated on 1/20/97
By Carey Dean Bingham
Email
