M5A2 Chapter 9 Apply Your Knowledge: Working Shoes Working Shoes is a multistate shoe store that offers an extensive selection of casual and dress shoes designed for men and women who work on their feet. Working Shoes plans to launch a new Web site, and the company wants to develop a new set of product codes. Currently, 250 different products exist, with the possibility of adding more in the future. Shoes and many accessories come in various sizes, styles, and colors. Tasks: 1. Design a code scheme that will identify each specific product and its characteristics. Keep in mind that products include shoes and accessories. Explain the structure of your code scheme (30 points) and give 5 examples of product codes (10 points). 2. Design a code scheme that will identify each specific customer. Explain the structure of your code scheme (20 points) and give 5 examples of customer codes (10 points). 3. Design a code scheme that will identify each specific order. Keep in mind that an order can be for multiple different products. Explain the structure of code scheme (20 points) and give 5 examples of order codes (10 points). When designing your code schemes make sure you follow the guidelines from section 9.7.3 Designing Codes: 1. Keep codes concise: do not create codes that are longer than necessary 2. Allow for expansion: allow for reasonable growth in the number of assigned codes 3. Make codes unique: codes used for identification purposes must be unique to have meaning 4. Make codes meaningful: codes should be easy to remember, user-friendly, convenient, and easy to interpret 5. Keep code structure consistent: If you use 3 letters to encode the color for shoes, you should also use 3 letters to encode the color for accessories your Analysis: Personal Trainer Inc