Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?

Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?

Madera has asked you, an IT consultant, whether a set of codes would be advantageous. What codes would you suggest? Provide at least two choices for a customer code and at least two choices for a product code.

Be sure to describe your choices and provide some specific examples. Also include an explanation of why you selected these particular codes and what advantages they might offer.