Assuming that the functional dependencies in the relation in Figure 2 will hold for any additional data, which of the following functional dependencies are true and which are false? Justify your answer.

Question

The table below represents data about employees of a company and the projects they work on. An employee may work on one or more projects a certain number of hours

Answer 1

i) projName empNo false; More than one empNo for a projName
ii) projName projBudget true; One projBudget for every projName
iii) projBudget projName false; More than one projName for one projBudget
iv) projName hours false; More than one value of hours for one projName
v) projName projManager true; One projManager for every ProjName
vi) projManager projName false; More than one projName for one projManager
vii) empNo hours false; More than one value of hours for one empNo
viii) (projName, empNo) hours true; One value of hours for the compound value of (projName, empNo)
ix) managerDOB projManager false; More than one projManager for one managerDOB