04. Consider the following File Structure: (15 points PROI NUM | PROJ NAME EMP NUM | EMP NAME | JOB CODE | IOB CHG HR | PROJ HR Hurricane 101 ohn D. Hurricane 105 David F Schwann Anne R 60.00 Hurricane 110 ohn D June H. Anne R David F 85.00 19.8 17S 110 62.00 Satellite 105 Mary D 85.00 19.1 Satellite 112 Alicia M. BE 20.7 a. Re-write the above using new file structures that will help to eliminate the data redundancies currently present in the file structure. b. What changes would you make in the new file structure containing EMP NAME, such that one can sort the records alphabetically based on the employee last name