CITM-001 practice question 6 of 15

In a database, each row is called a

Full set: 80 questions
Answer options
A: record Correct answer
B: column
C: information
Correct Answer:
A. record
Explanation

In the context of a relational database, a table is structured into rows and columns. Each row represents a single, complete data entry or item within the table. This horizontal grouping of related data is formally known as a "tuple" in relational model theory, but is most commonly referred to as a "record." For example, in a table of employees, each row would be a record containing all the information about one specific employee (e.g., their ID, name, and position).

Why Incorrect

B. column: A column (also called an attribute or field) is a vertical entity in a table that contains all the data for a single, specific type of information for all records.
C. information: Information is a broad term for processed and organized data. It is the content of the database, not a specific structural component like a row or record.

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 3, "The Relational Data Model and Relational Database Constraints," Section 3.1, the text states: "Each row in the table represents a collection of related data values... In the formal model, a row is called a tuple... In informal terms, a relation can be thought of as a table of values... A row is also called a record." (p. 60).

2. Ullman, J. D., & Widom, J. (2008). A First Course in Database Systems (3rd ed.). Pearson Prentice Hall. In Chapter 2, "The Relational Model," Section 2.1.2, it is explained: "The rows of a relation, other than the header row, are called tuples. A tuple is a list of values... The term record is an alternative to 'tuple'." (p. 26).

3. MIT OpenCourseWare. (2010). 6.830 Database Systems, Lecture 2: Relational Algebra. Massachusetts Institute of Technology. The lecture notes explicitly map the terminology: "Relation = table", "Tuple = row/record", "Attribute = column/field".

Scroll to Top