GATE Overflow Test Series | Databases | Test 1 | Question: 2

Question

Which of the following statements regarding database normalization is/are correct? (Mark all the appropriate choices)

• A. A relation is in Boyce-Codd Normal Form (BCNF) if and only if every determinant is a super key
• B. A relation is in Fourth Normal Form (4NF) if and only if for every nontrivial multi-valued dependency $A \twoheadrightarrow B,$ $A$ is a super key of the relation
• C. A multi-valued dependency (MVD) represents a dependency between attributes $A, B$ and $C$ in a relation such that for each value of $A$ there is a set of values of $B$ and a set of values for $C$ and the set of values of $B$ and $C$ are independent of each other
• D. A lossless-join dependency is a property of decomposition, which means that no spurious tuples are generated when relations are combined through a natural join operation

Answer 1

All the options are correct and straight from the definitions.