What does functional dependence mean? Illustrate with an example
What will be an ideal response?
Functional dependence means that for each value of the table's primary key, there should be just one value for each of the attributes in the record, and that the primary key determines that value. The attribute should be functionally dependent on the value of the primary key. For example, if employee ID is a primary key, then for each value of employee ID, there is exactly one value for each of the attributes included in the record, and the employee ID determines that value.
You might also like to view...
For sales managers to understand how the members of the Reliable Tools sales force spend their time, the salespeople must submit a(n) ________
A) expense report B) time-and-duty analysis C) mobile conferencing schedule D) sales forecast E) incentive plan
For the problem below, what is the quantity assigned to the cell Source 1-Destination 2 using the intuitive method for an initial feasible solution?
A) 1 B) 5 C) 30 D) 45 E) 50