Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started