Question

A Second Normal Form does not permit _______ dependency between a non-prime attribute and the relation key.

• A. Partial
• B. Multi
• C. Functional
• D. Valued

Answer 1

The correct option is A Partial

A second normal form does not permit partial dependency between a non-prime attribute and the relation key.

In second normal form, a relation must be in first normal form and relation must not contain any partial dependency. A relation is in 2NF if it has no partial dependency that is no non-prime attribute is dependent on any proper subset of any candidate key of the table.

Partial dependency:-If proper subset of candidate key determines non-prime attribute, it is called partial dependency.