Skip to content
GATEiit

GATE CSE 2026 Session 1 Q31: Dependency-preserving decompositions for 1NF, 2NF, 3NF, BCNF

Question

In the context of relational database normalization, which of the following statements 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: A, B, C (official GATE 2026 final answer key)

Concept used: 3NF synthesis always preserves dependencies (and so does any weaker form); BCNF sometimes cannot.

First step: Recall the classic BCNF example AB→CAB \to C, C→BC \to B where no BCNF decomposition preserves AB→CAB \to C.

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 2026 Session 1 CS question paper and final answer key, organised by IIT Guwahati. Question paper · Answer key

More Databases PYQs

PracticePractise Databases questions →Full paperAll GATE CSE 2026 Session 1 questions →