Recursive relationship where one product (a package) is made up of one or more products.
If any product is included in a package, its package ID will contain the product ID of the package.
Products not included in a package contain null values in the PACKAGE_ID column.
Relationship: A customer buys zero, one, or many customer sales. A customer sale is purchased by one customer.
TOTAL_ITEM_AMOUNT NUMBER(10, 2)
TAX_AMOUNT NUMBER(10, 2)
TOTAL_SALE_AMOUNT NUMBER(10, 2)
SHIPPING_HANDLING_FEE NUMBER(5, 2)
Relationship: A customer sale includes zero, one, or many items purchased. A sales item is part of one customer sale.
SALES_ID and PRODUCT_ID
SALE_AMOUNT NUMBER(10, 2)
Relationship: A product can be a sales item in zero, one, or many customer sales. A sales item is always one product.
Relationship: A product that is a pet can have zero, one, or many log entries. A pet care log entry is always related to one product.