Database

2. An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table 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. (3 points) (a) Identify the functional dependencies represented by the attributes shown in the table. Identify primary keys in your relations (b) Describe and illustrate the process of normalizing the table to 3NF. Be specific for the process of Normalization. NIN contractNo hours eName hNo hLoc 16 Smith H25 East Kilbride 1135 C1024 1057 CI02424 Hocine D H25East Kilbride 1068 C1025 1135 C1025 Hocine D H25 East Kilbride 28 White T H4 Glasgow 15 Smith I H4 Glasgow