Normalisation Exercise 3 Proj# Proj_Name Emp# Emp_Name Job_Code Job_Chrg- Hr Proj_Hrs Phone Rain 101 Mike Jackson EE $170 13.3 02 9638 5456 Rain 105 Adam Smith CT $120 16.2 02 9876 2345 Rain 110 George Best CT $120 14.3 02 9777 1234 2 Hail 101 Mike Jackson EE $170 19.8 02 9638 5456 2 Hail 108 Steve Waugh EE $170 17.5 02 9147 2356 3 Flood 110 George Best CT $120 11.6 02 9777 1234 Flood 105 Adam Smith CT $120 23.4 02 9876 2345 3 Flood 123 Magic Johnson EE $170 19.1 02 9876 5432 3 Flood 112 Eddy Hepburn BE $170 20.7 02 9456 4567 The above table was constructed by a consulting organisation to track its client projects; the consulting organisation's employees attached to each client project; their charge-out rate; the number of hours spent on each of the projects by employees; and the employee's phone contact number. The consulting organisation's objective is to be able to cost each of their clients' project for billing purposes. Normalise the table into the third Normal Form (3NF). Create an Entity Relationship Diagram (ERD) to represent the normalised tables. You do not need to include attributes in the ERD but you have to state clearly the cardinality for each relationship