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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!