A table in third normal form must not have:
A)Abstractive dependencies
B)Binding dependencies
C)Transitive dependencies
D)Substitutive dependencies

Question

Quizplus · Accepted Answer

A table in the third normal form must not have transitive dependencies. Transitive dependency occurs when a non-key attribute depends on another non-key attribute through a third attribute. It means that some data in the table is redundant and should be removed by splitting the table into multiple tables. Abstractive dependencies and substitutive dependencies are not types of dependencies. A binding dependency is a situation when a non-key attribute depends only on part of the key and is allowed in the third normal form.

A Table in Third Normal Form Must Not Have