Saying that two entities are functionally dependent means that ________.
A)the entities are always connected by a mathematical equation
B)for one of the entities,if we are given the value of that entity,we can determine the value of one other entity
C)for both of the entities,if we are given the value of one entity,we can determine the value of the other entity
D)the functional dependency will have to be removed through normalization

Question

Quizplus · Accepted Answer

Functional dependency means that the value of one entity determines the value of another entity. In option B, it is stated that if we are given the value of one entity, we can determine the value of one other entity. Therefore, option B is the correct choice. Option A is incorrect as not all functional dependencies are expressed as mathematical equations. Option C is incorrect as it is not necessarily true for both entities to be dependent on each other. Option D is also incorrect as normalization is a process of eliminating redundancy in data and not necessarily removing functional dependencies.

Saying That Two Entities Are Functionally Dependent Means That ________