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

Database The Relational Model and Normalization Difficulty: Easy
Choose an option
  • A
    Correct
  • B
    Incorrect
  • C
    Only in hierarchical databases
  • D
    Only when columns are part of a key

Answer

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

Discussion & Comments
No comments yet. Be the first to comment!
More Questions from The Relational Model and Normalization
Join Discussion