Apply Your Knowedge4

Western Wear Outfitters

Situation:
Western Wear is a mail-order firm that offers an extensive selection of casual clothing for men and women. Western Wear plans to launch a new Web site, and the company wants to develop a new set of product codes. Currently, 650 different products exist,
with the possibility of adding more in the future. Many products come in various sizes, styles, and colors. The marketing manager asked you to develop an individualized product code that can identify a specific item and its characteristics. Your initial reaction is that it can be done, but the code might be fairly complex. Back in your office, you give the matter some thought.

1. Design a code scheme that will meet the marketing manager’s stated requirements.

2. Write a brief memo to the marketing manager suggesting at least one alternative to the code she proposed, and state your reasons.

3. Suggest a code scheme that will identify each Western Wear customer.
I would suggest that ach customer would hav it's own ID number ang that has W on starting number to identify that they are a customer of Western Wear.

*See table below*

4. Suggest a code scheme that will identify each specific order.
i would suggest that each product has distinct code and the number of quantity. 

*See table below*