Difficulty: Easy
Correct Answer: Incorrect — rows are tuples or records; fields are columns
Explanation:
Introduction / Context:
Clear terminology is essential in database design and SQL. Misnaming common concepts such as rows and columns leads to confusion in requirements, schema design, and query writing. This question tests whether calling rows “fields” is acceptable.
Given Data / Assumptions:
Concept / Approach:
In the relational model: rows = tuples (records), columns = attributes. The term “field” informally denotes either a column or, in some contexts, a single data item value at the intersection of a row and a column. It does not denote an entire row. Therefore, the statement that rows are fields is incorrect by standard usage.
Step-by-Step Solution:
Verification / Alternative check:
Look at SQL syntax: INSERT adds a row (tuple); ALTER TABLE ADD COLUMN adds an attribute (field). The operations and documentation consistently differentiate rows and columns.
Why Other Options Are Wrong:
Common Pitfalls:
Using “field” for both a column and a cell; carrying spreadsheet vocabulary to relational database discourse.
Final Answer:
Incorrect — rows are tuples or records; fields are columns
Discussion & Comments