Identify and discuss the serious data redundancy problems exhibited by the file structure shown inFigure.

PROJ NUM PROJ NAME EMP NUMEMP NAME JOB CODE JOB_ CHG HOUR PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite 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 EE 112 Allecia R. Smith BE 3 CODE 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 62.00