2 votes 2 votes Which of the following statements regarding database normalization is/are correct? (Mark all the appropriate choices) A relation is in Boyce-Codd Normal Form (BCNF) if and only if every determinant is a super key 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 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 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 Databases go2025-dbms-1 database-normalization easy multiple-selects + – gatecse asked Oct 8, 2020 • edited Oct 8, 2020 by soujanyareddy13 gatecse 283 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes All the options are correct and straight from the definitions. gatecse answered Oct 8, 2020 gatecse comment Share Follow See all 0 reply Please log in or register to add a comment.