Java Reference
In-Depth Information
through a third-party data provider. The following attributes will
be included in the CUSTOMER table:
CUSTOMER
id
name
address
city
state
zip
age
gender
income
education
occupation
years_at_residence
household_size
The PURCHASE table contains past purchases of products for each
customer. There is a unique transaction identifier for each separate
purchase by a customer and a given transaction may have included
one or more products. The PURCHASE table also records how many
of a given item were purchased in the transaction.
PURCHASE
customer_id
transaction_id
product_id
quantity_sold
The PRODUCT table contains a list of products sold by DMWhizz,
identified by a specific product identifier, and being sold for a
specific price.
PRODUCT
product_id
product_name
product_price
Search WWH ::




Custom Search