Relational vocabulary: in a relation, are columns sometimes called “attributes” (the formal term in the relational model)?

Difficulty: Easy

Correct Answer: Correct

Explanation:


Introduction / Context:
Terminology matters in data modeling. The relational model uses the term “attribute” to refer to what many SQL tools and users call a “column.” This question checks recognition of the formal term.



Given Data / Assumptions:

  • We are discussing the relational model, not specific vendor terminology.
  • “Attribute” is the formal name; “column” is the common name.
  • The statement says “sometimes called ‘attributes’,” acknowledging both usages.


Concept / Approach:
In the relational model: table → relation, row → tuple, column → attribute. Using “attribute” emphasizes that each column draws values from a defined domain (type) and participates in constraints such as keys and dependencies.



Step-by-Step Solution:

Map everyday terms to formal terms: column → attribute.Confirm that documentation on normalization and dependencies uses “attribute.”Therefore, the statement is correct.


Verification / Alternative check:
Review any normalization discussion; you will consistently see “attribute” used.



Why Other Options Are Wrong:

  • “Incorrect” conflicts with the widely accepted terminology.
  • Mentions of other models or key membership are irrelevant to naming.


Common Pitfalls:
Thinking that “attribute” and “column” have different meanings; in relational theory they correspond.



Final Answer:
Correct

More Questions from The Relational Model and Normalization

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion