b. identify the primary key c. identify ask transitive functional dependencies in the given table. d. Convert the given table to 2NF e. Further convert the table (s) from (d) to 3NF

4. An agency called Instant Cover that supplies insurance for part time/temporary staff working in hotels at Scotland. The table below lists the working hours of these staff at these hotels. The National Insurance Number (NIN) is unique for every staff member. Suppose NIN + contractNo can uniquely identify each row in the given table. The hNo is the hotel number that can uniquely identify each hotel. The hLoc is the hotel location. The contractNo can uniquely identify a hotel. (25 points) contractNo C1024 C1024 C2048 Hours 16 24 NamehNo IhLoc Smith H25 Fast Kilbridge Hocine White Smith H4 Glasgow NIN 1045 1067 H25 H4 East Kilbridge Glasgow 1135 C2048 20 a. Identify all full functional dependencies in the given table