If the logical data model contains attribute values that depend on an attribute that is not the identifier,then it is in _____.
A)base normal form
B)first normal form
C)non-normal form
D)second normal form
E)third normal form

Question

Quizplus · Accepted Answer

Second normal form requires that all non-key attributes are dependent on the entire key. If an attribute value depends on some part of the key, it violates second normal form. Therefore, if the attribute values depend on an attribute that is not the identifier, it is in Second normal form.

If the Logical Data Model Contains Attribute Values That Depend