1. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. FIGURE P1.5 The File Structure for Problems 5-8 PROJ NUM PROJ NAME EMP NUM 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast EMP NAME 101 John D. Newson 105 David F. Schwann CT 110 Anne R. Ramoras 101 John D. Newson JOB CODE JOB CHO HOUR PROJ HOURS EMP PHONE 85.00 13.3 653-234-3245) 60.00 16.2 653-234-1123) 60.00 14.3 615-233-5568 85.00 198 653-234-3254 2 Coast 108 June H. Settlemer EE 85.00 17 5 905-554-7812 3 Satelite 110 Anne R. Ramoras 62.00 11.6 615-233-5568 3 Satelite 3 Satelite 105 David F. Schwann CT 123 Mary D. Chen 26.00 23.4 653-234-1123) 85.00 19.1 615-233-5432) 3 Satelite 112 Alecia R. Smith BE 85.00 20.7 615-678-6879 #558855EE a) Looking at the EMP NAME and EMP PHONE contents in Figure P1.5, what change(s) would you recommend? b) Identify the various data sources in the file you examined in Problem 1. c) Given your answer to Problem b), what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?