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.
What will be an ideal response?
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...
The rectangle that defines an ellipse is called its ________.
a) bounding box b) boundary c) elliptical rectangle d) elliptical box e) ellipse boundary
You can use a form to delete records from a table
Indicate whether the statement is true or false
The properties in the Properties window are in alphabetic order.
Answer the following statement true (T) or false (F)
Which LCD components are powered by a high-voltage electrical circuit that can give you a nasty shock?
A. CCFL frontlights B. Convergers C. Low-voltage b-nodes D. Inverters