Description of the illustration cachegroupover.eps

The image shows the customer (root table), orders and order_item cache tables in the customer_orders cache group with the following rows:

customer (root table):

cust_num  region   name            address
     122  West     Jim Johnston    231 Main, Needles CA 92363    
     342  West     Jane Stone      4223 Cowper,Palo Alto CA 94302   
     663  Midwest  Mary J. Warren  673 State, Madison WI 53787

orders:

ord_num  cust_num  when_placed  when_shipped
  44325       122      10/7/07       10/7/07
  65432       122      8/24/08       8/27/08
  76543       663       4/2/09        4/8/09

order_item:

ord_num  prod_num  quantity
  44325  SD07             1
  44325  TR3A             5
  65432  FT094            1
  76543  SD07             2

End of description.