List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table.

Modify the table to be in Boyce-Codd normal form.

Display the data in Figure 1 using the tables in Boyce-Codd normal form.

15 points] An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown in Figure 1 lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. NIN | contract o | hours | eName hNo hLoc 1135 C1024 1057 C1024 1068 C1025 1135 C1025 16 Smith H25 East Kilbride 24 Hocine D H25 East Kilbride 28 White T H4 Glasgow 15 SmithH4 Glasgow Figure 1: Instant Cover's contracts