1. Answer to the questions using the following table (20 points)

(1) What is the identifier in the above table? Make sure that your identifier can uniquely identify each instance(i.e. row) in the above table. (5 points)

(2) Define insertion anomaly in your own words. (5 points) A. Do not use the definition in your note or website. B. Your definition must include the term identifier

(3) How can you describe the insertion anomaly in the above table using the definition you made in (2)? Use some specific examples or business scenarios. (10 points)

PROJ NUM PROJ NAME EMP NUMEMP NAME JOB CODE JOB CHGHOUR PROJ HOURS EMP PHONE 13.3 653-234-3245 6.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 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellte 3 Satellte 3 Satelte 3 Satellite 101 John D. Newson EE 105 David F. Schwann CT 10 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. ChenEE 12 Allecia R. Smith BE 85.00 60.00 60.00 85.00 85.00 62.00 26.00 85.00 85.00