Database Questions

INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY TOTAL(S) 3 1001 2014-03-08 00:00:00 Myron Orlando 1001 2014-03-08 00:00:00 Myron Orlando 1002 2014-03-08 00:00:00 Leona Dunne 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1004 2014-03-09 00:00:00 Leona Dunne 1004 2014-03-09 00:00:00 Leona Dunne (615)222-1672 Rat-tail file (615)222-1672 Houselite chain saw, 16-in. bar 190 (713)894-1238 Sledge hammer, 16-lb. head 19 (615)894-2285 Claw hammer (615)894-2285 Steel tape, 12-ft. length (615)894-2285 Rat-tail file (713)894-1238 Claw hammer (713)894-1238 Rat-tail file 3 190 2 13 13 3 13 3 13 2 a) What problem would you encounter if you want to list the records by customer's last name and area code? How would you change the file structure to solve the problem? b) Find the data redundancies in the file structure. How can those redundancies lead to data anomalies? What type of anomaly are they