GATE CS 2017 Set 1 — Question 43

Multiple choice 2 marks Question 43 2017

Question 43

MCQ 2 marks · −0.66 Databases

The following functional dependencies hold true for the relational schema \(R\{V, W, X, Y, Z\}\):

V  -> W
VW -> X
Y  -> VX
Y  -> Z

Which of the following is irreducible equivalent for this set of functional dependencies?

A \(V \rightarrow W,\; V \rightarrow X,\; Y \rightarrow V,\; Y \rightarrow Z\) B \(V \rightarrow W,\; W \rightarrow X,\; Y \rightarrow V,\; Y \rightarrow Z\) C \(V \rightarrow W,\; V \rightarrow X,\; Y \rightarrow V,\; Y \rightarrow X,\; Y \rightarrow Z\) D \(V \rightarrow W,\; W \rightarrow X,\; Y \rightarrow V,\; Y \rightarrow X,\; Y \rightarrow Z\)

Answers and explanations are free — they just need an account.

Where this question comes from

GATE CS — Computer Science & IT 2017 Databases

Source: GATE 2017 Computer Science and Information Technology, Set 1 (question number approximate)

GATE CS 2015 Set 3 — Question 54
GATE CS 2019 — Question 35
GATE CS 2020 — Question 47
GATE CS 2015 Set 2 — Question 34
GATE CS 2020 — Question 14
GATE CS 2014 Set 2 — Question 30
GATE CS 2005 — Question 21
GATE CS 2015 Set 2 — Question 42

All Databases questions

The answer and the full explanation are one sign-in away

Where this question comes from

More questions from Databases