OA. free
Free
Ola Core Computer Science Core Computer Science Medium

Consider the relation schema with functional dependencies: - P, Q - R - R - S - R - T - T -...

Ola technical mcq question, verified with a worked answer. Free to practise - no sign-up.

Consider the relation schema with functional dependencies:

  • P, Q -> R
  • R -> S
  • R -> T
  • T -> U
  • U -> P

Since non-prime attribute U is determined by non-prime attribute T which is determined by R, which dependency is present in this schema?

Choose one option.
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.