An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.

Question

Quizplus · Accepted Answer

A non-key attribute is any attribute that is not a part of the primary key or any candidate key of a relation/table. A non-prime attribute is an attribute that is not a part of any candidate key. Therefore, a non-key attribute must be a non-prime attribute.

An Attribute Is Considered to Be a Non-Key Attribute When