Question

The reason why a database table is in the second normal form (2NF), but not in the third form (3NF) is because:

a. There is a non-prime attribute that is transitively dependent on the key of the table.

b. There is a one-to-many relationship embedded in the table.

c. both a. and b.

d. neither a. nor b.

Answer 1

Answer:

Hi!

The correct answer is a. There is a non-prime attribute that is transitively dependent on the key of the table.

Explanation:

By definition, a database table is in 3NF if:

• Is 2NF.

• No nonprime attribute is transitively dependent on any key, this means that no nonprime attribute depends on other nonprime attributes.  Finally, this would mean that all the non-prime attributes must depend only on the keys.