Question

4. An attribute of a table cannot have transitive

dependency is the property of
A. First normal form (1NF)
B. Second normal form (2NF)
C. Third normal form (3NF)
D. None of the Above

Answer 1

Transitive dependency is eliminated in the Third normal form (3NF) of database normalization, which ensures that all attributes are directly dependent on the primary key.

Step-by-step explanation:

An attribute of a table cannot have transitive dependency in the Third normal form (3NF). When we normalize databases, we try to reduce the redundancy and dependency of data. The First normal form (1NF) eliminates duplicate columns from the same table. The Second normal form (2NF) takes care of reducing redundancy by making sure that all attributes are dependent on the whole primary key when the key is composite. Finally, 3NF comes into play to ensure that all attributes are directly dependent only on the primary key, thereby removing transitive dependency, which is when an attribute dependency is indirectly caused by another non-primary key attribute.