FIGURE 2 The File Structure for Problems 4-6 PROJ_NUM PROJ_NAME EMP_NUM EMP NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane 101 John D. Newson EE 85.00 13.3 653-234-3245 1 Hurricane 105 David F. Schwann CT 60.00 16.2 653-234-1123 1 Hurricane 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 2 Coast 101 John D. Newson EE 85.00 19.8 653-234-3254 2 Coast 108 June H. Settlemeir EE 85.00 17.5 905-554-7812 3 Satellite 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 3 Satellite 105 David F. Schwann CT 26.00 23.4 653-234-1123 3 Satelite 123 Mary D. Chen EE 85.00 19.1 615-233-5432 3 Satellite 112 Allecia R. Smith BE 85.00 20.7 615-678-6879 4. Identify and discuss the serious data redundancy problems exhibited by the file structure. 5. Looking at the EMP_NAME and EMP_PHONE contents, what change(s) would you recommend? 6. Given your answer to Problem 4, what new files should you create to help eliminate the data redundancies