Relational model terminology: In a relational schema, each tuple is divided into fields that are properly called what?
-
ARelations
-
BDomains
-
CQueries
-
DAll of the above
-
ENone of the above
Answer
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:
- The question asks for the proper name of the fields that subdivide a tuple.
- Standard relational terms: relation (table), tuple (row), attribute (column), domain (set of allowable values of an attribute).
- “Attribute” is not listed among the answer choices.
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.
Domains: value sets, not the fields themselves. Queries: operations over relations, not structural components. All of the above: mutually inconsistent and incorrect.Common Pitfalls: Calling columns “domains.” A domain constrains a column but is not the column.
Final Answer: None of the above