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.

Question

Matthew Mooney

Computers & Technology

3 May, 17:37

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.

+1

Answers (1)

Know the Answer?

Serena · Answer 1

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.

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.