Concept drill
dependency preservation
GATE CSE & IT · Normalization · 1994-2026
4
PYQs
100%
keyed
0
elite explanations
4
years appeared
Study anchor
Korth — Database System Concepts
Relational model, SQL, normalization, transactions
Practice action
Start latest PYQPYQs in this concept
All concepts →2026 PYQ
In the context of relational database normalization, which of the following statements is/ are true?
easyanswer keybasic explanation
2019 PYQ
Let the set of functional dependencies F = {QR → S, R → P, S → Q} hold on a relation schema X = (PQRS). X is not in BCNF. Suppose X is decomposed into two schemas Y and Z, where Y...
mediumanswer keybasic explanation
2001 PYQ
$$R(A,B,C,D)$$ is a relation. Which of the following does not have a lossless-join, dependency preserving $$BCNF$$ decomposition?
mediumanswer key
1994 PYQ
State True or False with reason. There is always a decomposition into Boyce-codd normal form $$(BCNF)$$ that is lossless and dependency preserving.
easyanswer key