GATE CS 2017 (Forenoon) — Question 16

Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesMCQ1 mark · −1/3 if wrongMedium

The following functional dependencies hold true for the relational schema R{V, W, X, Y, Z}: \(V \rightarrow W\) \(VW \rightarrow X\) \(Y \rightarrow VX\) \(Y \rightarrow Z\) Which of the following is irreducible equivalent for this set of functional dependencies?
  1. A
    \(V \rightarrow W\) \(V \rightarrow X\) \(Y \rightarrow V\) \(Y \rightarrow Z\)
  2. B
    \(V \rightarrow W\) \(W \rightarrow X\) \(Y \rightarrow V\) \(Y \rightarrow Z\)
  3. C
    \(V \rightarrow W\) \(V \rightarrow X\) \(Y \rightarrow V\) \(Y \rightarrow X\) \(Y \rightarrow Z\)
  4. D
    \(V \rightarrow W\) \(W \rightarrow X\) \(Y \rightarrow V\) \(Y \rightarrow X\) \(Y \rightarrow Z\)
Practise the full 2017-FN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on Integrity Constraints & Functional DependenciesTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group