Skip to content
GATEiit

GATE CSE 2024 Session 1 Q44: Valid inferences of functional dependencies

Question

The symbol →\to indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?

Try it: multiple select: one or more correct options

Select one or more options
Select all correct options. No negative marking, no partial marks.
Show answer and explanation

Answer: B, C, D (official GATE 2024 final answer key)

Concept used: Armstrong's axioms: decomposition, pseudo-transitivity and transitivity are sound; shrinking the left side is not.

First step: Check each option against a known rule; for (A), look for a relation where XX alone does not fix ZZ.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

WhatsAppDownload image

Source: official GATE 2024 Session 1 CS question paper and final answer key, organised by IISc Bangalore. Question paper · Answer key