QUESTION 26
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
A. second normal form
B. first normal form
C. third normal form
D. fourth normal form
Correct Answer: A
范式说明:
‘First Normal Form’ (1NF) results in a relation with no multivalued attributes.
‘Second Normal Form’ (2NF) results in a relation with no partial functional dependencies.
‘Third Normal Form’ (3NF) results in a relation with no transitive functional dependencies (functional dependency between two non-keys attributes).
‘Boyce-Codd Normal Form’ is achieved by removing the remaining function dependencies after 3NF.
‘Fourth Normal Form’ results in a relation with no multivalued dependencies.
‘Fifth Normal Form’ is achieved with removing of all the remaining anomalies.