Given an example of a Customer Sales Order for REI, infer the logical Data Model (Schema) needed to support the document.

Follow these steps:

1. Form teams of 2-3.

2. Review the sample handout REI Sales Order.

IC1 - REI Sales Order.pdf Download IC1 - REI Sales Order.pdf

3. Design (or, actually, infer) a logical, normalized DB (a schema) for Sales Order information needed to support this printed order.

4. Your schema should show important segments (tables) and their relationships to each other. It should also extend to relevant master files.

5. For each segment, list/identify all primary keys, any foreign keys, and several important attributes.

6. Note that the sample document may not show all key information. That is, there may be important keys or attributes that are not printed on the order. Feel free to make assumptions about keys, attributes, etc.

KRET COOP ORDER & SHIPPING INFO ORDER DETAILS SHIPPING ADDRESS Order #:Y105681312 Member #:14816582 Shipping Method: Standard SHIPPING ADDRESS 1: John Q. Smith 123 Anywhere Drive Bugtustle, OK 12345 SHIPPING ADDRESS 2: Suzy Q. Smith 567 Somewhere Else Lane 'Tightwad, MO 12345 ITEMS ORDERED Swix, Nordic Standard Aluminum, BLACK, 130 cm, Unisex Item #1087150003 Item Price: $29.95 Qty: 1 Total: $26.95 Salomon, Siam 5 Prolink, LIGHT GREY/BLUE, UK 8, Women's Item #1091550008 Item Price: $95.00 Qty: 1 Total: $85.50 PURCHASE SUMMARY Subtotal: Shipping: Estimated Sales Tax: Discount Applied: Discount Applied: Discount Appliad: $112.45 $15.98 $8.51 $3.00 $9.99 $9.50 Order Total: $126.95 ESTIMATED PAYMENT SUMMARY MasterCard: $126.95 KRET COOP ORDER & SHIPPING INFO ORDER DETAILS SHIPPING ADDRESS Order #:Y105681312 Member #:14816582 Shipping Method: Standard SHIPPING ADDRESS 1: John Q. Smith 123 Anywhere Drive Bugtustle, OK 12345 SHIPPING ADDRESS 2: Suzy Q. Smith 567 Somewhere Else Lane 'Tightwad, MO 12345 ITEMS ORDERED Swix, Nordic Standard Aluminum, BLACK, 130 cm, Unisex Item #1087150003 Item Price: $29.95 Qty: 1 Total: $26.95 Salomon, Siam 5 Prolink, LIGHT GREY/BLUE, UK 8, Women's Item #1091550008 Item Price: $95.00 Qty: 1 Total: $85.50 PURCHASE SUMMARY Subtotal: Shipping: Estimated Sales Tax: Discount Applied: Discount Applied: Discount Appliad: $112.45 $15.98 $8.51 $3.00 $9.99 $9.50 Order Total: $126.95 ESTIMATED PAYMENT SUMMARY MasterCard: $126.95