Question 31
A relation is in First Normal Form (1NF) if -
1NF requires that every attribute domain contains only atomic (indivisible) values, eliminating composite and multivalued attributes.
A relation is in First Normal Form (1NF) if -
1NF requires that every attribute domain contains only atomic (indivisible) values, eliminating composite and multivalued attributes.
A relation is in Second Normal Form (2NF) if it is in 1NF and has NO -
2NF eliminates partial dependencies-meaning no non-prime attribute is functionally dependent on a proper subset of any candidate key.
Which condition must hold for a relation to be in Third Normal Form (3NF)?
The formal 3NF condition is: for every non-trivial functional dependency X → A, either X is a superkey or A is a prime attribute (belongs to some candidate key). The shortcut 'no transitive dependency' is useful in some settings but is not the complete formal definition.
A relation is in Boyce-Codd Normal Form (BCNF) if, for every non-trivial functional dependency X → Y, -
BCNF requires the determinant X of every non-trivial functional dependency X → Y to be a superkey of the relation. This is stricter than 3NF.
4NF (Fourth Normal Form) is designed to eliminate -
4NF deals with multi-valued dependencies (MVDs: X ->-> Y), ensuring that independent multi-valued facts are stored in separate relations.