Question

In ________ normal form, non-primary key attributes do not depend on each other (what we call no transitive dependencies).

A) First
B) Fourth
C) Third
D) Second"

Answer 1

C) Third. In Third normal form, non-primary key attributes do not depend on each other.

Step-by-step explanation:

In Third normal form, non-primary key attributes do not depend on each other (what we call no transitive dependencies).

In this normal form, each column in a table depends on the primary key of the table, and nothing but the primary key. If a column has a dependency on another non-primary key column, then it violates the Third normal form.

For example, let's say we have a table called 'Students' with columns like 'StudentID' (primary key), 'StudentName', and 'Class'. In the Third normal form, the 'Class' column should only depend on the 'StudentID' column, and not on the 'StudentName' column. If the 'Class' column depends on the 'StudentName' column, then it violates the Third normal form.