QuestionJune 29, 2025

Given an entity that has only candidate keys with 4 or more attributes, it is usually recommended to create a surrogate key for the entity. True False

Given an entity that has only candidate keys with 4 or more attributes, it is usually recommended to create a surrogate key for the entity. True False
Given an entity that has only candidate keys with 4 or more attributes, it is usually recommended to create a surrogate key for the entity.
True
False

Solution
3.7(329 votes)

Answer

True Explanation 1. Understand Candidate Keys Candidate keys are minimal sets of attributes that can uniquely identify a tuple in a relation. 2. Analyze the Recommendation Surrogate keys are often used when candidate keys are complex or large, as they simplify indexing and improve performance. 3. Evaluate the Statement If all candidate keys have 4 or more attributes, using a surrogate key is recommended for simplicity and efficiency.

Explanation

1. Understand Candidate Keys<br /> Candidate keys are minimal sets of attributes that can uniquely identify a tuple in a relation.<br /><br />2. Analyze the Recommendation<br /> Surrogate keys are often used when candidate keys are complex or large, as they simplify indexing and improve performance.<br /><br />3. Evaluate the Statement<br /> If all candidate keys have 4 or more attributes, using a surrogate key is recommended for simplicity and efficiency.
Click to rate:

Similar Questions