GATE CS 2024 (Forenoon) — Question 44

Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesMSQ2 marksMedium

The symbol \( \rightarrow \) indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
  1. A
    \( (X, Y) \rightarrow (Z, W) \text{ implies } X \rightarrow (Z, W) \)
  2. B
    \( (X, Y) \rightarrow (Z, W) \text{ implies } (X, Y) \rightarrow Z \)
  3. C
    \( ((X, Y) \rightarrow Z \text{ and } W \rightarrow Y) \text{ implies } (X, W) \rightarrow Z \)
  4. D
    \( (X \rightarrow Y \text{ and } Y \rightarrow Z) \text{ implies } X \rightarrow Z \)
Practise the full 2024-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