Question: Right now I am stuck on questions B and E. Any help is appreciated! PART II: An agency called Instant Cover supplies part-time/temporary staff to

Right now I am stuck on questions B and E. Any help is appreciated!
PART II: 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. 1NF: (NIN, contractNo, hours, eName, hNo, hLoc) a) List the functional dependencies; every attribute in the relation "1NF" is part of a dependency. (5 points) b) Which of the nonkey attributes are not dependent on the whole primary key (i.e., are part of partial dependencies)? (5 points) c) What are the transitive dependencies? (5 points) d) 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) e) For each relation you created for 3NF, list the FK per relation (if an FK exists). (5 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
