CITM-001 practice question 6 of 15
In a database, each row is called a
Full set: 80 questionsIn 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).
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.
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".
Keep practicing
Take the free CITM-001 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CITM-001 practice questions
- Question 1Which three are the advantages of Distributed Database? (Choose three)
- Question 2_______________ interdependence occurs when two organizations depend on each other.
- Question 3Which of the following is a sixth step in Systems Design Life Cycle?
- Question 4Information derived from processing transaction reduces uncertainty about a firm's order …
- Question 5Which two management departments are responsible for the success of information processin…
- Question 7How many techniques are available to the design team for collecting data?
