Using the database table above:

Based on the table above, identify pairs of columns that for the same value in one column, the 2nd column also has the same value.

These dependencies lead to what redundancies in the table (what data is being stored redundantly)? Do you see any relationship between the pairs of columns that you identified and the occurrence of redundancies?

PROJ NUM PROJ-NAME EM 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite PNUM EMP NAME JOB CODE JOB-CHG-HOUR PROJHOURS EMPPHONE - - - 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. RamorasCT 101 John D. NewsonEE 108 June H. Sattlemeir EE 110 Anne R. RamorasCT 105 David F. SchwannCT 123 Mary D. Chen 112 Allecia R. SmithBE 85.00 60.00 60.00 85.00 85.00 62.00 26.00 85.00 85.00 0.00 13.3 653-234-3245 16.2 653-234-1123 14.3 615-233-5568 19.8 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