Question 5 ( 10 points) A engineering consultancy firm supplies temporary specialized staff to bigger companies in the country to work on their project for certain amount of time. The table below lists the time spent by each of the company's employees at other companies to carry out projects. The National Insurance Number (NIN) is unique for every member of staff. NIN Hours 616681B 674315A 323113B 616681B Contract No SC1025 SC1025 SC1026 SC1026 72 48 24 24 Employee Name Ali Samer Maher Ali Company ID SC115 SCIIS SC23 SC23 Company Location Nablus Nablus Ramallah Ramallah a) Which normal form this table is in? b) Find the Primary Key for this relation and explain your choice. c) Find the Fully Functional Dependencies on the PK and the Partial Dependencies on the PK d) Normalise the table to 2NF e) Find the transitive dependencies on the 2NF tables Normalise the tables to BNF