Which normal form requires that no transitive dependencies exist?
A)First Normal Form
B)Second Normal Form
C)Third Normal Form
D)Fourth Normal Form

Question

Quizplus · Accepted Answer

Third Normal Form (3NF) requires that there should be no transitive dependencies in a table. Transitive dependency occurs when a non-key attribute depends on another non-key attribute which itself depends on the primary key. Removing transitive dependencies ensures that data in the table is not duplicated unnecessarily and data anomalies are prevented. First Normal Form (1NF) requires that all entries in a table are atomic (indivisible), while Second Normal Form (2NF) requires that each non-key attribute is dependent on a part of the primary key. Fourth Normal Form (4NF) requires that there should be no multi-valued dependencies in a table.

Which Normal Form Requires That No Transitive Dependencies Exist