Case Study:
Fairstone Manufacturing Inc.
You need to address the Sales Director’s requirements regarding the customer classification. You need to
recommend a solution for changing the classifictaions. What should you recommend?
A.
Add each classification change to a new row in the Customers table.
B.
Record each change to the classification of each customer in a new row in the Customers table.
C.
Add a new row to the Customers table for each new classification.
D.
Record each change to the classification of each customer in a new table in the Customers database.