Consider a relation schema with functional dependencies: - Candidate key: (P, Q, R) - R - S...
Ola technical mcq question, verified with a worked answer. Free to practise - no sign-up.
Consider a relation schema with functional dependencies:
- Candidate key:
(P, Q, R) R -> SR -> PP -> UU -> P
Since attribute S is functionally dependent on a proper subset (R) of candidate key (P, Q, R), which property is present in this relation?
Show answer & explanation
Answer: A. Multivalued attributes
Accurate technical and quantitative evaluation based on foundational principles.
Step-by-step Derivation:
Step 1: Formulate problem conditions.
Step 2: Apply logical deduction.
Step 3: Conclude correct option.