A fully normalized database is called
A)first normal form (1NF).
B)second normal form (2NF).
C)third normal form (3NF).
D)forth normal form (4NF).

Question

Quizplus · Accepted Answer

A fully normalized database is in third normal form (3NF), which means that all non-key attributes are functionally dependent on the primary key, and there are no transitive dependencies between non-key attributes. First normal form (1NF) only requires that each column contain atomic (indivisible) values, while second normal form (2NF) requires that all non-key attributes be functionally dependent on the entire primary key. Fourth normal form (4NF) addresses multi-valued dependencies, which are not relevant to a fully normalized database in 3NF.

A Fully Normalized Database Is Called