Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.2 below 6. FIGURE P1.2 The File Structure PROJ-NUM | PROJ-NAME 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite | EMP-NUM | EMP-NAME 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. Ramoras CT 101 John D. Newson EE 108 June H. Sattlemeir EE 110 Anne R. Ramoras CT 105 David F. Schwann CT 123 Mary D. Chen 112 Allecia R. Smith BE | JOBCODE | JOB-CHG-HOUR | PROJ-HOURS | EMP-PHONE 13.3 653-234-3245 16.2 653-234-1123 14.3 615-233-5568 19.8 653-234-3254 17.5 905-554-7812 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 85.00 60.00 60.00 85.00 85.00 62.00 26.00 85.00 85.00 7. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.2, what change(s) would you recommend