1D0-541 practice question 19 of 25

Which three pieces of information did

Full set: 128 questions
Answer options
A: F. Codd describe as necessary to retrieve a data value from a relational database?
B: Attribute, domain, and tuple
C: Entity, relation name, and domain
D: Table name, primary key, and entity Correct answer
E: Attribute, relation name, and primary key
Correct Answer:
D. Table name, primary key, and entity
Explanation

In his seminal 1970 paper, "A Relational Model of Data for Large Shared Data Banks," E. F. Codd established the foundational principles of the relational model. A key feature is that data is addressed by its value, not its physical position. To uniquely identify and retrieve any single data value, three components are necessary: the name of the relation (table), the primary key of the tuple (row), and the name of the attribute (column). The intersection of the row identified by the primary key and the specified column within the correct table pinpoints the exact data value.

Why Incorrect

A. Attribute, domain, and tuple A domain defines the set of permissible values for an attribute; it is a constraint, not a locator. A tuple is the row itself, not the unique identifier (primary key) used to find it.
B. Entity, relation name, and domain An entity is a conceptual object being modeled, whereas the relation name is its logical implementation. A domain is a constraint, not a locator for a specific value.
C. Table name, primary key, and entity An entity is a concept from the Entity-Relationship model, not a direct component for data retrieval in the relational model itself. The table (relation) name is the correct term.

References

1. Codd, E. F. (1970). "A Relational Model of Data for Large Shared Data Banks". Communications of the ACM, 13(6), 377–387. In Section 2.2, "Redundancy and Consistency," Codd discusses the role of primary keys in uniquely identifying tuples within a relation, which is fundamental to retrieving specific data. The model's structure inherently requires the relation name and attribute name to complete the address. DOI: https://doi.org/10.1145/362384.362685

2. Ullman, J. D., & Widom, J. (2002). A First Course in Database Systems. Prentice Hall. In Chapter 2, "The Relational Model," the text explains that a relational database consists of relations (tables), and to access data, one must specify the relation, the attribute(s) of interest, and a condition to identify the specific tuple(s), which is most precisely done using a primary key. (See Section 2.1 "What is a Relational Model?" and Section 2.2 "Defining a Relation Schema").

3. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. Chapter 3, "The Relational Data Model and Relational Database Constraints," clarifies that a relation name, a primary key value, and an attribute name are the coordinates needed to locate any single value in a relational database. (See Section 3.2.2, "Characteristics of Relations").

Scroll to Top