PROJ NUM PROJ_NAME 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. SattlemeirEE 10 Anne R. Ramoras CT 105 David F. Schwann CT D. Chen 12 Allecia R. Smith BE | JOB-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 1.6 615-233-5568 23.4 653-234-1123 191 615-233-5432 20.7 615-678-6879 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite 85.00 60.00 60.00 85.00 85.00 62.00 26.00 85.00 85.00 123 2. Suggest a set of new tables (with sample data set) that can resolve the redundancy and anomalies found in the table in Q1. (20 points)