Petstore Database  

SALE_HEADER Table

SALE_HEADER Table
SALES_ID CUST_ID DETAIL_TOTAL TAX_AMOUNT SHIPPING_AMOUNT SALE_TOTAL SALES_DATE DETAIL_NEST: (PRODUCT_ID, ITEM_QTY, DETAIL_AMOUNT)
22 1 89.45 3.58 15 108.03 01-MAR-2010 21
1
78
4
1
5.15
33 25 40.45 0 0 40.45 02-JAN-2009 2
1
15.5
34 26 38.99 1.17 12.5 52.66 14-JUL-2009 8
1
29
10
1
3.5
16
1
4.5
15
1
1.99
35 1 55 1.65 5.25 61.9 12-DEC-2009 20
1
55
36 26 17.3 .87 2.3 20.47 29-FEB-2010 14
1
6.5
18
1
5.65
4
1
5.15

I am running a pet store and building a corresponding database consisting of tables. SALES_ID, CUST_ID, DETAIL_TOTAL, TAX_AMOUNT, SHIPPING_AMOUNT, SALE_TOTAL, SALES_DATE DETAIL_NEST: (PRODUCT_ID, ITEM_QTY, DETAIL_AMOUNT)