Which of the following is consistent with this instance of R(X, Y, Z): (1, 1, a), (1, 1, a), (2, 1, b), (3, 2, b)?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. X → Y, X → Z
Explanation
Equal X values always have equal Y and Z, so X → Y and X → Z hold. Z = b appears with X = 2 and 3 (Z → X fails), and Y = 1 appears with X = 1 and 2 and Z = a and b (Y → X and Y → Z fail).
More Database Management Systems questions
- R1(Name, Class) = {(a1, 9), (b1, 5), (c1, 6), (d1, 11)} and R2(Name, Class) = {(b1, 5), (f1, 8)}. Which operation produces the output {(b1,…
- Match List I and List II
- Which relational algebra query computes the names of sailors who have reserved all boats?
- Which relational algebra query computes the names of sailors who have reserved a red and a green boat?
- Let R(ABCDEFGH) be a relation schema and F = {A → B, ABCD → E, EF → G, EF → H, ACDF → EG}. The minimal cover of this set of dependencies is
- A trigger is