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...
Explain why context is a critical first step in tailoring.
What will be an ideal response?
In pseudocode, which statement is used to show the stopping point of a loop structure?
A. stop B. endwhile C. endif D. exitwhile
In a set of two radio buttons with the name "gender", the expression gender[1] would refer to the first element of the two-button array
Indicate whether the statement is true or false
A ____ is a group of related web pages that are linked together and share a common interface and design.
A. web browser B. web tool C. web code D. website