If two attributes, P and Q, satisfy the functional dependencies P → Q and Q → P, then they exhibit:

Correct option is E

When two attributes satisfy both P → Q and Q → P, each attribute functionally determines the other. This type of relationship is known as Mutual Functional Dependency.

It indicates a one-to-one correspondence between the attributes, meaning knowing the value of one attribute uniquely determines the value of the other attribute.

Therefore, the correct answer is Mutual Functional Dependency.

Important Key Points:

1. P → Q means attribute P uniquely determines Q.
2. Q → P means attribute Q also uniquely determines P.
3. When both dependencies exist together, the relationship is called Mutual Functional Dependency.
4. Mutual dependency often indicates a one-to-one relationship between attributes.

Knowledge Booster:

1. (a) Partial Dependency: Incorrect because partial dependency occurs when a non-prime attribute depends on only part of a composite key.
2. (b) Full Functional Dependency: Incorrect because full dependency means an attribute depends on the entire composite key, not mutually on another attribute.
3. (c) Transitive Dependency: Incorrect because transitive dependency involves an indirect dependency such as A → B and B → C leading to A → C.
4. (d) Multivalued Dependency: Incorrect because multivalued dependency occurs when one attribute determines multiple independent values of another attribute.