According to the "preferably single-attribute" characteristic of a primary key, the primary key:
A) must be able to guarantee unique attribute values.
B) should have the minimum number of attributes possible.
C) should have embedded semantic meaning associated with each attribute.
D) must be composed of attributes that are free from security risks or violations.

Question

Quizplus · Accepted Answer

The "preferably single-attribute" characteristic implies that the primary key should have the minimum number of attributes possible, meaning it should ideally be composed of only one attribute. This helps in ensuring simplicity and ease of use, as well as making it easier to guarantee unique attribute values. Therefore, option B aligns best with this characteristic. Option A also aligns with the characteristic, but it is not specific enough to be the best choice, as other options may still have unique attribute values. Options C and D contradict the characteristic, as having embedded semantic meaning or being free from security risks do not necessarily align with the concept of a "preferably single-attribute" key.

According to the "Preferably Single-Attribute" Characteristic of a Primary Key