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.
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
You might also like to view...
Which statement about SATA is true?
A) SATA is an older technology than PATA. B) SATA uses a smaller cable than PATA. C) One motherboard SATA connection supports more attached devices than PATA. D) SATA is a design created by RAMBus.
The following multiversion concurrency control has been proposed.
Reads are satisfied using the (committed) version of the database that existed when the transaction made its first read request. Writes are controlled by long-duration write locks on tables. Does the control always produce serializable schedules? If not, give a nonserializable schedule it might produce.