This is a description of example1.gif.

The western_customers cache group contains the following cache tables: active_customer (root table), ordertab, cust_interests, orderdetails.

The active_customer cache table contains the following columns: custid, name, addr, zip, region.

The ordertab cache table contains the following columns: orderid, custid.

The cust_interests cache table contains the following columns: custid, interest.

The orderdetails cache table contains the following columns: orderid, itemid, quantity.

End of description.