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.

![15243|558x254](upload://o0S8DZTBogQwQBH4CC1jNI0nyKz.png)


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

Computer Science & Information Technology

You might also like to view...

Which of the following are valid template prefixes?

a. template b. template c. template d. all of the above e. none of the above

Computer Science & Information Technology

Always follow an interview up with a ______________letter.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Describe the five activities associated with the software measurement process.

What will be an ideal response?

Computer Science & Information Technology

A(n) ___________________has two distinct endpoints.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology