The table below provides osme sample data for an agency called Hotel Services supplies part- time/temporary staff to hotels within Strathclyde region. The relation in Figure 2 lists the number of hours worked by each staff at various hotels. The relation
is first normal form (1NF). Assuming that a contract is for one hotel only but a staff may work in more than one hotel on different contracts, identify the functional dependencies represented by the data in this relation.
Functional dependencies
(NIN, contractNo) ----> {hours, eName, hNo, hLoc}
(NIN, hNo) -----> {contractNo, hours, eName, hLoc)
contractNo -----> {hNo, hLoc}
hNo -----> hLoc
NIN ------> eName
You might also like to view...
Which of the following does NOT indicate that a website is secure?
A) A closed padlock appears in the toolbar. B) The address bar is colored in green. C) The Microsoft seal displayed on the toolbar. D) The URL begins with https://.
An administrator logs into the vSphere Web Client, but is unable to see any hosts and clusters. Which two options could fix the problem? (Choose two.)
A. Verify that the client web browser and vCenter Server are in the same broadcast domain. B. Verify that the vCenter Server system is registered with the same Platform Services Controller as the vSphere Web Client. C. Log in to the vCenter Server as a user within the Active Directory domain. D. Log in to the vSphere Web Client as a user with permissions on the vCenter Server system.