TABLE 1: The Original Product Table, Which Contains High Levels of Redundant Data
Product Code Catalog Number Product Description Product Size Product Color Unit Price Reorder Point
1 PP44888 Sweater, lady's crewneck M 10-12 Pink $22 14
2 PP44888 Sweater, lady's crewneck M 10-12 Pale Blue $22 20
3 PP44888 Sweater, lady's crewneck M 10-12 White $22 25
4 PP44888 Sweater, lady's crewneck M 10-12 Lavender $22 10
5 PP31040 Shirt, men's chambray S 34-36 Cabin Red $28 12
6 PP31040 Shirt, men's chambray S 34-36 Sage $28 15
7 PP31040 Shirt, men's chambray M 38-40 Cabin Red $28 15
8 PP31040 Shirt, men's chambray M 38-40 Sage $28 20
9 PP36901 Slacks, lady's linen blend 10R Black $30 14
10 PP36901 Slacks, lady's linen blend 10R Golden Tan $30 12
11 PP36901 Slacks, lady's linen blend 10R Lagoon Blue $30 10
12 PP36902 Slacks, lady's linen blend 10L Black $30 14
13 PP36902 Slacks, lady's linen blend 10L Golden Tan $30 12
14 PP36902 Slacks, lady's linen blend 10L Lagoon Blue $30 10
15 PP45503 Slacks, men's cotton twill 28/28 Field Khaki $32 10
16 PP45503 Slacks, men's cotton twill 28/30 True Navy $32 12
17 PP45503 Slacks, men's cotton twill 28/32 Dusk Black $32 14
18 PP45503 Slacks, men's cotton twill 30/28 Field Khaki $32 10
19 PP45503 Slacks, men's cotton twill 30/30 True Navy $32 12
20 PP45503 Slacks, men's cotton twill 30/32 Dusk Black $32 14