PART III (25 points) - normalization: An agency called instant Cover supplies part-time/temporary staff to hotels within Scotland. The table below displays sample data, which lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. \"MERE- F: (A, contractNo, hours, eName, hNo, hLoc) H Z List the functional dependencies; every attribute in the relation \"1NF\" is part of a dependency. (5 points) Which of the nonkey attributes are not dependent on the whole primary key (i.e., are part of partial dependencies)? (5 points) What are the transitive dependencies? (5 points) Remove the partial and transitive dependencies to show 3NF relations. Write the 3rd normal form in relations format where the PK is underlined. (5 points). Make sure to use the relation notation of: entityname(attribute1, attribute2, attribute3, etc). If the PK is a composite key, make sure to underline all attributes involved. E. For each relation you created for 3NF, list the FK per relation (if an FK exists). (5 points). pow>