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.

Question

Quizplus · Accepted Answer

The Answer of 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.

The Table Below Provides Osme Sample Data for an Agency