?DATA BASE DESIGN THANKS

Part-I: Chapter One Answer the questions, based on the given file structure. TOTAL(S) 190 - N & INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY 1001 2014-03-08 00:00:00 Myron Orlando (615)222-1672 Rat-tail file 1001 2014-03-08 00:00:00 Myron Orlando (615)222-1672 Houselite chain saw, 16-in. bar 190 1002 2014-03-08 00:00:00 Leona Dunne (713)894-1238 Sledge hammer, 16-lb. head 19 1003 2014-03-08 00:00:00 Kathy Smith (615)894-2285 Claw hammer 1003 2014-03-08 00:00:00 Kathy Smith (615)894-2285 Steel tape, 12-ft. length 1003 2014-03-08 00:00:00 Kathy Smith (615)894-2285 Rat-tail file 1004 2014-03-09 00:00:00 Leona Dunne (713)894-1238 Claw hammer 1004 2014-03-09 00:00:00 Leona Dunne (713)894-1238 Rat-tail file asawa - - - 1. 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? 2. Find the data redundancies in the file structure. How can those redundancies lead to data anomalies? What type of anomaly are they? 3. Is it possible to insert the data of a new product that has not been in the market yet? What type of anomaly is this? 4. What will happen to the record of the customer Kathy Smith, if we delete the invoices 1003? What type of anomaly is this? 5. Identity the various data sources (subjects) in the file. 6. Based on the answer to Problem 5, what files would you create to solve the data redundancies and data anomalies you have found in Problems 2-4