1. Answer to the questions using the following table (20 points) EMP NAME Je cODE 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R.Ramoras CT 101 JohD Newson 8500 6000 60.00 85.00 85.00 6200 26.00 85.00 85.00 Hurricne 162 653-234-1123 Humicane Hurricane 2 Coast 19.8 653-234-3254 175 905-554-7812 Coast 3 Satelite 3 Setelite 3 Satelite 3 Satelite 110 Anne R. Ramoras CT 105 David F. Schwann CT 123 Mary D. Chen 112 Alecia R. Smth BE 234 653-234-1123 (c) What is the identifier in the above table? Justify your answer based on the definition of the identifier. (5 (2) What is insertion anomaly? How is it related with the (3) How can you describe the insertion anomaly in the points) identifier? (5 points) above table using the identifier you have found in (1)? Use some specific examples or business scenarios. (10 points) 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)