Question: List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table. 15

 List the non-trivial functional dependencies in the table shown in Figure

List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table.

15 points] An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown in Figure 1 lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. NIN | contract o | hours | eName hNo hLoc 1135 C1024 1057 C1024 1068 C1025 1135 C1025 16 Smith H25 East Kilbride 24 Hocine D H25 East Kilbride 28 White T H4 Glasgow 15 SmithH4 Glasgow Figure 1: Instant Cover's contracts

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!