Relational terminology mapping: In database theory and SQL practice, the word “table” is synonymous with which formal term?

Difficulty: Easy

Correct Answer: relation.

Explanation:

Introduction / Context:Relational databases have a precise vocabulary. Mapping common SQL terms to their theoretical counterparts helps avoid ambiguity, especially in normalization and dependency discussions.

Given Data / Assumptions:

  • SQL term “table” corresponds to a theoretical concept.
  • “Row” and “column” also have formal names.

Concept / Approach:“Relation” is the formal term for a table. A row is a “tuple,” and a column is an “attribute.”

Step-by-Step Solution:

Table → Relation.Row → Tuple.Column → Attribute.

Verification / Alternative check:Standard texts (Date, Ullman, Ramakrishnan & Gehrke) use this mapping.

Why Other Options Are Wrong:Record / field: Common in older file systems terminology. Column / tuple: Refer to components of a relation, not to the relation itself.

Common Pitfalls:Intermixing file-system and relational terms can obscure theoretical properties and constraints.

Final Answer:relation.

More Questions from The Relational Model and Normalization

Discussion & Comments

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