I am not too familiar with Microsoft Access, the software needed to develop a table for this problem. Was wondering if I could get some help.
Mary Kay Cosmetics 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.Order# Date Customer# Name Address Sensitivity Product# Product Quantity | Unit Price Catalog# Edition 34 4/16/2010 270 Nancy Miller 6 Hollywood Dr Low 220 Ruby red long- lasting lipstick 25 1215 Christmas in the City! 35 4/22/2010 210 Crissy Smith 20 Park Ave. High 310 Astringent 2 18 1215 Christmas in the City! Neutral hues 36 4/28/2010 250 Dee Dee Jones 54 Candle Dr. Low 340 cream eye 15 1216 Beating Old Man Winter! shadow 37 5/2/2010 410 Gerry McMann 9 Willow Dr. Average 560 Anti-aging cream 19 1217 Spring has Sprung! 38 5/10/2010 400 Gisele Hughs 89 Winder Dr. Low 640 Sparkles body glitter 7 28 1215 Christmas in the City! 39 4/6/2010 300 Jenny Lowt 43 Summit Rd. High 760 Exfoliating 12 1218 cream Here Comes Summer! 40 5/12/20 10 300 Jenny Lowt 43 Summit Rd. High 980 Make-up remover pads 2 12 1218 Here Comes Summer! 41 5/1 8/2010 200 Jill Worth 111 Main St High 220 Ruby red long- lasting lipstick 2 16 1216 Beating Old Man Winter! 42 6/1/2010 100 Mary Decker 234 South St. Average 310 Astringent 3 18 1216 Beating Old Man Winter! Neutral hues 42 6/1/2010 100 Mary Decker 234 South St. Average 340 cream eye 2 15 1217 Spring has Sprung! shadow 43 6/10/2010 210 Crissy Smith 20 Park Ave. High 310 As trigent 2 18 1215 Christmas in the City
