Ask Question
16 June, 14:22

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)
  1. 16 June, 17:55
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers