Using Microsoft Access, how can Jenny identify the redundant attributes in her table and design an efficient database management system?

 

Selling Mary Kay brand cosmetics and beauty aids was Jenny Jones's passion in life. Working with Mary Kay for over 10 years, Jenny had earned herself many accolades. She served one of the largest and most lucrative suburban areas of all Mary Kay sales technicians, the Newtown, Pennsylvania through Princeton, New Jersey area. Jenny was nationally known throughout the most astute Mary Kay circles as being one of the company's top sellers. However, there was one "brass ring" that Jenny had yet to attain...the coveted BIG PINK CAR. In case you are not familiar with this prestigious award, the BIG PINK CAR is only awarded to the Mary Kay sales technician with the highest sales over a fiscal period. It is awarded at a national convention where all the Mary Kay bigwigs hang out. To Jenny, this was her year to go for the gold, or the pink if you will. Jenny had no problem upping her sales to all time high levels and she was well aware of the competition. Knowing that the only way she could lose would be to beat herself, Jenny set out to determine how she needed to clean up her own act to bring home the pink car. After performing a detailed evaluation of all of her strengths and weaknesses, Jenny discovered that, in order to win the award, she would have to become more organized. Presently, Jenny maintained all of her sales records on manually generated carbon sheets. However, Jenny knew that in order to keep up with Mary Kay's high standards and adequately support her claim to the best ride in town, she would have to improve her record-keeping. Jenny decided to use Microsoft Access to maintain her sales records. Each time Jenny made a sale, specific information such as customer name, customer number, address, level of skin sensitivity, order number, product number ordered, product name, unit price, quantity ordered, catalog number ordered from and catalog edition was stored in an Access table. Jenny soon realized that her table included many redundancies. Help Jenny identify the redundant attributes in her table and design an efficient database management system.