Difficulty: Easy
Correct Answer: None of the above
Explanation:
Introduction / Context:
Precise terminology is essential in the relational model. A table is a relation, rows are tuples, and columns are attributes. Confusing these terms leads to miscommunication when designing schemas, writing SQL, or discussing normalization.
Given Data / Assumptions:
Concept / Approach:
In the relational model: a relation is a set of tuples; each tuple has components corresponding to attributes; each attribute draws its values from a domain. Therefore, the correct term for “fields” of a tuple is attributes. Since “attributes” is missing, the best choice is “None of the above.”
Step-by-Step Solution:
Map table → relation; row → tuple; column/field → attribute.Check options: relation (wrong granularity), domain (value set, not the field itself), queries (unrelated).Because “attribute” is absent, select “None of the above.”Confirm consistency with relational terminology.
Verification / Alternative check:
Intro database texts define attribute as a named column of a relation; the domain is the permissible set of values for that attribute. This validates the reasoning.
Why Other Options Are Wrong:
Relations: the whole table, not a field within a tuple.
Common Pitfalls:
Calling columns “domains.” A domain constrains a column but is not the column.
Final Answer:
None of the above
Discussion & Comments