Transaction Processing System (TPS) Sales Data

This document contains detailed transaction data from a Transaction Processing System (TPS) including customer IDs, dates, receipt numbers, order numbers, product details, quantities, unit prices, and totals. The data spans multiple dates and includes information about sales transactions for various products.

• Transaction Processing
• Sales Data
• TPS
• Customer Transactions
• Product Details

scranton_c Follow

Uploaded on Sep 21, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. TPS

2. Input Data

3. (TPS) Cust Id. 001 Cust Id. Date 001 16/01/2019 16/01/2019 Date Receipt No. Order No. 1 2 3 4 5 F16012019G300001 Receipt No. Order No. 8:00 Time Unit Price 20.00 60.00 60.00 10.00 12.00 8:10 F16012019G300002 Product Id Product Name Qty Time Unit Price Product Id G003 Bread G001 Beer G015 Milk G004 Candy G005 Coke Product Name Qty Total Total 1 2 1 1 1 20.00 120.00 60.00 10.00 12.00 222.00 1 2 20.00 40.00 G003 Bread 2 3 60.00 180.00 G001 Beer 3 1 60.00 60.00 G015 Milk Total 280.00 Total Cust Id. 001 Cust Id. 001 17/01/2019 Date 17/01/2019 Date Receipt No. Order No. Receipt No. Order No. F17012019G300001 8:10 F17012019G300002 Product Id Time Unit Price 8:00 Time Product Name Produc t Id Product Name Unit Price Qty Total Qty Total 1 5 20.00 100.00 G003 Bread 1 3 20.00 60.00 G003 Bread 2 1 10.00 10.00 G004 Candy 2 2 10.00 20.00 G004 Candy 3 5 12.00 60.00 G005 Coke 3 1 12.00 12.00 G005 Coke 170.00 Total 92.00 Total

4. 1 Cust Id. 001 16/01/2019 Date 8:00 Receipt No. F16012019G300001 Time Order No. ProductId ProductName Qty Unit Price Total 1 1 20.00 20.00 G003 Bread 2 2 60.00 120.00 G001 Beer 3 1 60.00 60.00 G015 Milk 4 1 10.00 10.00 G004 Candy 5 1 12.00 12.00 G005 Coke 222.00 Total

5. 2 Cust Id. 001 16/01/2019 Date Receipt No. 8:10 F16012019G300002 Time Order No. 1 2 3 ProductId ProductName Bread Beer Milk Total Qty Unit Price Total 2 3 1 20.00 60.00 60.00 40.00 180.00 60.00 280.00 G003 G001 G015

6. 3 Cust Id. Date Time 001 17/01/2019 8:00 Receipt No. F17012019G300001 Order No. 1 2 3 ProductId ProductName Bread Candy Coke Total Qty Unit Price Total 3 2 1 20.00 10.00 12.00 60.00 20.00 12.00 92.00 G003 G004 G005

7. 4 Cust Id. Date Time Unit Price 001 17/01/2019 8:10 Receipt No. F17012019G300002 Order No. 1 2 3 ProductId ProductName Bread Candy Coke Total Qty Total 5 1 5 20.00 10.00 12.00 100.00 10.00 60.00 170.00 G003 G004 G005

8. ( TPS) Table: Sales ReceiptNo(Pk) F16012019G300001 16/01/2018 F16012019G300002 16/01/2019 F17012019G300001 17/01/2018 F17012019G300002 17/01/2019 12 100 20000 30 Table: Product ProductId(Pk) ProductName Price BalancedQty Date Time CustomerId TotalNo 8:00 001 8:10 001 8:00 001 8:10 001 222 280 92 170 G001 Beer 60 100 G002 Blanket 200 100 G003 Bread 20 40 G004 G005 G006 Candy Coke Computer 10 100 Table: SalesDetail ReceiptNo(Pk) F16012019G300001 F16012019G300001 F16012019G300001 F16012019G300001 F16012019G300001 F16012019G300002 F16012019G300002 F16012019G300002 F17012019G300001 F17012019G300001 F17012019G300001 F17012019G300002 F17012019G300002 F17012019G300002 Product (Pk) G003 G001 G015 G004 G005 G003 G001 G015 G003 G004 G005 G003 G004 G005 Qty G007 Cookie 40 100 G008 Diaper 150 100 1 2 1 1 1 2 3 1 3 2 1 5 1 5 G009 Egg 20 100 G010 Green Tea 20 30 G011 Make up 200 30 G012 Meat 190 50 G013 Medicine 290 100 G014 Microwave 3000 100 G015 Milk 60 100 G016 Printer 2000 100 G017 Shampoo 60 40 G018 Telephone 30000 100 G019 Television 20000 40 G020 Water 12 120

9. Table: Product ProductId(Pk) ProductName G001 G002 G003 G004 G005 G006 G007 G008 G009 G010 G011 G012 G013 G014 G015 G016 G017 G018 G019 G020 Price BalancedQty Beer Blanket Bread Candy Coke Computer Cookie Diaper Egg Green Tea Make up Meat Medicine Microwave milk Printer Shampoo Telephone Television Water 60 100 100 40 100 100 30 100 100 100 30 30 50 100 100 100 100 40 100 40 120 200 20 10 12 20000 40 150 20 20 200 190 290 3000 60 2000 60 30000 20000 12

10. Reference https://www.slideshare.net/cc_npru/entity-relationship-74406529