It is possible for a table in 2NF to exhibit transitive dependency,where one or more nonprime attributes functionally determine other nonprime attributes.

Name: It is possible for a table in 2NF to exhibit transitive dependency,where one or more nonprime attributes functionally determine other nonprime attributes.
Brand: Quizplus
Rating: 4.9 (31 reviews)

Question

Quizplus · Accepted Answer

A table in 2NF can still have transitive dependencies, where a nonprime attribute depends on another nonprime attribute, which is a violation of 3NF, not 2NF.

It Is Possible for a Table in 2NF to Exhibit