Ask Question
14 March, 15:59

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.

+3
Answers (1)
  1. 14 March, 16:24
    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?
Get 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 & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers