f a field is the primary key of a table, then the value in that field must be unique.Question 5Select one:TrueFalse

Final Answer

True

In relational database design, a primary key is a specific choice of a minimal set of attributes (fields) that uniquely identify a record in a table. For a field to be designated as a primary key, it must fulfill two primary conditions:

1. Uniqueness: Each value in the primary key field must be unique across all records in the table. This ensures that no two records can be exactly the same with respect to the primary key, which is crucial for identifying records distinctly.

2. Non-Nullability: The primary key cannot contain null values because a null value means the absence of a value, and it would be impossible to identify a record uniquely if the primary key could be null.

Thus, due to these conditions, the statement that "if a field is the primary key of a table, then the value in that field must be unique" is indeed true.